Purpose of Online Redo Log Files
Redo log files provide a means and a mechanism for allowing Oracle to redo transactions in the event of a database failure. Every transaction that occurs that alters data in any way on the database (other than transactions such as direct loads, direct reads, and loads that are done with NOLOGGING option) is written synchronously to the redo log files to provide a recovery mechanism in the case of media or other system failure. This includes even transactions that have not been committed, undo segment information, and any schema and object management statements for objects in the database.
Redo log files are used in situations where instances fail. They are used so that you can recover data that had already been ...
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.
