9.127 V$UNUSABLE_BACKUPFILE_DETAILS
V$UNUSABLE_BACKUPFILE_DETAILS
displays information about all backup files (backup pieces, proxy copies, or copies) that are marked unavailable and expired. You can select one of the rows and use BTYPE_KEY
or FILETYPE_KEY
to change the status of a backup file set or a specific file to available.
Column | Datatype | Description |
---|---|---|
|
|
Session identifier |
|
|
Session record ID |
|
|
Session stamp |
|
|
Record ID of the corresponding row in the control file |
|
|
Timestamp of the row in the controlfile |
|
|
Backup type container. Possible values are: |
|
|
Unique identifier for the backup type, either |
|
|
If If |
|
|
If If |
|
|
Type of file. Possible values are: |
|
|
Backup piece key if the file is a backup piece; otherwise |
|
|
Status of the backup file, either |
|
|
Size of the file |
|
|
Type of device on which the file resides |
|
|
Name of the file |
|
|
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 |
|
|
The ID of the container to which the data pertains. Possible values include:
|