1. Backup and Recovery Reference
  2. Recovery Catalog Views
  3. RC_BACKUP_COPY_DETAILS

5.8 RC_BACKUP_COPY_DETAILS

RC_BACKUP_COPY_DETAILS contains detailed information all AVAILABLE control file and data file copies.

Columns SESSION_KEY, SESSION_RECID, SESSION_STAMP, and COPY_KEY uniquely identify an RMAN session and data file 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 Data Type Description

SESSION_KEY

NUMBER

Session identifier. Use in joins with RC_RMAN_OUTPUT and RC_RMAN_BACKUP_JOB_DETAILS.

SESSION_RECID

NUMBER

With SESSION_STAMP, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.

SESSION_STAMP

NUMBER

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 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 data file or control file copy.

FILE#

NUMBER

The absolute file number for the data file, for data file copies.

NAME

VARCHAR2(1024)

The file name of the data file or control file copy.

TAG

VARCHAR2(32)

The tag, if any, for this data file or control file copy.

CREATION_CHANGE#

NUMBER

The creation SCN of the data file, for data files.

CREATION_TIME

DATE

The creation time of the file.

CHECKPOINT_CHANGE#

NUMBER

The SCN of the most recent data file checkpoint.

CHECKPOINT_TIME

DATE

The time of the most recent data file checkpoint.

MARKED_CORRUPT

NUMBER

Number of blocks in the data file 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 BACKUP 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(11)

The KEEP options specified for this data file copy. Possible values are NOLOGS, BACKUP_LOGS, LOGS, and NULL. NOLOGS indicates a consistent backup made when the database was mounted. BACKUP_LOGS indicates that the backup while the database was open, so archived log backups must be applied to make it consistent. LOGS indicates a long-term backup made with the LOGS keyword, which is now deprecated. NULL indicates that this backup has no KEEP options and becomes obsolete based on the backup retention policy.

IS_RECOVERY_DEST_FILE

VARCHAR2(3)

YES if this copy is located in the fast recovery area. Otherwise, NO.

OUTPUT_BYTES_DISPLAY

VARCHAR2(32K)

Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G.