RC_PROXY_ARCHIVELOG_DETAILS provides detailed information about proxy copy backups of archived redo log for each database registered in the recovery catalog.
This view shows one record for each database registered in the recovery catalog. Thus, if only one database is registered, then this view shows one row regardless of the number of proxy copies of archived redo log files that have been performed. 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. |
COPY_KEY |
NUMBER |
Unique identifier for this proxy copy. |
THREAD# |
NUMBER |
Redo thread number for the archived redo log file that was backed up. |
SEQUENCE# |
NUMBER |
Log sequence number for the archived redo log file that was backed up. |
RESETLOGS_CHANGE# |
NUMBER |
Checkpoint SCN of OPEN RESETLOGS for incarnation of the database of the archived redo log file that was backed up. |
RESETLOGS_TIME |
DATE |
Time corresponding to RESETLOGS_CHANGE#. |
HANDLE |
VARCHAR2(1024) |
A file name for the proxy copy. |
MEDIA |
VARCHAR2(80) |
A comment that contains further information about the media manager that created this backup. |
MEDIA_POOL |
NUMBER |
The number of the media pool in which the backup is stored. |
TAG |
VARCHAR2(32) |
Tag specified for this backup. |
FIRST_CHANGE# |
NUMBER |
First change SCN included in the archived redo log file. |
NEXT_CHANGE# |
NUMBER |
Next change SCN after this archived redo log file. |
FIRST_TIME |
DATE |
Time corresponding to FIRST_CHANGE#. |
NEXT_TIME |
DATE |
Time corresponding to NEXT_CHANGE#. |
OUTPUT_BYTES |
NUMBER |
Sum of sizes of all output pieces generated by this job. |
COMPLETION_TIME |
DATE |
The time at which the job was completed. |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(32K) |
Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G. |