Rman常用视图

报告使用的数据字典

View Name

Description

 

V$BACKUP_ARCHIVELOG_DETAILS

包含所有可还原归档日志的信息

Contains information about all restorable archive logs

V$BACKUP_ASYNC_IO

提供正在进行的和最近完成的rman备份和还原的性能信息

rovides performance information about ongoing

and recently completed RMAN backups and restores

V$BACKUP_CONTROLFILE_DETAILS

提供可还原控制文件的信息

Provides information about restorable control files

V$BACKUP_COPY_DETAILS

提供可用的控制文件和数据文件副本的相关信息

Provides information about all available control file

and datafile copies

V$BACKUP_CORRUPTION

提供从控制文件获得的关于数据文件备份损坏块的相关信息

Provides information about corrupt block ranges in

datafile backups from the control file

V$BACKUP_DATAFILE

提供从控制文件获得的关于备份集中的数据文件和控制文件的信息

Provides information about control files and

datafiles in backup sets from the control file

V$BACKUP_DATAFILE_DETAILS

提供可还原的数据文件的相关信息

Provides information about restorable datafiles

V$BACKUP_FILES

提供所有的rman备份的信息

Provides information about all RMAN backups (both

image copies and backup sets) and archived logs

V$BACKUP_PIECE

提供从控制文件获得的备份片的信息

Provides information about backup pieces from the

control file

V$BACKUP_PIECE_DETAILS

提供所有可用备份片的信息

Provides information about all available backup pieces

V$BACKUP_REDOLOG

提供从控制文件获得的在备份集中的归档日志的信息

Provides information about archived logs in backup

sets from the control file

V$BACKUP_SET

提供从控制文件获得备份集的信息

Provides information about backup sets from the

control file

V$BACKUP_SET_DETAILS

提供从控制文件获得备份集的详细信息

Provides detailed information on backup sets from

the control file

V$BACKUP_SPFILE

提供从控制文件获得的在备份集中的服务器参数文件的信息

Provides information from the control file on

SPFILEs contained in backup sets

V$BACKUP_SPFILE_DETAILS

提供从控制文件获得的在备份集中的服务器参数文件的详细信息

Provides information from the control file on

SPFILEs contained in backup sets

V$BACKUP_SYNC_IO

提供正在进行的和最近完成的rman备份和还原的性能信息

Provides performance information about ongoing

and recently completed RMAN backups and restores

V$DATABASE_BLOCK_CORRUPTION

提供上一次备份后损坏的数据库的信息

Provides information about database blocks that

were corrupted after the last backup

V$RECOVER_FILE

包含需要进行介质恢复的文件的状态信息

Contains the status of files needing media recovery

V$RECOVER

提供与恢复区有关的信息

Provides information about recovery areas

V$RMAN_BACKUP_JOB_DETAILS

提供备份工作的详细信息

Provides details about backup jobs

V$RMAN_BACKUP_TYPE

提供rman备份类型的信息

Provides information about RMAN backup types

V$RMAN_CONFIGURATION

提供rman的持久性配置设置有关的信息

Provides information about RMAN persistent

configuration settings

V$RMAN_OUTPUT

提供由rman报告的信息

Displays messages reported by RMAN

V$RMAN_STATUS

提供rman完成的和正在进行的工作的信息

Contains information on the finished and ongoing

RMAN jobs