Oracle Database - Recovery

Card Puncher Data Processing

About

Oracle Database also uses SCNs as part of its instance recovery and media recovery mechanisms.





Recommended Pages
Card Puncher Data Processing
Oracle Database - Redo Log (Transaction Log Files)

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...
Card Puncher Data Processing
Oracle Database - System Change Numbers (SCNs) - Point in time

A system change number (SCN) is a logical, internal time stamp used by Oracle Database. SCNs order events that occur within the database, which is necessary to satisfy the ACID properties of a transaction....



Share this page:
Follow us:
Task Runner