RC_PROXY_ARCHIVELOG

5.38 RC_PROXY_ARCHIVELOG_DETAILS

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.