Re: oracle on raw devices

In article <3a780d10.14246461_at_news-server>,   nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) wrote:
> On Tue, 30 Jan 2001 16:58:25 -0500, Maciej Kwapulinski
> <pikpok_at_univ.gda.pl> wrote:
>
> >I thought the same as you are telling me now so I decided to create
 tablespaces
> >in row partitions only.
>
> May I offer a suggestion?
>
> Put the redo log files in raw partitions and the tablespace files in
> normal filesystems.
>
> You'll gain more by that than the other way around.
>
> >I assumed, that the tablespaces are the .dbf files , for exmaple :
> >system01.dbf
>
> Not exactly. The tablespaces are not the files. The files are
> assigned to a tablespace to make up its addressable disk space.
> Slightly different. But yes, system01.dbf would be a file assigned to
> your SYSTEM tablespace. It could be called anything else. It's just a
> filename, not a *fixed* name that must always be used with that
> tablespace.
>
> >
> >I created 4 raw partitions with apriopriate sizes
> >c2t0d0s[3456]
> >
> >I created file named 'mapping_ascii', which included lines :
> >
> >/aw/oracle_new/oradata/dpikpok/system01.dbf /dev/rdsk/c2t0d03
> >/aw/oracle_new/oradata/dpikpok/users01.dbf /dev/rdsk/c2t0d04
> >/aw/oracle_new/oradata/dpikpok/rbs01.dbf /dev/rdsk/c2t0d05
> >/aw/oracle_new/oradata/dpikpok/temp01.dbf /dev/rdsk/c2t0d06
> >
> >I export(ed) the environment variable DBCA_RAW_CONFIG which pointed
 on
> >'mapping_ascii" file
> >
> >then I started dbassist and created database with name 'dpikpok'
> >and it created these table spaces on ufs filesystem instead of
 creating
> >it on raw devices
> >
> >what am I doing wrong ?
> >
>
> Whoa! You don't use raw files like that!
>
> When you create the database, if you want to give a raw partition to a
> tablespace instead of a filesystem file, you *write* the raw partition
> device as the file name! IOW, you'd use '/dev/rdsk/c2t0d03' as the
> filename for the tablespace file.
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html

Much better if you use symbolic links pointing to raw partitions and then add these symbolic links as files to your tablespace.

Regards,
Ashish

>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 31 2001 - 08:45:18 CST