RC_BACKUP_REDOLOG

This view lists information about archived redo logs in backup sets. It corresponds to the V$BACKUP_REDOLOG view.

You cannot back up online logs directly; you must first archive them to disk and then back them up. An archived log backup set contains one or more archived logs.

Column	Datatype	NULL	Description
DB_KEY	NUMBER	NOT NULL	The primary key for the target database. Use this column to form a join with almost any other catalog view.
DBINC_KEY	NUMBER	NOT NULL	The primary key for the incarnation of the target database. Use this column to form a join with RC_DATABASE_INCARNATION.
DB_NAME	VARCHAR2(8)	NOT NULL	The DB_NAME of the database incarnation to which this record belongs.
BRL_KEY	NUMBER	NOT NULL	The primary key of the archived redo log in the recovery catalog. If you issue the list command while connected to the recovery catalog, this value appears in the KEY column of the output.
RECID	NUMBER	NOT NULL	The record identifier propagated from V$BACKUP_REDOLOG. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
STAMP	NUMBER	NOT NULL	The stamp from V$BACKUP_REDOLOG. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
BS_KEY	NUMBER	NOT NULL	The primary key of the backup set to which this record belongs in the recovery catalog. Use this column to form a join with RC_BACKUP_SET.
SET_STAMP	NUMBER	NOT NULL	The SET_STAMP value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies the backup set to which this record belongs in the target database control file.
SET_COUNT	NUMBER	NOT NULL	The SET_COUNT value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies the backup set to which this record belongs in the target database control file.
BACKUP_TYPE	VARCHAR2(1)	NOT NULL	The type of the backup: L (archived redo log).
COMPLETION_TIME	DATE	NOT NULL	The time when the backup completed.
THREAD#	NUMBER	NOT NULL	The thread number of the redo log.
SEQUENCE#	NUMBER	NOT NULL	The log sequence number.
RESETLOGS_CHANGE#	NUMBER	NOT NULL	The SCN of the most recent RESETLOGS when the record was created.
RESETLOGS_TIME	DATE	NOT NULL	The timestamp of the most recent RESETLOGS when the record was created.
FIRST_CHANGE#	NUMBER	NOT NULL	The SCN generated when Oracle switched into the redo log.
FIRST_TIME	DATE	NOT NULL	The time when Oracle switched into the redo log.
NEXT_CHANGE#	NUMBER	NOT NULL	The first SCN of the next redo log in the thread.
NEXT_TIME	DATE	NOT NULL	The first timestamp of the next redo log in the thread.
BLOCKS	NUMBER	NOT NULL	The number of operating system blocks written to the backup.
STATUS	VARCHAR2(1)	NOT NULL	The status of the backup set: A (all pieces available), D (all pieces deleted), O (some pieces are available but others are not, so the backup set is unusable).