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