ARCHIVE LOG LIST consequences - Oracle Redo Log

Q.  What are the consequences of an ARCHIVE LOG LIST command stated below?

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
- Published on 04 Aug 15

a. The database is currently operating in NOARCHIVELOG mode
b. Automatic archiving is disabled
c. The current redo log file has a sequence number of 11160
d. None of the above

ANSWER: None of the above

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - 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.)
▲