Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
===============================================================
Recovery Catalog View
|
Corresponding V$ View
|
Catalog View Describes ...
|
RC_ARCHIVED_LOG
|
Archived and unarchived redo logs
| |
RC_BACKUP_ARCHIVELOG_DETAILS
|
Details about archived redo log backups for Enterprise Manager
| |
RC_BACKUP_ARCHIVELOG_SUMMARY
|
Summary of information about archived redo log backups for Enterprise Manager
| |
RC_BACKUP_CONTROLFILE
|
V$BACKUP_CONTROLFILE
|
Control files backed up in backup sets
|
RC_BACKUP_CONTROLFILE_DETAILS
|
V$BACKUP_CONTROLFILE_DETAILS
|
Details about control file backups for Enterprise Manager
|
RC_BACKUP_CONTROLFILE_SUMMARY
|
V$BACKUP_CONTROLFILE_SUMMARY
|
Summary of information about control file backups for Enterprise Manager
|
RC_BACKUP_COPY_DETAILS
|
V$BACKUP_COPY_DETAILS
|
Details about datafile image copy backups for Enterprise Manager
|
RC_BACKUP_COPY_SUMMARY
|
V$BACKUP_COPY_SUMMARY
|
Summary of information about datafile image copy backups for Enterprise Manager
|
RC_BACKUP_CORRUPTION
|
Corrupt block ranges in datafile backups
| |
RC_BACKUP_DATAFILE
|
Datafiles in backup sets
| |
RC_BACKUP_DATAFILE_DETAILS
|
V$BACKUP_DATAFILE_DETAILS
|
Details about datafile backups for Enterprise Manager
|
RC_BACKUP_DATAFILE_SUMMARY
|
V$BACKUP_DATAFILE_SUMMARY
|
Summary of information about datafile backups for Enterprise Manager
|
RC_BACKUP_FILES
|
RMAN backups and copies known to the repository.
| |
RC_BACKUP_PIECE
|
Backup pieces
| |
RC_BACKUP_PIECE_DETAILS
|
V$BACKUP_PIECE_DETAILS
|
Details about backup pieces for Enterprise Manager
|
RC_BACKUP_REDOLOG
|
V$BACKUP_REDOLOG
|
Archived redo logs in backup sets
|
RC_BACKUP_SET
|
V$BACKUP_SET
|
Backup sets for all incarnations of databases registered in the catalog
|
RC_BACKUP_SET_DETAILS
|
V$BACKUP_SET_DETAILS
|
Details about backup sets for Enterprise Manager
|
RC_BACKUP_SET_SUMMARY
|
V$BACKUP_SET_SUMMARY
|
Summary of information about backup sets for Enterprise Manager
|
RC_BACKUP_SPFILE
|
Server parameter files in backups
| |
RC_BACKUP_SPFILE_DETAILS
|
Details about SPFILE backups for Enterprise Manager
| |
RC_BACKUP_SPFILE_SUMMARY
|
Summary of information about SPFILE backups for Enterprise Manager
| |
RC_CHECKPOINT
|
n/a
|
Deprecated in favor of RC_RESYNC
|
RC_CONTROLFILE_COPY
|
V$CONTROLFILE_COPY
|
Control file copies on disk
|
RC_COPY_CORRUPTION
|
Corrupt block ranges in datafile copies
| |
RC_DATABASE
|
Databases registered in the recovery catalog
| |
RC_DATABASE_BLOCK_CORRUPTION
|
Database blocks marked as corrupted in the most recent RMAN backup or copy
| |
RC_DATABASE_INCARNATION
|
Database incarnations registered in the recovery catalog
| |
RC_DATAFILE
|
Datafiles registered in the recovery catalog
| |
RC_DATAFILE_COPY
|
Datafile copies on disk
| |
RC_LOG_HISTORY
|
Online redo log history indicating when log switches occurred
| |
RC_OFFLINE_RANGE
|
V$OFFLINE_RANGE
|
Offline ranges for datafiles
|
RC_RMAN_OUTPUT
|
Output from RMAN commands for use in Enterprise Manager
| |
RC_PROXY_ARCHIVEDLOG
|
V$PROXY_ARCHIVEDLOG
|
Archived log backups taken with the proxy copy functionality
|
RC_PROXY_ARCHIVELOG_DETAILS
|
V$PROXY_ARCHIVELOG_DETAILS
|
Details about proxy archived redo logs for Enterprise Manager
|
RC_PROXY_ARCHIVELOG_SUMMARY
|
V$PROXY_ARCHIVELOG_SUMMARY
|
Summary of information about proxy archived redo logs for Enterprise Manager
|
RC_PROXY_CONTROLFILE
|
V$PROXY_CONTROLFILE
|
Control file backups taken with the proxy copy functionality
|
RC_PROXY_COPY_DETAILS
|
V$PROXY_COPY_DETAILS
|
Details about datafile proxy copies for Enterprise Manager
|
RC_PROXY_COPY_SUMMARY
|
V$PROXY_COPY_SUMMARY
|
Summary of information about datafile proxy copies for Enterprise Manager
|
RC_PROXY_DATAFILE
|
V$PROXY_DATAFILE
|
Datafile backups that were taken using the proxy copy functionality
|
RC_REDO_LOG
|
Online redo logs for all incarnations of the database since the last catalog resynchronization
| |
RC_REDO_THREAD
|
All redo threads for all incarnations of the database since the last catalog resynchronization
| |
RC_RESYNC
|
n/a
|
Recovery catalog resynchronizations
|
RC_RMAN_BACKUP_JOB_DETAILS
|
Details about backup jobs for Enterprise Manager
| |
RC_RMAN_BACKUP_SUBJOB_DETAILS
|
Details about backup subjobs for Enterprise Manager
| |
RC_RMAN_BACKUP_TYPE
|
V$BACKUP_TYPE
|
Used internally by Enterprise Manager
|
RC_RMAN_CONFIGURATION
|
RMAN configuration settings
| |
RC_RMAN_STATUS
|
Historical status information about RMAN operations.
| |
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
|
All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations
| |
RC_TEMPFILE
|
All tempfiles registered in the recovery catalog
| |
RC_UNUSABLE_BACKUPFILE_DETAILS
|
V$UNUSABLE_BACKUPFILE_DETAILS
|
Unusable backup files registered in the recovery catalog
|
Last updated: 2009-12-15 Tuesday
|
