V$PROXY_ARCHIVEDLOG
contains descriptions of archived log backups which are taken with Proxy Copy. Each row represents a backup of one archived log.
Column | Datatype | Description |
---|---|---|
RECID |
NUMBER |
Proxy copy record ID |
STAMP |
NUMBER |
Proxy copy record stamp |
DEVICE_TYPE |
VARCHAR2(17) |
Type of the device on which the copy resides |
HANDLE |
VARCHAR2(513) |
Proxy copy handle identifies the copy for restore |
COMMENTS |
VARCHAR2(81) |
Comment returned by the operating system or storage subsystem. This value is informational only. It is not needed 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 |
STATUS |
VARCHAR2(1) |
Indicates the status of the copy:
|
DELETED |
VARCHAR2(3) |
Indicates whether the record has been deleted (YES ) or not (NO ) |
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 |
FIRST_CHANGE# |
NUMBER |
First change number in the archived log |
FIRST_TIME |
DATE |
Timestamp of the first change |
NEXT_CHANGE# |
NUMBER |
First change number in the next log |
NEXT_TIME |
DATE |
Timestamp of the next change |
BLOCKS |
NUMBER |
Size of the archived log (in blocks) |
BLOCK_SIZE |
NUMBER |
Redo log block size |
START_TIME |
DATE |
Starting time |
COMPLETION_TIME |
DATE |
Completion time |
ELAPSED_SECONDS |
NUMBER |
Number of elapsed seconds |
RMAN_STATUS_RECID |
NUMBER |
Owning V$RMAN_STATUS record ID |
RMAN_STATUS_STAMP |
NUMBER |
Owning V$RMAN_STATUS record stamp |