Skip Headers

Oracle9i Recovery Manager Reference
Release 2 (9.2)

Part Number A96565-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Recovery Catalog Views, 3 of 28


RC_BACKUP_CONTROLFILE

This view lists information about control files in backup sets. Note that the V$BACKUP_DATAFILE view contains both datafile and control file records: a backup datafile record with file number 0 represents the backup control file. In the recovery catalog, the RC_BACKUP_CONTROLFILE view contains only control file records, while the RC_BACKUP_DATAFILE view contains only datafile records.

Column Datatype Description

DB_KEY

NUMBER

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

DBINC_KEY

NUMBER

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)

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

BCF_KEY

NUMBER

The primary key of the control file 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

The RECID value 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

The STAMP value 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

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

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

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.

RESETLOGS_CHANGE#

NUMBER

The SCN of the most recent RESETLOGS when the record was created.

RESETLOGS_TIME

DATE

The time stamp of the most recent RESETLOGS when the record was created.

CHECKPOINT_CHANGE#

NUMBER

The control file checkpoint SCN.

CHECKPOINT_TIME

DATE

The control file checkpoint time.

CREATION_TIME

DATE

The control file creation time.

BLOCK_SIZE

NUMBER

The size of the blocks in bytes.

OLDEST_OFFLINE_RANGE

NUMBER

Internal use only.

STATUS

VARCHAR2(1)

The status of the backup set: A (available), U (unavailable), or D (deleted).

BS_RECID

NUMBER

The control file RECID of the backup set that contains this backup control file.

BS_STAMP

NUMBER

The control file stamp of the backup set that contains this backup control file.

BS_LEVEL

NUMBER

The incremental level (NULL, 0, 1, 2) of the backup set that contains this backup control file. Although an incremental backup set can contain the control file, it is always contains a complete copy of the control file. There is no such thing as an incremental control file backup.

COMPLETION_TIME

DATE

The date that the control file backup completed.

CONTROLFILE_TYPE

VARCHAR2(1)

The type of control file backup: B (normal backup) or S (standby backup).

BLOCKS

NUMBER

The number of blocks in the file.

AUTOBACKUP_DATE

DATE

The date of the control file autobackup.

AUTOBACKUP_SEQUENCE

NUMBER

The sequence of the control file autobackup: 1 - 255.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback