8.136 V$PROXY_COPY_DETAILS
V$PROXY_COPY_DETAILS
contains information about all available control file and datafile proxy copies.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier |
|
|
Session recid |
|
|
Session stamp |
|
|
Copy identifier |
|
|
Absolute datafile number, or 0 if this is a control file backup |
|
|
Proxy copy handle identifies the copy for restore |
|
|
Name of the media on which the copy resides. This value is informational only. It is not needed for restore. |
|
|
Media pool in which the copy resides. This is the same value that was entered in the |
|
|
Proxy copy tag |
|
|
Datafile creation change number |
|
|
Datafile creation timestamp |
|
|
Checkpoint change number of the datafile when the copy was made |
|
|
Checkpoint timestamp of the datafile when the copy was made |
|
|
Total output bytes written |
|
|
Completion time |
|
|
Type of control file:
|
|
|
Indicates whether this backup set has a retention policy that is different than the value for the configure retention policy ( |
|
|
If specified, then this is the date after which the backup becomes obsolete. If this column is NULL, then the backup never expires. |
|
|
Additional retention options for this backup set:
|
|
|
Displayable format for output bytes |
|
|
The ID of the container to which the data pertains. Possible values include:
|