Dynamic Performance (V$) Views, 7 of 179

V$ARCHIVED_LOG

This view displays archived log information from the control file including archive log names. An archive log record is inserted after the online redo log is successfully archived or cleared (name column is NULL if the log was cleared). If the log is archived twice, there will be two archived log records with the same THREAD#, SEQUENCE#, and FIRST_CHANGE#, but with a different name. An archive log record is also inserted when an archive log is restored from a backup set or a copy and whenever a copy of a log is made with the RMAN copy command.

Column Datatype Description

RECID

NUMBER

Archived log record ID

STAMP

NUMBER

Archived log record stamp

NAME

VARCHAR2(513)

Archived log file name. If set to NULL, the log file was cleared before it was archived

THREAD#

NUMBER

Redo thread number

SEQUENCE#

NUMBER

Redo log sequence number

RESETLOGS_CHANGE#

NUMBER

Resetlogs change# of the database when this log was written

RESETLOGS_TIME

DATE

Resetlogs time of the database when this log was written

FIRST_CHANGE#

NUMBER

First change# in the archived log

FIRST_TIME

DATE

Timestamp of the first change

NEXT_CHANGE#

NUMBER

First change in the next log

NEXT_TIME

DATE

Timestamp of the next change

BLOCKS

NUMBER

Size of the archived log in blocks

BLOCK_SIZE

NUMBER

Redo log block size

ARCHIVED

VARCHAR2(3)

indicates that the online redo log was archived (YES) or that RMAN only inspected the log and created a record for future application of redo logs during recovery. For additional information see Oracle8i Recovery Manager User's Guide and Reference.

DELETED

VARCHAR2(3)

specifies (with YES or NO) whether an RMAN DELETE command has physically deleted the archived log file from disk, as well as logically removing it from the control file of the target database and from the recovery catalog.

COMPLETION_TIME

DATE

Time when the archiving completed

Column	Datatype	Description
`RECID`	`NUMBER`	Archived log record ID
`STAMP`	`NUMBER`	Archived log record stamp
`NAME`	`VARCHAR2(513)`	Archived log file name. If set to NULL, the log file was cleared before it was archived
`THREAD#`	`NUMBER`	Redo thread number
`SEQUENCE#`	`NUMBER`	Redo log sequence number
`RESETLOGS_CHANGE#`	`NUMBER`	Resetlogs change# of the database when this log was written
`RESETLOGS_TIME`	`DATE`	Resetlogs time of the database when this log was written
`FIRST_CHANGE#`	`NUMBER`	First change# in the archived log
`FIRST_TIME`	`DATE`	Timestamp of the first change
`NEXT_CHANGE#`	`NUMBER`	First change in the next log
`NEXT_TIME`	`DATE`	Timestamp of the next change
`BLOCKS`	`NUMBER`	Size of the archived log in blocks
`BLOCK_SIZE`	`NUMBER`	Redo log block size
`ARCHIVED`	`VARCHAR2(3)`	indicates that the online redo log was archived (YES) or that RMAN only inspected the log and created a record for future application of redo logs during recovery. For additional information see Oracle8i Recovery Manager User's Guide and Reference.
`DELETED`	`VARCHAR2(3)`	specifies (with `YES` or `NO`) whether an RMAN `DELETE` command has physically deleted the archived log file from disk, as well as logically removing it from the control file of the target database and from the recovery catalog.
`COMPLETION_TIME`	`DATE`	Time when the archiving completed