Recovery Catalog View

Corresponding V$ View

Catalog View Describes ...

Bitmap

RC_ARCHIVED_LOG

Bitmap

V$ARCHIVED_LOG

Archived and unarchived redo log files

Bitmap

RC_BACKUP_ARCHIVELOG_DETAILS

Bitmap

V$BACKUP_ARCHIVELOG_DETAILS

Details about archived redo log backups for Enterprise Manager

Bitmap

RC_BACKUP_ARCHIVELOG_SUMMARY

Bitmap

V$BACKUP_ARCHIVELOG_SUMMARY

Summary of information about archived redo log backups for Enterprise Manager

Bitmap

RC_BACKUP_CONTROLFILE

Bitmap

V$BACKUP_DATAFILE

Control files backed up in backup sets

Bitmap

RC_BACKUP_CONTROLFILE_DETAILS

Bitmap

V$BACKUP_CONTROLFILE_DETAILS

Details about control file backups for Enterprise Manager

Bitmap

RC_BACKUP_CONTROLFILE_SUMMARY

Bitmap

V$BACKUP_CONTROLFILE_SUMMARY

Summary of information about control file backups for Enterprise Manager

Bitmap

RC_BACKUP_COPY_DETAILS

Bitmap

V$BACKUP_COPY_DETAILS

Details about data file image copy backups for Enterprise Manager

Bitmap

RC_BACKUP_COPY_SUMMARY

Bitmap

V$BACKUP_COPY_SUMMARY

Summary of information about data file image copy backups for Enterprise Manager

Bitmap

RC_BACKUP_CORRUPTION

Bitmap

V$BACKUP_CORRUPTION

Corrupt block ranges in data file backups

Bitmap

RC_BACKUP_DATAFILE

Bitmap

V$BACKUP_DATAFILE

Data files in backup sets

Bitmap

RC_BACKUP_DATAFILE_DETAILS

Bitmap

V$BACKUP_DATAFILE_DETAILS

Details about data file backups for Enterprise Manager

Bitmap

RC_BACKUP_DATAFILE_SUMMARY

Bitmap

V$BACKUP_DATAFILE_SUMMARY

Summary of information about data file backups for Enterprise Manager

Bitmap

RC_BACKUP_FILES

Bitmap

V$BACKUP_FILES

RMAN backups and copies known to the repository.

Bitmap

RC_BACKUP_PIECE

Bitmap

V$BACKUP_PIECE

Backup pieces

Bitmap

RC_BACKUP_PIECE_DETAILS

Bitmap

V$BACKUP_PIECE_DETAILS

Details about backup pieces for Enterprise Manager

Bitmap

RC_BACKUP_REDOLOG

Bitmap

V$BACKUP_REDOLOG

Archived redo log files in backup sets

Bitmap

RC_BACKUP_SET

Bitmap

V$BACKUP_SET

Backup sets for all incarnations of databases registered in the catalog

Bitmap

RC_BACKUP_SET_DETAILS

Bitmap

V$BACKUP_SET_DETAILS

Details about backup sets for Enterprise Manager

Bitmap

RC_BACKUP_SET_SUMMARY

Bitmap

V$BACKUP_SET_SUMMARY

Summary of information about backup sets for Enterprise Manager

Bitmap

RC_BACKUP_SPFILE

Bitmap

V$BACKUP_SPFILE

Server parameter files in backups

Bitmap

RC_BACKUP_SPFILE_DETAILS

Bitmap

V$BACKUP_SPFILE_DETAILS

Details about server parameter file backups for Enterprise Manager

Bitmap

RC_BACKUP_SPFILE_SUMMARY

Bitmap

V$BACKUP_SPFILE_SUMMARY

Summary of information about server parameter file backups for Enterprise Manager

Bitmap

RC_CHECKPOINT

n/a

Bitmap

Deprecated in favor of RC_RESYNC

Bitmap

RC_CONTROLFILE_COPY

Bitmap

V$DATAFILE_COPY

Control file copies on disk

Bitmap

RC_COPY_CORRUPTION

Bitmap

V$COPY_CORRUPTION

Corrupt block ranges in data file copies

Bitmap

RC_DATABASE

Bitmap

V$DATABASE

Databases registered in the recovery catalog

Bitmap

