just a thought... if you're on 10G, OMF splits them up in a pretty
reasonable way:
(1) datafiles (& tempfiles), block change tracking files (new rman
feature) - db_create_file_dest
(2) multiplexed redo logs & control files -
db_create_online_log_dest_#
(3) archive logs, flashback logs, & rman backups -
db_recovery_file_dest
i thought the chapter in the 10G admin guide on OMF (ch 11) was very
informative and worth reading... thought it had some good ideas about
file layouts for DB's of different sizes... and you can read it for
free off of OTN ~
/js
Jeremy Schneider
Database/Systems Administrator
The ASU Group - IS Dept
>>> Wim Coekaerts <wim.coekaerts@oracle.com> 08/23/2004 8:51:07
PM >>>
remember that even tho you have a filesystem etc it's always good to
have seperate partitions for stuff. eg don't put all your redologs and
mirrors on the same partition or don't put your archives on the same
partition as data.
this is not just for ocfs, but just .. common sense I think to split
stuff up.
This message (including any attachments) contains confidential information
intended for a specific individual(s) and purpose, and is protected by law. If
you are not the intended recipient, you should delete this message. Any
disclosure, copying, or distribution of this message, or the taking of any
action based on it, by anyone other than the intended recipient(s), is strictly
prohibited.
<<<<...>>>>