SQL*Plus command ARCHIVE LOG LIST displays archiving information - Oracle Redo Log

Q.  The SQL*Plus command ARCHIVE LOG LIST displays archiving information for the connected instance.
- Published on 04 Aug 15

a. True
b. False

ANSWER: True

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - You can display information about the archived redo log using dynamic performance views or the ARCHIVE LOG LIST command.

    - The SQL*Plus command ARCHIVE LOG LIST displays archiving information for the connected instance. For example:

    SQL> ARCHIVE LOG LIST

    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination D:\oracle\oradata\IDDB2\archive
    Oldest online log sequence 11160
    Next log sequence to archive 11163
    Current log sequence 11163

    - This display tells you all the necessary information regarding the archived redo log settings for the current instance:
    1. The database is currently operating in ARCHIVELOG mode.
    2. Automatic archiving is enabled.
    3. The archived redo log destination is D:\oracle\oradata\IDDB2\archive.
    4. The oldest filled redo log group has a sequence number of 11160.
    5. The next filled redo log group to archive has a sequence number of 11163.
    6. The current redo log file has a sequence number of 11163.

➨ 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.)
▲