V$OBSOLETE_BACKUP_FILES
displays all obsolete backups, copies, and archived logs according to the current retention policy. This view requires that the database is set using the DBMS_RCVMAN.SETDATABASE
procedure.
Column | Datatype | Description |
---|---|---|
|
|
Primary key for the backup |
|
|
Type of the backup:
|
|
|
Type of the file:
|
|
|
Indicates whether the backup has a retention policy different from the value for |
|
|
If the |
|
|
If this column is null, then the backup has no KEEP options and will be made obsolete based on the retention policy. |
|
|
Status of the backup:
|
|
|
Name of the file |
|
|
Tag of the piece, copy, or proxy copy |
|
|
Media ID of the piece or proxy copy |
|
|
Recid of the record in the controlfile |
|
|
Stamp of the record in the controlfile |
|
|
Type of media device that stores the backup |
|
|
Block size for the backup (in bytes) |
|
|
Time when the backup completed |
|
|
Primary key of the backup set (valid only when |
|
|
Count of the backup set from the controlfile record (valid only when |
|
|
Stamp of the backup set from the controlfile record (valid only when |
|
|
Type of the backup set (valid only when
|
|
|
Incremental level of the backup set (valid only when |
|
|
Number of backup pieces in the backup set (valid only when |
|
|
Completion time of the backup set (valid only when |
|
|
Number of the backup piece (valid only when |
|
|
Copy number of the backup piece (valid only when |
|
|
Absolute file number of the datafile (valid only when |
|
|
System change number (SCN) of the most recent |
|
|
Creation SCN of the control file or datafile (valid only when |
|
|
System change number (SCN) of the most recent control file or datafile checkpoint (valid only when |
|
|
Modification time in case of SPFILE, otherwise time when the control file or datafile was checkpointed (valid only when |
|
|
Number of the redo thread (valid only when |
|
|
Log sequence number (valid only when |
|
|
System change number (SCN) of the most recent |
|
|
First SCN of the redo log (valid only when |
|
|
Time when Oracle switched into the redo log (valid only when |
|
|
First SCN of the next redo log in the thread (valid only when |
|
|
First timestamp of the next redo log in the thread (valid only when |
See Also:
Oracle Database Backup and Recovery User's Guide for more information about the DBMS_RCVMAN.SETDATABASE
procedure