Hi Brian,
Raw devices:
- yes, they do need to be owned by oracle, group dba
- For CREATE TABLESPACE , make sure
you use the REUSE clause. The syntax would be
create tablespace raw_data datafile '/dev/rdsk/c2t4d9s2' size 200M REUSE
- As someone else mentioned you can use soft links
In UNIX
ln -s /dev/rdsk/c2t4d9s2 /ora01/db01/mySID/raw_data.001
In Oracle
create tablespace raw_data datafile '/ora01/db01/mySID/raw_data.001' size 200M REUSE ....
- You do not erase raw devices, they just exist, if you drop a tablespace
you can now use the raw device in a different tablespace
- Monitor I/O in the same way as a normal filesystem. This can be done inside
oracle or with UNIX utilities like sar, vmstat or iostat.
- To be safe create your oracle file sizes at least 1MB smaller. If your
raw device is 512MB make the filespec in your create tablespace statement 511MB.
Disk is cheap, time is not. There should be some OS commands to verify
your raw partitions. Ask your sysadmin.
IMPORTANT
- Be careful with dd. A one block mistake can not only fry your database
it can fry the whole machine
HTH
Dave
Dave Morgan
Senior Database Administrator
Internet Barter Inc.
Received on Tue Sep 12 2000 - 09:42:18 CDT
