|
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.
|
|
STATUS
|
VARCHAR2(1)
|
Indicates the status of the copy:
A - Object is availableD - Object is deletedX - 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.
|
|
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
|
