Description of the base table used by rman to connect to the catalog backup

Source: Internet
Author: User
Tags ranges


The base table and view used by rman to connect to the catalog backup are described as follows:

Base tables:
======================================
NAME DESCRIPTION
---------------------------
AL contains archived logs. archived logs are uniquely identified by dbinc_key, recid and stamp.
BCB contains corrupt block ranges in datafile backups.
BCF contains control file backups (in backup sets ).
BDF contains all datafile backups (in backup sets ).
BP contains all backup pieces of backup sets.
PCIe contains backup redo logs (in backup sets ).
BS contains all backup sets for all database incarnations.
CCB contains corrupt block ranges in datafile copies.
CCF contains control file copies.
CDF contains all datafile copies.
CKP records all recovery catalog checkpoints.
DB contains all target databases that have been registered in this recovery catalog.
DBINC contains all incarnations of the target databases registered in this recovery catalog.
DF contains all datafiles of all database incarnations.
DFATT datafile attributes that change over time.
OFFR stores datafile offline ranges.
ORL contains all redo logfiles for all database incarnations.
RCVER recovery catalog version.
RLH records all redo log history for all threads.
RR contains redo ranges for all database incarnations.
RT redo threads for all database incarnations.
SCR contains 1 row for each stored script.
SCRL contains 1 row for each line of each stored script.
TS contains all tablespaces of all database incarnations.
TSATT tablespace attributes that change over time.
 
Views:
========================================================== ==============
NAME DESCRIPTION
--------------------------------------
RC_ARCHIVED_LOG information about all archivelogs.
RC_BACKUP_CONTROLFILE backup control files in backup sets.
Rc_backup_partition uption blocks UPT blocks in datafile backups and copies.
RC_BACKUP_DATAFILE datafile backups (in backup sets ).
RC_BACKUP_PIECE backup pieces.
RC_BACKUP_REDOLOG redo log backups (in backup sets ).
RC_BACKUP_SET backup sets.
RC_CHECKPOINT rc_checkpoint is replaced by rc_resync, but is still used by some tests.
RC_CONTROLFILE_COPY controlfile copies.
Rc_copy_partition uption into UPT block ranges in datafile copies for all database incarnations.
RC_DATABASE information about databases and their current incarnations.
RC_DATABASE_INCARNATION information about all incarnations registered in recovery catalog.
RC_DATAFILE information about all datafiles registered in recovery catalog.
RC_DATAFILE_COPY datafile copies (on disk ).
RC_LOG_HISTORY information about redo log history.
RC_OFFLINE_RANGE offline ranges for datafiles.
RC_REDO_LOG information about online redo logs.
RC_REDO_THREAD information about redo threads.
RC_RESYNC information about recovery catalog resyncs (checkpoints ).
RC_STORED_SCRIPT stored scripts.
RC_STORED_SCRIPT_LINE each line of each stored script.
RC_TABLESPACE information about all tablespaces registered in recovery catalog.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.