5.41 RC_PROXY_COPY_DETAILS

RC_PROXY_COPY_DETAILS contains detailed information about proxy copy backups for databases registered in the recovery catalog.

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 proxy copy operation from RC_RMAN_OUTPUT.

SESSION_STAMP

NUMBER

With SESSION_RECID, uniquely identifies output for this proxy copy operation 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 proxy copy.

COPY_KEY

NUMBER

Unique identifier for this proxy copy.

FILE#

NUMBER

The absolute file number of the data file that is proxy copied.

HANDLE

VARCHAR2(1024)

The proxy copy handle identifies the copy for purposes of restore operations.

COMMENTS

VARCHAR2(255)

A comment that contains further information about the media manager that stores this backup.

MEDIA

VARCHAR2(80)

Identifies the media manager that stores this backup.

MEDIA_POOL

NUMBER

The number of the media pool in which the copy is stored. This is the same value that was entered in the POOL operand of the Recovery Manager BACKUP command.

TAG

VARCHAR2(32)

Tag associated with this proxy copy.

CREATION_CHANGE#

NUMBER

The data file creation SCN.

CREATION_TIME

DATE

The time corresponding to CREATION_CHANGE#.

CHECKPOINT_CHANGE#

NUMBER

Checkpoint SCN when the proxy copy was made.

CHECKPOINT_TIME

DATE

The time corresponding to CHECKPOINT_CHANGE#.

OUTPUT_BYTES

NUMBER

Sum of sizes of all output pieces generated by this proxy copy operation.

COMPLETION_TIME

DATE

Time when the proxy copy was completed.

CONTROLFILE_TYPE

VARCHAR2(1)

Possible values are: B for a normal control file, and S for a standby control file.

KEEP

VARCHAR2(3)

Indicates whether this backup has a retention policy different from the value for CONFIGURE RETENTION POLICY. Possible values are YES and NO.

KEEP_UNTIL

DATE

If the KEEP UNTIL TIME clause was specified, then this column shows the date after which this backup becomes obsolete. If the column is NULL and KEEP OPTIONS is not NULL, the backup never becomes obsolete.

KEEP_OPTIONS

VARCHAR2(11)

The KEEP options specified for this backup. 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 was made in open mode, 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 retention policy.

OUTPUT_BYTES_DISPLAY

VARCHAR2(32K)

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