This section contains the following topics:
Several dynamic performance views contain useful information about archived redo logs, as summarized in the following table.
|Dynamic Performance View||Description|
||Shows if the database is in
||Displays historical archived log information from the control file. If you use a recovery catalog, the
||Describes the current instance, all archive destinations, and the current value, mode, and status of these destinations.|
||Displays information about the state of the various archive processes for an instance.|
||Contains information about any backups of archived logs. If you use a recovery catalog, the
||Displays all redo log groups for the database and indicates which need to be archived.|
||Contains log history information such as which logs have been archived and the SCN range for each archived log.|
For example, the following query displays which redo log group requires archiving:
SELECT GROUP#, ARCHIVED FROM SYS.V$LOG; GROUP# ARC -------- --- 1 YES 2 NO
SELECT LOG_MODE FROM SYS.V$DATABASE; LOG_MODE ------------ NOARCHIVELOG
See Also:Oracle Database Reference for detailed descriptions of dynamic performance views
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:
The database is currently operating in
Automatic archiving is enabled.
The archived redo log destination is D:\oracle\oradata\IDDB2\archive.
The oldest filled redo log group has a sequence number of 11160.
The next filled redo log group to archive has a sequence number of 11163.
The current redo log file has a sequence number of 11163.
See Also:SQL*Plus User's Guide and Reference for more information on the
ARCHIVE LOG LISTcommand