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

Part Number B14194-03
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

RC_BACKUP_COPY_DETAILS

RC_BACKUP_COPY_DETAILS contains detailed information all AVAILABLE control file and datafile copies. Columns SESSION_KEY, SESSION_RECID, SESSION_STAMP, and COPY_KEY uniquely identify an RMAN session and datafile copy. Other columns for this view have the same semantics as in RC_DATAFILE_COPY.

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

Column Datatype Description
SESSION_KEY NUMBER Session identifier. Use in joins with RC_RMAN_OUTPUT.
SESSION_RECID NUMBER Together with SESSION_STAMP, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
SESSION_STAMP NUMBER Together with SESSION_RECID, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
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.
RSR_KEY NUMBER Unique key for the row in RC_RMAN_STATUS corresponding to the job that created this copy.
COPY_KEY NUMBER Unique identifier for this datafile or control file copy.
FILE# NUMBER The absolute file number for the datafile, for datafile copies.
NAME VARCHAR2(1024) The filename of the datafile or control file copy.
TAG VARCHAR2(32) The tag, if any, for this datafile or control file copy.
CREATION_CHANGE# NUMBER The creation SCN of the datafile, for datafiles.
CREATION_TIME DATE The creation time of the file.
CHECKPOINT_CHANGE# NUMBER The SCN of the most recent datafile checkpoint.
CHECKPOINT_TIME DATE The time of the most recent datafile checkpoint.
MARKED_CORRUPT NUMBER Number of blocks in the datafile that are marked corrupt, based on RC_DATABASE_BLOCK_CORRUPTION view.
OUTPUT_BYTES NUMBER Sum of sizes of all output pieces generated by this job.
COMPLETION_TIME DATE The completion time for this file copy.
CONTROLFILE_TYPE VARCHAR2(1) The type of control file backed up, for control file copies: B (normal copy) or S (standby copy). Otherwise, NULL.
KEEP VARCHAR2(3) YES, if this copy has a retention policy different from the value for CONFIGURE RETENTION POLICY. Otherwise, NO.
KEEP_UNTIL DATE If the KEEP UNTIL TIME clause of the COPY command was specified, then this column shows the data after which this file copy becomes obsolete. If the column is NULL and KEEP_OPTIONS is not null, then this copy never becomes obsolete.
KEEP_OPTIONS VARCHAR2(10) The KEEP options specified for this datafile copy. Possible values are LOGS (RMAN keeps the logs needed to recover this backup), NOLOGS (RMAN does not keep the logs needed to recover this backup), or NULL (this backup has no KEEP options, and becomes obsolete based on the retention policy.)
IS_RECOVERY_DEST_FILE VARCHAR2(3) YES if this copy is located in the flash recovery area. Otherwise, NO.
OUTPUT_BYTES_DISPLAY VARCHAR2(4000) Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example nM, nG, nT, nP.