最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
rman连接catalog备份时使用的基表解释
时间:2022-06-29 09:32:26 编辑:袖梨 来源:一聚教程网
rman连接catalog备份时使用的基表和view,解释如下:
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.
BRL 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_CORRUPTION corrupt 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_CORRUPTION corrupt 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.