Managing Redo Log Files with OMF

With OMF, maintenance of the redo log files is simplified. Complete groups can be added with no file specifications provided simply with the following command:

					ALTER DATABASE ADD LOGFILE;
				

To take advantage of this feature, you need to have the DB_CREATE_ONLINE_LOG_DEST_n initialization parameter set. To take advantage of duplexing the redo log files, you need not only DB_CREATE_ONLINE_LOG_DEST_1 to be set but also DB_CREATE_ONLINE_LOG_DEST_2 (more if you are going to be placing members on more than two different devices).

If a group is dropped, all the corresponding OMF files are dropped at the operating system level.

Archived redo log files cannot be OMF files. A specific file system location needs to be created ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.