RC_PROXY_ARCHIVEDLOG

This view contains descriptions of archived log backups that were taken using the proxy copy functionality. It corresponds to the V$PROXY_ARCHIVEDLOG view.

In a proxy copy, the media manager takes over the operations of backing up and restoring data. Each row represents a backup of one control file.

Column	Datatype	Description
`DB_KEY`	`NUMBER`	The primary key for the target database. Use this column to form a join with almost any other catalog view.
`DBINC_KEY`	`NUMBER`	The primary key for the incarnation of the target database. Use this column to form a join with `RC_DATABASE_INCARNATION`.
`DB_NAME`	`VARCHAR2(8)`	The `DB_NAME` of the database incarnation to which this record belongs.
`XAL_KEY`	`NUMBER`	The proxy copy primary key in the recovery catalog. If you issue the `LIST` command while connected to the recovery catalog, this value appears in the `KEY` column of the output.
`RECID`	`NUMBER`	The proxy copy record identifier from `V$PROXY_ARCHIVEDLOG.` `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`STAMP`	`NUMBER`	The proxy copy stamp from`V$PROXY_ARCHIVEDLOG.` `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`TAG`	`VARCHAR2(32)`	The tag for the proxy copy.
`DEVICE_TYPE`	`VARCHAR2(255)`	The type of media device that stores the proxy copy.
`HANDLE`	`VARCHAR2(1024)`	The name or "handle" for the proxy copy. RMAN passes this value to the operating system-dependent layer that identifies the file.
`COMMENTS`	`VARCHAR2(255)`	Comments about 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 proxy copy is stored.
`STATUS`	`VARCHAR2(1)`	The status of the backup set: `A` (available), `U` (unavailable), `X` (expired), or `D` (deleted).
`THREAD#`	`NUMBER`	The number of the redo thread.
`SEQUENCE#`	`NUMBER`	The log sequence number.
`RESETLOGS_CHANGE#`	`NUMBER`	The `RESETLOGS` SCN of the database incarnation to which this archived log belongs.
`RESETLOGS_TIME`	`DATE`	The `RESETLOGS` time stamp of the database incarnation to which this archived log belongs.
`FIRST_CHANGE#`	`NUMBER`	The first SCN of this redo log.
`FIRST_TIME`	`DATE`	The time when Oracle switched into the redo log.
`NEXT_CHANGE#`	`NUMBER`	The first SCN of the next redo log in the thread.
`NEXT_TIME`	`DATE`	The first time stamp of the next redo log in the thread.
`BLOCKS`	`NUMBER`	The size of this archived redo log in operating system blocks.
`BLOCK_SIZE`	`NUMBER`	The block size for the copy in bytes.
`DEVICE_TYPE`	`VARCHAR2(255)`	The type of sequential media device.
`START_TIME`	`DATE`	The time when proxy copy was initiated.
`COMPLETION_TIME`	`DATE`	The time when the proxy copy was completed.
`ELAPSED_SECONDS`	`NUMBER`	The duration of the proxy copy.