Oracle9i Recovery Manager Reference
Release 1 (9.0.1)

Part Number A90136-02
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, 8 of 26


RC_BACKUP_SET

This view lists information about backup sets for all incarnations of the database. It corresponds to the V$BACKUP_SET view. A backup set record is inserted after the backup has successfully completed.

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. 

DB_ID 

NUMBER 

The unique database identifier. 

BS_KEY 

NUMBER 

The primary key of the backup set 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 backup set RECID from V$BACKUP_SET. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. Use either RECID and STAMP or SET_STAMP and SET_COUNT to access V$BACKUP_SET

STAMP 

NUMBER 

The backup set STAMP from V$BACKUP_SET. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. Use either RECID and STAMP or SET_STAMP and SET_COUNT to access V$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 this record in the target database control file. Use either RECID and STAMP or SET_STAMP and SET_COUNT to access V$BACKUP_SET

SET_COUNT 

NUMBER 

The SET_COUNT value from V$BACKUP_SET. SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies this record in the target database control file. Use either RECID and STAMP or SET_STAMP and SET_COUNT to access V$BACKUP_SET

BACKUP_TYPE 

VARCHAR2(1) 

The type of the backup: D (full backup or level 0 incremental), I (incremental of level 1 or higher), L (archived redo log). 

INCREMENTAL_LEVEL 

NUMBER 

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

PIECES 

NUMBER 

The number of backup pieces in the backup set. 

START_TIME 

DATE 

The time when the backup began. 

COMPLETION_TIME 

DATE 

The time when the backup completed. 

ELAPSED_SECONDS 

NUMBER 

The duration of the backup in seconds. 

STATUS 

VARCHAR2(1) 

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

CONTROLFILE_INCLUDED 

VARCHAR2(1) 

Possible values are NONE (backup set does not include a backup control file), BACKUP (backup set includes a normal backup control file), and STANDBY (backup set includes a standby control file). 

INPUT_FILE_SCAN_ONLY 

VARCHAR2(3) 

This backup set record was created by the BACKUP VALIDATE command. No real backup set exists. This record is only a placeholder used to keep track of which datafiles were scanned and which corrupt blocks (if any) were found in those files. 

KEEP 

VARCHAR2(3) 

Indicates whether this backup set has a retention policy different from the value for CONFIGURE RETENTION POLICY. Possible values are YES and NO

KEEP_OPTIONS 

VARCHAR2(10)

 

The KEEP options specified for this backup set. Options can be LOGS (RMAN keeps the logs needed to recover this backup), NOLOGS (RMAN does not keep the logs needed to recover this backup), or NULL (the backup has no KEEP options and will be made obsolete based on the retention policy). 

KEEP_UNTIL 

DATE 

If the KEEP UNTIL TIME clause of the BACKUP command was specified, then this column shows the date after which this backup becomes obsolete. If the column is NULL and KEEP OPTIONS is not NULL, the backup never becomes obsolete. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, 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