Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$BACKUP_FILES

V$BACKUP_FILES displays information about all RMAN backups (both image copies and backup sets) and archived logs.

This view simulates the LIST BACKUP and LIST COPY RMAN commands. This view requires that the database be set using the DBMS_RCVMAN.SETDATABASE procedure.

Column Datatype Description
PKEY NUMBER Primary key for the backup
BACKUP_TYPE VARCHAR2(32) Type of the backup:
  • BACKUP SET

  • COPY

  • PROXY COPY

FILE_TYPE VARCHAR2(32) Type of the file:
  • DATAFILE

  • CONTROLFILE

  • SPFILE

  • REDO LOG

  • ARCHIVED LOG

  • COPY (for an image copy backup)

  • PIECE (for a backup piece)

KEEP VARCHAR2(3) Indicates whether the backup has a retention policy different from the value for CONFIGURE RETENTION POLICY (YES) or not (NO)
KEEP_UNTIL DATE If the KEEP UNTIL TIME clause of the BACKUP command was specified, then this column shows the date after which the backup becomes obsolete. If the column is null and KEEP_OPTIONS is not null, the backup never becomes obsolete.
KEEP_OPTIONS VARCHAR2(13) KEEP options for the backup:
  • LOGS - RMAN keeps the logs needed to recover the backup

  • NOLOGS - RMAN does not keep the logs needed to recover the backup

If this column is null, then the backup has no KEEP options and will be made obsolete based on the retention policy.

STATUS VARCHAR2(16) Status of the backup:
  • AVAILABLE

  • UNAVAILABLE

  • EXPIRED

  • OTHER

FNAME VARCHAR2(1024) Name of the file
TAG VARCHAR2(32) Tag of the piece, copy, or proxy copy
MEDIA VARCHAR2(80) Media ID of the piece or proxy copy
RECID NUMBER Recid of the record in the control file
STAMP NUMBER Stamp of the record in the control file
DEVICE_TYPE VARCHAR2(255) Type of media device that stores the backup
BLOCK_SIZE NUMBER Block size for the backup (in bytes)
COMPLETION_TIME DATE Time when the backup completed
COMPRESSED VARCHAR2(3) Indicates whether the backup piece is compressed (YES) or not (NO); valid only if FILE_TYPE is PIECE. Image copies cannot be compressed.
OBSOLETE VARCHAR2(3) Indicates whether the backup piece or copy is obsolete (YES) or not (NO); valid only if FILE_TYPE is PIECE or COPY
BYTES NUMBER Size of the file (in bytes)
BS_KEY NUMBER Primary key of the backup set (valid only if BACKUP_TYPE is BACKUP SET)
BS_COUNT NUMBER Count of the backup set from the control file record (valid only if BACKUP_TYPE is BACKUP SET)
BS_STAMP NUMBER Stamp of the backup set from the control file record (valid only if BACKUP_TYPE is BACKUP SET)
BS_TYPE VARCHAR2(32) Type of the backup set (valid only if BACKUP_TYPE is BACKUP SET):
  • DATAFILE

  • ARCHIVED LOG

BS_INCR_TYPE VARCHAR2(32) Incremental type of the backup set (valid only if BACKUP_TYPE is BACKUP SET)
BS_PIECES NUMBER Number of backup pieces in the backup set (valid only if BACKUP_TYPE is BACKUP SET)
BS_COPIES NUMBER Number of copies of the backup set (valid only if FILE_TYPE is PIECE and BACKUP_TYPE is BACKUP SET)
BS_COMPLETION_TIME DATE Completion time of the backup set (valid only if BACKUP_TYPE is BACKUP SET)
BS_STATUS VARCHAR2(16) Status of the backup set (valid only if BACKUP_TYPE is BACKUP SET):
  • AVAILABLE

  • UNAVAILABLE

  • EXPIRED

  • OTHER - Pieces which are part of the backup set do not have uniform status (that is, some of them are available, some not)

BS_BYTES NUMBER Sum of all backup piece sizes in the backup set (valid only if BACKUP_TYPE is BACKUP SET)
BS_COMPRESSED VARCHAR2(3) Indicates whether the backup pieces of the backup set are compressed (YES) or not (NO); valid only if BACKUP_TYPE is BACKUP SET
BS_TAG VARCHAR2(1024) Tags of the backup set. If pieces have different tags, then all piece tags are concatenated and separated by commas. Valid only if BACKUP_TYPE is BACKUP SET)
BS_DEVICE_TYPE VARCHAR2(255) Device type of the backup set. If there is more than one device type, then they are separated by commas. Valid only if BACKUP_TYPE is BACKUP SET
BP_PIECE# NUMBER Number of pieces inside the backup set (valid only if FILE_TYPE is PIECE and BACKUP_TYPE is BACKUP SET)
BP_COPY# NUMBER Number of copies of the backup set (valid only if FILE_TYPE is PIECE and BACKUP_TYPE is BACKUP SET)
DF_FILE# NUMBER Absolute file number of the datafile (valid only if FILE_TYPE is DATAFILE)
DF_TABLESPACE VARCHAR2(30) Tablespace name of the datafile (valid only if FILE_TYPE is DATAFILE)
DF_RESETLOGS_CHANGE# NUMBER System change number (SCN) of the most recent RESETLOGS when the control file or datafile was created (valid only if FILE_TYPE is DATAFILE)
DF_CREATION_CHANGE# NUMBER Creation SCN of the control file or datafile (valid only if FILE_TYPE is CONTROLFILE or DATAFILE)
DF_CHECKPOINT_CHANGE# NUMBER System change number (SCN) of the most recent control file or datafile checkpoint (valid only if FILE_TYPE is CONTROLFILE or DATAFILE)
DF_CKP_MOD_TIME DATE Modification time in case of SPFILE, otherwise time when the control file or datafile was checkpointed (valid only if FILE_TYPE is SPFILE, CONTROLFILE, or DATAFILE)
RL_THREAD# NUMBER Redo log thread number of the archived log (valid only if FILE_TYPE is REDO LOG)
RL_SEQUENCE# NUMBER Redo log sequence number of the archived log (valid only if FILE_TYPE is REDO LOG)
RL_RESETLOGS_CHANGE# NUMBER System change number (SCN) of the most recent RESETLOGS when the record was created (valid only if FILE_TYPE is REDO LOG)
RL_FIRST_CHANGE# NUMBER First SCN of the redo log (valid only if FILE_TYPE is REDO LOG)
RL_FIRST_TIME DATE Time when the Oracle Database switched into the redo log (valid only if FILE_TYPE is REDO LOG)
RL_NEXT_CHANGE# NUMBER First SCN of the next redo log in the thread (valid only if FILE_TYPE is REDO LOG)
RL_NEXT_TIME DATE First timestamp of the next redo log in the thread (valid only if FILE_TYPE is REDO LOG)