V$PROXY_ARCHIVELOG_DETAILS contains information about all available archive log proxy copies.
| Column | Datatype | Description |
|---|---|---|
SESSION_KEY |
NUMBER |
Session identifier |
SESSION_RECID |
NUMBER |
Session recid |
SESSION_STAMP |
NUMBER |
Session stamp |
COPY_KEY |
NUMBER |
Copy identifier |
THREAD# |
NUMBER |
Redo thread number |
SEQUENCE# |
NUMBER |
Redo log sequence number |
RESETLOGS_CHANGE# |
NUMBER |
Resetlogs change number of the database when this log was written |
RESETLOGS_TIME |
DATE |
Resetlogs time of the database when this log was written |
HANDLE |
VARCHAR2(513) |
Proxy copy handle identifies the copy for restore |
MEDIA |
VARCHAR2(65) |
Name of the media on which the copy resides. This value is informational only. It is not needed for restore. |
MEDIA_POOL |
NUMBER |
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. |
TAG |
VARCHAR2(32) |
Proxy copy tag |
FIRST_CHANGE# |
NUMBER |
First change number in the archived log |
NEXT_CHANGE# |
NUMBER |
First change number in the next log |
FIRST_TIME |
DATE |
Timestamp of the first change |
NEXT_TIME |
DATE |
Timestamp of the next change |
OUTPUT_BYTES |
NUMBER |
Total output bytes written |
COMPLETION_TIME |
DATE |
Completion time |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for output bytes |