RC_DATABASE_BLOCK_CORRUPTION

Bitmap

V$DATABASE_BLOCK_CORRUPTION

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

Bitmap

RC_DATABASE_INCARNATION

Bitmap

V$DATABASE_INCARNATION

Database incarnations registered in the recovery catalog

Bitmap

RC_DATAFILE

Bitmap

V$DATAFILE

Data files registered in the recovery catalog

Bitmap

RC_DATAFILE_COPY

Bitmap

V$DATAFILE_COPY

Data file copies on disk

Bitmap

RC_LOG_HISTORY

Bitmap

V$LOG_HISTORY

Online redo log history indicating when log switches occurred

Bitmap

RC_OFFLINE_RANGE

Bitmap

V$OFFLINE_RANGE

Offline ranges for data files

Bitmap

RC_PROXY_ARCHIVEDLOG

Bitmap

V$PROXY_ARCHIVEDLOG

Archived log backups taken with the proxy copy functionality

Bitmap

RC_PROXY_ARCHIVELOG_DETAILS

Bitmap

V$PROXY_ARCHIVELOG_DETAILS

Details about proxy archived redo log files for Enterprise Manager

Bitmap

RC_PROXY_ARCHIVELOG_SUMMARY

Bitmap

V$PROXY_ARCHIVELOG_SUMMARY

Summary of information about proxy archived redo log files for Enterprise Manager

Bitmap

RC_PROXY_CONTROLFILE

Bitmap

V$PROXY_DATAFILE

Control file backups taken with the proxy copy functionality

Bitmap

RC_PROXY_COPY_DETAILS

Bitmap

V$PROXY_COPY_DETAILS

Details about data file proxy copies for Enterprise Manager

Bitmap

RC_PROXY_COPY_SUMMARY

Bitmap

V$PROXY_COPY_SUMMARY

Summary of information about data file proxy copies for Enterprise Manager

Bitmap

RC_PROXY_DATAFILE

Bitmap

V$PROXY_DATAFILE

Data file backups that were taken using the proxy copy functionality

Bitmap

RC_REDO_LOG

V$LOG

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

BitmapBitmapBitmap

andV$LOGFILE

Bitmap

RC_REDO_THREAD

V$THREAD

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

Bitmap

RC_RESTORE_POINT

Bitmap

V$RESTORE_POINT

All restore points for all incarnations of the database since the last catalog resynchronization

Bitmap

RC_RESYNC

n/a

Recovery catalog resynchronizations

Bitmap

RC_RMAN_BACKUP_JOB_DETAILS

Bitmap

V$RMAN_BACKUP_JOB_DETAILS

Details about backup jobs for Enterprise Manager

Bitmap

RC_RMAN_BACKUP_SUBJOB_DETAILS

Bitmap

V$RMAN_BACKUP_SUBJOB_DETAILS

Details about backup subjobs for Enterprise Manager

Bitmap

RC_RMAN_BACKUP_TYPE

Bitmap

V$RMAN_BACKUP_TYPE

Used internally by Enterprise Manager

Bitmap

RC_RMAN_CONFIGURATION

Bitmap

V$RMAN_CONFIGURATION

RMAN configuration settings

Bitmap

RC_RMAN_OUTPUT

Bitmap

V$RMAN_OUTPUT

Output from RMAN commands for use in Enterprise Manager

Bitmap

RC_RMAN_STATUS

Bitmap

V$RMAN_STATUS

Historical status information about RMAN operations.

Bitmap

RC_SITE

n/a

Databases in a Data Guard environment

Bitmap

RC_STORED_SCRIPT

n/a

Names of scripts stored in the recovery catalog

Bitmap

RC_STORED_SCRIPT_LINE

n/a

Contents of the scripts stored in the recovery catalog

Bitmap

RC_TABLESPACE

Bitmap

V$TABLESPACE

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

Bitmap

RC_TEMPFILE

Bitmap

V$TEMPFILE

All temp files registered in the recovery catalog

Bitmap

RC_UNUSABLE_BACKUPFILE_DETAILS

Bitmap

V$UNUSABLE_BACKUPFILE_DETAILS

Unusable backup files registered in the recovery catalog

ITPub博客

Summary of RMAN Recovery Catalog Views

最新文章