SESSION_KEY |
NUMBER |
Session identifier |
SESSION_RECID |
NUMBER |
Session recid |
SESSION_STAMP |
NUMBER |
Session stamp |
COPY_KEY |
NUMBER |
Copy identifier |
FILE# |
NUMBER |
Absolute datafile number, or 0 if this is a control file backup |
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 |
CREATION_CHANGE# |
NUMBER |
Datafile creation change number |
CREATION_TIME |
DATE |
Datafile creation timestamp |
CHECKPOINT_CHANGE# |
NUMBER |
Checkpoint change number of the datafile when the copy was made |
CHECKPOINT_TIME |
DATE |
Checkpoint timestamp of the datafile when the copy was made |
OUTPUT_BYTES |
NUMBER |
Total output bytes written |
COMPLETION_TIME |
DATE |
Completion time |
CONTROLFILE_TYPE |
VARCHAR2(1) |
Type of control file:
-
B - Normal control file
-
S - Standby control file
|
KEEP |
VARCHAR2(3) |
Indicates whether this backup set has a retention policy that is different than the value for the configure retention policy (YES) or not (NO) |
KEEP_UNTIL |
DATE |
If specified, then this is the date after which the backup becomes obsolete. If this column is NULL, then the backup never expires. |
KEEP_OPTIONS |
VARCHAR2(11) |
Additional retention options for this backup set:
-
LOGS - Indicates a long-term backup made with the LOGS keyword, which is now deprecated
-
BACKUP_LOGS - Indicates that the backup was made in open mode, so archived log backups must be applied to make it consistent
-
NOLOGS - Indicates a consistent backup made when the database was mounted.
-
NULL - Indicates that this backup has no KEEP options and becomes obsolete based on the retention policy
|
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for output bytes |
