Oracle Database - Redo Log (Transaction Log Files)

Card Puncher Data Processing

About

transaction log in Oracle are knwon as the redo log.

Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure.

To protect against a failure involving the redo log itself, Oracle Database lets you create a multiplexed redo log so that two or more copies of the redo log can be maintained on different disks.

You can archive them automatically with the archivelog mode.

The archive and table logging mode is what will dictate whether redo is generated for the table or not: Redo Log Bypass Generation

For an index, you can't bypass it: Redo Index

Buffer

The redo log buffer is a circular buffer in the SGA (based on the number of CPUs).

Log files in Data Dictionary

select member from v$logfile;

Reference







Share this page:
Follow us:
Task Runner