8.99 V$BACKUP_REDOLOG
V$BACKUP_REDOLOG
displays information about archived logs in backup sets from the control file.
Note that online redo logs cannot be backed up directly; they must be archived first to disk and then backed up. An archive log backup set can contain one or more archived logs.
Column | Datatype | Description |
---|---|---|
|
|
Record ID for this row; it is an integer that identifies this row |
|
|
Timestamp used with RECID to uniquely identify this row |
|
|
One of the foreign keys for the row of the |
|
|
One of the foreign keys for the row of the |
|
|
Thread number for the log |
|
|
Log sequence number |
|
|
Change number of the last resetlogs before the log was written |
|
|
Change time of the last resetlogs before the log was written. These will be the same for all logs in a backup set. |
|
|
SCN when the log was switched into. The redo in the log is at this SCN and greater. |
|
|
Time allocated when the log was switched into |
|
|
SCN when the next log in this thread was switched into. The redo in the log is below this SCN. |
|
|
Time when the next log in this thread was switched into |
|
|
Size of the log in logical blocks including the header block |
|
|
Size of the log blocks in bytes |
|
|
Indicates whether this record corresponds to a terminal archived redo log, as defined in |
|
|
Number of blocks in each section of a multisection log. The value is |
|
|
The ID of the container to which the data pertains. Possible values include:
|