Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-02
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
Feedback

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

RC_BACKUP_ARCHIVELOG_DETAILS

RC_BACKUP_ARCHIVELOG_DETAILS provides detailed information about backups of archived redo log files.

This view is primarily intended to be used internally by Enterprise Manager.

Column Datatype Description
BTYPE CHAR(9) The backup type container, which can be BACKUPSET, IMAGECOPY or PROXYCOPY.
BTYPE_KEY NUMBER A unique identifier for the backup type. For backupsets, it is VS_KEY; for image copies, it is COPY_KEY; for proxy copies it is XAL_KEY.
SESSION_KEY NUMBER Unique identifier for this session.
SESSION_RECID NUMBER The RECID from the control file for the target database which corresponds to this RMAN session.
SESSION_STAMP NUMBER The STAMP from the control file for the target database which corresponds to this RMAN session.
DB_KEY NUMBER The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
DB_NAME VARCHAR2(8) The DB_NAME of the database incarnation to which this record belongs.
ID1 NUMBER For archived logs in backup sets, this column contains SET_STAMP. For proxy copy or image copy backups, this column contains the RECID from the control file.
ID2 NUMBER For archived logs in backup sets, this column contains SET_COUNT. For image copy or proxy copy backups, this column contains STAMP.
THREAD# NUMBER Thead number of this archived redo log file.
SEQUENCE# NUMBER Sequence number of this archived redo log file.
RESETLOGS_CHANGE# NUMBER SCN of OPEN RESETLOGS branch for this archived log.
RESETLOGS_TIME DATE Time of OPEN RESETLOGS branch for this archived log.
FIRST_CHANGE# NUMBER Starting SCN for this archived log file.
FIRST_TIME DATE Time corresponding to starting SCN for this archived redo log file.
NEXT_CHANGE# NUMBER Ending SCN for this archived redo log file.
NEXT_TIME DATE Time corresponding to the ending SCN for this archived redo log file.
FILESIZE NUMBER Size of backed up redo log file, in bytes.
COMPRESSION_RATIO NUMBER Compression ratio for this backup.
FILESIZE_DISPLAY VARCHAR2(4000) Same value as FILESIZE, but converted to a user-displayable format, for example nM, nG, nT, nP.