Discussion of The OMF concept

[pissallio]

What's the benefit of using OMF ?

Here is additional two puzzles i have met with:
If I want to use OMF, Do i have to define the "DB_CREATE_ONLINE_LOG_DEST_N" and "DB_DATA_FILE" parameter in the initSID.ora file first ?

When create a database using "create database" command, I intend not to define the "CONTROL_FILES" parameter in order to use the control files which is created by the system itself. In which directory will the system-created-control files reside ?

Thanks in advance.

 

[vivekm]

OMF is a huge topic and if you want to view the benefits, then have a look at

https://cwisdb.cc.kuleuven.ac.be/ora10doc/server.101/b10739/omf.htm

If you do not specify CONTROL_FILES parameter, then the filename of the control file and the location is specific to the Operating System. Please see documentation for release of your platform.

Thanks,
Vivek