Oracle8i Recovery Manager User's Guide and Reference
Release 2 (8.1.6)

A76990-01

Library

Product

Contents

Index

Prev Up Next

Recovery Catalog Views, 5 of 25


RC_BACKUP_DATAFILE

This view lists information about datafiles in backup sets. It corresponds to the V$BACKUP_DATAFILE view. A backup datafile is uniquely identified by BDF_KEY.

Column  Datatype  NULL  Description 

DB_KEY 

NUMBER 

NOT NULL 

The primary key for the target database. Use this column to form a join with almost any other catalog view. 

DBINC_KEY 

NUMBER 

NOT NULL 

The primary key for the incarnation of the target database. Use this column to form a join with RC_DATABASE_INCARNATION. 

DB_NAME 

VARCHAR2(8) 

NOT NULL 

The DB_NAME of the database incarnation to which this record belongs. 

BDF_KEY 

NUMBER 

NOT NULL 

The primary key of the datafile backup in the recovery catalog. If you issue the list command while connected to the recovery catalog, this value appears in the KEY column of the output. 

RECID 

NUMBER 

NOT NULL 

The backup datafile RECID from V$BACKUP_DATAFILE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. 

STAMP 

NUMBER 

NOT NULL 

The backup datafile stamp from V$BACKUP_DATAFILE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. 

BS_KEY 

NUMBER 

NOT NULL 

The primary key of the backup set to which this record belongs in the recovery catalog. Use this column to form a join with RC_BACKUP_SET. 

SET_STAMP 

NUMBER 

NOT NULL 

The SET_STAMP value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies the backup set to which this record belongs in the target database control file. 

SET_COUNT 

NUMBER 

NOT NULL 

The SET_COUNT value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies the backup set to which this record belongs in the target database control file. 

BS_RECID 

NUMBER 

NOT NULL 

The RECID from V$BACKUP_SET. 

BS_STAMP 

NUMBER  

NOT NULL 

The STAMP from V$BACKUP_SET. 

BACKUP_TYPE 

VARCHAR2(1) 

NOT NULL 

The type of the backup: D (full or level 0 incremental) or I (incremental level 1 or higher). 

INCREMENTAL_LEVEL 

NUMBER 

 

The level of the incremental backup: NULL or 0 - 4. 

COMPLETION_TIME 

DATE 

 

The completion time of the backup. 

FILE# 

NUMBER 

NOT NULL 

The absolute file number of the datafile. 

CREATION_CHANGE# 

NUMBER 

NOT NULL 

The SCN at the creation of the backup. 

RESETLOGS_CHANGE# 

NUMBER 

NOT NULL 

The SCN of the most recent RESETLOGS in the datafile header. 

RESETLOGS_TIME 

DATE 

NOT NULL 

The timestamp of the most recent RESETLOGS in the datafile header. 

INCREMENTAL_CHANGE# 

NUMBER 

NOT NULL 

The SCN that determines whether a block will be included in the incremental backup. A block is only included if the SCN in the block header is greater than or equal to INCREMENTAL_CHANGE#.

The range of redo covered by the incremental backup begins with INCREMENTAL_CHANGE# and ends with CHECKPOINT_CHANGE#. 

CHECKPOINT_CHANGE# 

NUMBER 

NOT NULL 

The SCN of the most recent datafile checkpoint. 

CHECKPOINT_TIME 

DATE 

NOT NULL 

The time of the last datafile checkpoint. 

ABSOLUTE_FUZZY_CHANGE# 

NUMBER 

 

The absolute fuzzy SCN. 

DATAFILE_BLOCKS 

NUMBER 

NOT NULL 

The number of data blocks in the datafile. 

BLOCKS 

NUMBER 

NOT NULL 

The number of data blocks written to the backup. 

BLOCK_SIZE 

NUMBER 

NOT NULL 

The size of the data blocks in bytes. 

STATUS 

VARCHAR2(1) 

NOT NULL 

The status of the backup set: A (all pieces available), D (all pieces deleted), O (some pieces are available but others are not, so the backup set is unusable). 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index