V$PROXY_COPY_DETAILS
contains information about all available control file and datafile 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 |
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 indicates normal copies. S indicated standby copies. |
KEEP |
VARCHAR2(3) |
(YES|NO) Indicates whether or not this backup set has a retention policy that is different than the value for the configure retention policy |
KEEP_UNTIL |
DATE |
If specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires. |
KEEP_OPTIONS |
VARCHAR2(10) |
Additional retention options for this backup set:
|
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Size of backup set to display |