Inactive Redo log - Definition - Oracle Redo Log

Q.  What are the Redo log files that are no longer required for instance recovery called?
- Published on 27 Jul 15

a. Active Redo log files
b. Inactive Redo log files
c. Current
d. None of the above

ANSWER: Inactive Redo log files

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - Oracle database uses only one redo log files at a time to store redo records written from the redo log buffer.

    - The redo log file that LGWR is actively writing to is called the current redo log file.

    - Redo log files that are required for instance recovery are called active redo log files.

    - Redo log files that are no longer required for instance recovery are called inactive redo log files.

    - If you have enabled archiving (the database is in ARCHIVELOG mode), then the database cannot reuse or overwrite an active online log file until one of the archiver background processes (ARCn) has archived its contents.

    - If archiving is disabled (the database in NONARCHIVELOG mode), then when the last redo log file is full,LGWR continues by overwriting the first available active file.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