8.157 V$RECOVERY_LOG
V$RECOVERY_LOG
lists information about archived logs that are needed to complete media recovery. This information is derived from the log history view, V$LOG_HISTORY
.
V$RECOVERY_LOG
contains useful information only for the Oracle process doing the recovery. When Recovery Manager directs a server process to perform recovery, only Recovery Manager can view the relevant information in this view. V$RECOVERY_LOG
will be empty to all other Oracle users.
Column | Datatype | Description |
---|---|---|
|
|
Thread number of the archived log |
|
|
Sequence number of the archived log |
|
|
Time of the first entry (lowest SCN) in the log |
|
|
Name of the file when archived, using the naming convention specified by the See Also: "LOG_ARCHIVE_FORMAT" |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
"V$LOG_HISTORY" and Oracle Database Backup and Recovery User’s Guide