V$PROXY_ARCHIVEDLOG contains descriptions of archived log backups which are taken with Proxy Copy. Each row represents a backup of one archived log.
Proxy copy record ID
Proxy copy record stamp
Type of the device on which the copy resides
Proxy copy handle identifies the copy for restore
Comment returned by the operating system or storage subsystem. This value is informational only. It is not needed for restore.
Name of the media on which the copy resides. This value is informational only. It is not needed for restore.
Media pool in which the copy resides. This is the same value that was entered in the POOL operand of the Recovery Manager BACKUP command.
Proxy copy tag
Indicates the status of the copy:
A - Object is available
D - Object is deleted
X - Object has been "cross-checked" and found not to exist. A subsequent "delete expired" command will change the status to D. If, for some reason, the object really does still exist, then a subsequent "cross-check" command will change the status back to A.
Indicates whether the record has been deleted (YES) or not (NO)
Redo thread number
Redo log sequence number
Resetlogs change number of the database when this log was written
Resetlogs time of the database when this log was written