Archived Redo Log Files
Filled redo log files can, optionally, be archived. One of the most important decisions that any DBA has to make is whether to configure the database to operate in ARCHIVELOG mode or NOARCHIVELOG mode.
NOARCHIVELOG Mode
If your database is running in NOARCHIVELOG mode, as the online redo log files are cycled, they are overwritten automatically. LGWR does not overwrite the redo log group until a checkpoint has been completed, but it does not have to incur the added overhead of having to allow the archiving of the redo log groups before the groups can be overwritten. This limits the amount of overhead that has to occur on a log switch.
Typically, you only want to run a database in NOARVHIVELOG mode if you are sure that you ...
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.
