7.93 V$BACKUP_COPY_DETAILS
V$BACKUP_COPY_DETAILS
contains information about all available control file and data file copies.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier |
|
|
Session recid |
|
|
Session stamp |
|
|
Unique identifier for this data file or control file copy |
|
|
Absolute data file number |
|
|
File name of the data file copy. The maximum length of the name is dependent on your operating system. |
|
|
Data file copy tag |
|
|
Data file creation change number |
|
|
Data file creation timestamp |
|
|
Checkpoint change number of the data file when the copy was made |
|
|
Checkpoint timestamp of the data file when the copy was made |
|
|
Number of blocks marked corrupt by this copy operation. That is, blocks that were not marked corrupted in the source data file, but were detected and marked as corrupted during the copy operation. |
|
|
Total output bytes written |
|
|
Time when the copy was completed |
|
|
Type of control file. B indicates normal copies. S indicates standby copies. |
|
|
( |
|
|
If specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires. |
|
|
Lists additional retention options for this backup set. Possible values are:
|
|
|
Indicates whether the file was created in the fast recovery area ( |
|
|
Indicates whether the file is sparse ( |
|
|
Size of backup set to display |
|
|
The ID of the container to which the data pertains. Possible values include:
|