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
-
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:
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 controlfile |
STAMP |
NUMBER |
Stamp of the record in the controlfile |
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 |
BS_KEY |
NUMBER |
Primary key of the backup set (valid only when BACKUP_TYPE is BACKUP SET) |
BS_COUNT |
NUMBER |
Count of the backup set from the controlfile record (valid only when BACKUP_TYPE is BACKUP SET) |
BS_STAMP |
NUMBER |
Stamp of the backup set from the controlfile record (valid only when BACKUP_TYPE is BACKUP SET) |
BS_TYPE |
VARCHAR2(32) |
Type of the backup set (valid only when BACKUP_TYPE is BACKUP SET):
|
BS_INCR_TYPE |
VARCHAR2(32) |
Incremental level of the backup set (valid only when BACKUP_TYPE is BACKUP SET) |
BS_PIECES |
NUMBER |
Number of backup pieces in the backup set (valid only when BACKUP_TYPE is BACKUP SET) |
BS_COMPLETION_TIME |
DATE |
Completion time of the backup set (valid only when BACKUP_TYPE is BACKUP SET) |
BP_PIECE# |
NUMBER |
Number of the backup piece (valid only when FILE_TYPE is PIECE and BACKUP_TYPE is BACKUP SET) |
BP_COPY# |
NUMBER |
Copy number of the backup piece (valid only when FILE_TYPE is PIECE and BACKUP_TYPE is BACKUP SET) |
DF_FILE# |
NUMBER |
Absolute file number of the datafile (valid only when 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 when FILE_TYPE is DATAFILE) |
DF_CREATION_CHANGE# |
NUMBER |
Creation SCN of the control file or datafile (valid only when FILE_TYPE is DATAFILE) |
DF_CHECKPOINT_CHANGE# |
NUMBER |
System change number (SCN) of the most recent control file or datafile checkpoint (valid only when FILE_TYPE is DATAFILE) |
DF_CKP_MOD_TIME |
DATE |
Modification time in case of SPFILE, otherwise time when the control file or datafile was checkpointed (valid only when FILE_TYPE is DATAFILE) |
RL_THREAD# |
NUMBER |
Number of the redo thread (valid only when FILE_TYPE is REDO LOG) |
RL_SEQUENCE# |
NUMBER |
Log sequence number (valid only when 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 when FILE_TYPE is REDO LOG) |
RL_FIRST_CHANGE# |
NUMBER |
First SCN of the redo log (valid only when FILE_TYPE is REDO LOG) |
RL_FIRST_TIME |
DATE |
Time when Oracle switched into the redo log (valid only when FILE_TYPE is REDO LOG) |
RL_NEXT_CHANGE# |
NUMBER |
First SCN of the next redo log in the thread (valid only when FILE_TYPE is REDO LOG) |
RL_NEXT_TIME |
DATE |
First timestamp of the next redo log in the thread (valid only when FILE_TYPE is REDO LOG) |
