Here I thought to post very useful list of RMAN recovery catalog views and its corresponding V$ views as quick reference that I did grep from Oracle Backup and Recovery Reference doc.
In order to find the details of any Recovery Catalog view or V$ view, e.g what all fields are there in a particular view and for what purpose, then just click on that particular Recover Catalog View or V$ View listed hereunder and it will redirect you to the exact page of Oracle Docs to enhance your knowledge.
| Recovery Catalog View | Corresponding V$ View | Catalog View Describes ... |
| RC_ARCHIVED_LOG | V$ARCHIVED_LOG | Archived and unarchived redo log files |
| RC_BACKUP_ARCHIVELOG_DETAILS | V$BACKUP_ARCHIVELOG_DETAILS | Details about archived redo log backups for Enterprise Manager |
| RC_BACKUP_ARCHIVELOG_SUMMARY | V$BACKUP_ARCHIVELOG_SUMMARY | Summary of information about archived redo log backups for Enterprise Manager |
| RC_BACKUP_CONTROLFILE | V$BACKUP_DATAFILE | 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 | V$BACKUP_CORRUPTION | Corrupt block ranges in datafile backups |
| RC_BACKUP_DATAFILE | V$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 | V$BACKUP_FILES | RMAN backups and copies known to the repository. |
| RC_BACKUP_PIECE | V$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 log files 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 | V$BACKUP_SPFILE | Server parameter files in backups |
| RC_BACKUP_SPFILE_DETAILS | V$BACKUP_SPFILE_DETAILS | Details about server parameter file backups for Enterprise Manager |
| RC_BACKUP_SPFILE_SUMMARY | V$BACKUP_SPFILE_SUMMARY | Summary of information about server parameter file backups for Enterprise Manager |
| RC_CHECKPOINT | n/a | Deprecated in favor of RC_RESYNC |
| RC_CONTROLFILE_COPY | V$DATAFILE_COPY | Control file copies on disk |
| RC_COPY_CORRUPTION | V$COPY_CORRUPTION | Corrupt block ranges in datafile copies |
| 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_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 log files for Enterprise Manager |
| RC_PROXY_ARCHIVELOG_SUMMARY | V$PROXY_ARCHIVELOG_SUMMARY | Summary of information about proxy archived redo log files for Enterprise Manager |
| RC_PROXY_CONTROLFILE | V$PROXY_DATAFILE | 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 | 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_RESTORE_POINT | V$RESTORE_POINT | All restore points for all incarnations of the database since the last catalog resynchronization |
| RC_RESYNC | n/a | Recovery catalog resynchronizations |
| RC_RMAN_BACKUP_JOB_DETAILS | V$RMAN_BACKUP_JOB_DETAILS | Details about backup jobs for Enterprise Manager |
| RC_RMAN_BACKUP_SUBJOB_DETAILS | V$RMAN_BACKUP_SUBJOB_DETAILS | Details about backup subjobs for Enterprise Manager |
| RC_RMAN_BACKUP_TYPE | V$RMAN_BACKUP_TYPE | Used internally by Enterprise Manager |
| RC_RMAN_CONFIGURATION | V$RMAN_CONFIGURATION | RMAN configuration settings |
| RC_RMAN_OUTPUT | V$RMAN_OUTPUT | Output from RMAN commands for use in Enterprise Manager |
| RC_RMAN_STATUS | V$RMAN_STATUS | Historical status information about RMAN operations. |
| RC_SITE | n/a | Databases in a Data Guard environment |
| 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 |
| RC_TEMPFILE | V$TEMPFILE | All tempfiles registered in the recovery catalog |
| RC_UNUSABLE_BACKUPFILE_DETAILS | V$UNUSABLE_BACKUPFILE_DETAILS | Unusable backup files registered in the recovery catalog |
No comments:
Post a Comment