Displaying Archiving Status Information

To see the current archiving mode, query the V$DATABASE view :

SELECT log_mode FROM sys.v$database;

LOG_MODE

------------

NOARCHIVELOG

The V$ARCHIVE and V$LOG data dictionary views also contain archiving information of a database. For example, the following query lists all log groups for the database and indicates the ones that remain to be archived:

SELECT group#, archived

   FROM sys.v$log;

GROUP#     ARC

---------- ---

1 YES

2 NO

The command ARCHIVE LOG with the LIST parameter also shows archiving information for the connected instance:

ARCHIVE LOG LIST;

Database log mode                        ARCHIVELOG

Automatic archival                       ENABLED

Archive destination                      destination

Oldest online log sequence               30

Next log sequence to archive             32

Current log sequence number              33

This display tells you all the necessary information regarding the redo log settings for the current instance:

• The database is currently operating in ARCHIVELOG mode.

• Automatic archiving is enabled.

• The destination of the archived redo log (operating system specific) is destination (corresponds to LOG_ARCHIVE_DEST or an overriding destination).

• The oldest filled online redo log group has a sequence number of 30.

• The next filled online redo log group to archive has a sequence number of 32.

• The current online redo log file has a sequence number of 33.