Re: can datafile and logfiles be store on raw disk?

In article <D80t8E.HwM_at_crash.cts.com>, jimt_at_bluebird.com says...

>Can datafiles and or logfiles be stored on raw disk? All the examples
>I have seen only show them stored in file system.
 

>Thanks

You certainly can. If you run oracle in parallel mode, I think you *have* to use a raw device. One of the advantages to this is since oracle can right directly to disk, it avoids the additional overhead of using the OS (in my case AIX) to right to disk and therefore increases performance. Management of the database is a little more tricky though, because it isn't as easy to add another datafile to a tablespace with raw partitions. Moving tablespaces around can be a chore. Backup and recovery plans will need some revising too.

Another thing is that you have to put *all* the database on the raw device. To my knowledge you can't have your database on a raw device and then mirror the redo logs and control files to a file system. (If anyone knows different, I'd like to know).

If you have ORACLE7 Server Administraion Guide or if you can get your hands on a copy of ORACLE7 Parallel Server Administration Guide, you'll get some good info there.

For running oracle in exclusive mode, I don't know if you can use a raw device.

Hope this helps.

Doris Received on Thu May 04 1995 - 00:00:00 CEST