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 next page

3
Recovery Catalog Views

This chapter contains descriptions of recovery catalog views. You can only access these views if you have created a recovery catalog. For a summary of the recovery catalog views, refer to "Summary of RMAN Recovery Catalog Views".


Note:

These views are not normalized, but are optimized for RMAN usage. Hence, most catalog views have redundant values that result from joining of several underlying tables.


Summary of RMAN Recovery Catalog Views

The following table provides a functional summary of RMAN recovery catalog views.

Table 3-1 Recovery Catalog Views
Recovery Catalog View Corresponding V$ View Catalog View Describes ...

RC_ARCHIVED_LOG

V$ARCHIVED_LOG

Archived and unarchived redo logs

RC_BACKUP_CONTROLFILE

V$BACKUP_DATAFILE

Control files in backup sets

RC_BACKUP_CORRUPTION

V$BACKUP_CORRUPTION

Corrupt block ranges in datafile backups

RC_BACKUP_DATAFILE

V$BACKUP_DATAFILE

Datafiles in backup sets

RC_BACKUP_PIECE

V$BACKUP_PIECE

Backup pieces

RC_BACKUP_REDOLOG

V$BACKUP_REDOLOG

Archived redo logs in backup sets

RC_BACKUP_SET

V$BACKUP_SET

Backup sets for all incarnations of the database

RC_BACKUP_SPFILE

V$BACKUP_SPFILE

Server parameter files in backups

RC_CHECKPOINT

Deprecated in favor of RC_RESYNC

RC_CONTROLFILE_COPY

V$DATAFILE_COPY

Control file copies on disk

RC_COPY_CORRUPTION

V$COPY_CORRUPTION

Control file copies on disk

RC_DATABASE

V$DATABASE

Databases registered in the recovery catalog

RC_DATABASE_BLOCK_CORRUPTION

V$DATABASE_BLOCK_CORRUPTION

Database blocks marked as corrupted in the most recent RMAN backup or copy

RC_DATABASE_INCARNATION

V$DATABASE_INCARNATION

Database incarnations registered in the recovery catalog

RC_DATAFILE

V$DATAFILE

Datafiles registered in the recovery catalog

RC_DATAFILE_COPY

V$DATAFILE_COPY

Datafile copies on disk

RC_LOG_HISTORY

V$LOG_HISTORY

Online redo log history indicating when log switches occurred

RC_OFFLINE_RANGE

V$OFFLINE_RANGE

Offline ranges for datafiles

RC_PROXY_CONTROLFILE

V$PROXY_DATAFILE

Control file backups that were taken using the proxy copy functionality

RC_PROXY_DATAFILE

V$PROXY_DATAFILE

Datafile backups that were taken using the proxy copy functionality

RC_REDO_LOG

V$LOG and V$LOGFILE

Online redo logs for all incarnations of the database since the last catalog resynchronization

RC_REDO_THREAD

V$THREAD

All redo threads for all incarnations of the database since the last catalog resynchronization

RC_RESYNC

n/a

Recovery catalog resynchronizations

RC_RMAN_CONFIGURATION

V$RMAN_CONFIGURATION

RMAN configuration settings

RC_STORED_SCRIPT

n/a

Names of scripts stored in the recovery catalog

RC_STORED_SCRIPT_LINE

n/a

Contents of the scripts stored in the recovery catalog

RC_TABLESPACE

V$TABLESPACE

All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations


Go to previous page 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