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; 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 |
The 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: The object is available.
- D: The object is deleted.
- X: The 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 |
The starting time |
COMPLETION_TIME |
DATE |
The completion time |
ELAPSED_SECONDS |
NUMBER |
The number of elapsed seconds |