Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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
RECID NUMBER Record ID for this row; it is an integer that identifies this row
STAMP NUMBER Timestamp used with RECID to uniquely identify this row
SET_STAMP NUMBER One of the foreign keys for the row of the V$BACKUP_SET table that identifies this backup set
SET_COUNT NUMBER One of the foreign keys for the row of the V$BACKUP_SET table that identifies this backup set
THREAD# NUMBER Thread number for the log
SEQUENCE# NUMBER Log sequence number
RESETLOGS_CHANGE# NUMBER Change number of the last resetlogs before the log was written
RESETLOGS_TIME DATE Change time of the last resetlogs before the log was written. These will be the same for all logs in a backup set.
FIRST_CHANGE# NUMBER SCN when the log was switched into. The redo in the log is at this SCN and greater.
FIRST_TIME DATE Time allocated when the log was switched into
NEXT_CHANGE# NUMBER SCN when the next log in this thread was switched into. The redo in the log is below this SCN.
NEXT_TIME DATE Time when the next log in this thread was switched into
BLOCKS NUMBER Size of the log in logical blocks including the header block
BLOCK_SIZE NUMBER Size of the log blocks in bytes
TERMINAL VARCHAR2(3) Indicates whether this record corresponds to a terminal archived redo log, as defined in V$ARCHIVED_LOG (YES) or not (NO)