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_CONTROLFILE_DETAILS

V$BACKUP_CONTROLFILE_DETAILS contains information about restorable control files. It will include all the control files backed up in the backup set, image copies, and proxy copies.

Column Datatype Description
BTYPE CHAR(9) Backup type container. Possible values are BACKUPSET, IMAGECOPY, PROXYCOPY.
BTYPE_KEY NUMBER Unique identifier for the backup type, either BS_KEY or COPY_KEY.
SESSION_KEY NUMBER Session identifier
SESSION_RECID NUMBER Session recid
SESSION_STAMP NUMBER Session stamp
ID1 NUMBER If BACKUPSET, it contains SET_STAMP

If IMAGECOPY or PROXYCOPY, it is RECID from the control file

ID2 NUMBER If BACKUPSET, it contains SET_COUNT

If IMAGECOPY or PROXYCOPY, it is STAMP

CREATION_TIME DATE File creation time
RESETLOGS_CHANGE# NUMBER Resetlogs change SCN
RESETLOGS_TIME DATE Resetlogs change time
CHECKPOINT_CHANGE# NUMBER Checkpoint change SCN
CHECKPOINT_TIME DATE Checkpoint change time
FILESIZE NUMBER File size, in bytes, for the output of backing up this control file
COMPRESSION_RATIO NUMBER Compression ratio for this backup
FILESIZE_DISPLAY VARCHAR2(4000) Same value as the FILESIZE column, but converted to a user-displayable format, for example nM, nG, nT, nP, and so on