Search notes:

Oracle managed files (OMF)

The goal of Oracle managed files is to simplify the work of a DBA. With OMF, files needed by Oracle are automatically created (named and stored in a location) and deleted.

With OMF enabled, the following database structures are managed by OFM

Data files
Redo log files
Control files
Archived logs
Block chaning tracking files
Flashback logs
RMAN backups

Files that are controlled by OFM include

Trace files
Audit files
Alert logs
Core files
Password files (?)

The following three init parameters enable OMF:

`db_create_file_dest`
`db_create_online_log_dest_{1…5}`	Allows to override the location of `db_create_file_dest` for redo log files and control files
`db_recovery_file_dest`	Fast recovery area

OMF can be used on top of traditional filesystems such as VxFS or ODM.

OMF can be used with the fast recovery area.

Oracle managed files (OMF)

See also