Rman常用视图

超、凢脫俗 2023-10-18 21:33 3阅读 0赞

## Rman常用视图 ##

2012年09月24日 21:44:46 [dbatravel][] 阅读数 403

报告使用的 数据字典

<table> 
 <tbody> 
 <tr> 
 <td> View Name </td> 
 <td> Description </td> 
 <td> &nbsp; </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_ARCHIVELOG_DETAILS </td> 
 <td> 包含所有可还原归档日志的信息 </td> 
 <td> Contains information about all restorable archive logs </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_ASYNC_IO </td> 
 <td> 提供正在进行的和最近完成的rman备份和还原的性能信息 </td> 
 <td> rovides performance information about ongoing and recently completed RMAN backups and restores </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_CONTROLFILE_DETAILS </td> 
 <td> 提供可还原控制文件的信息 </td> 
 <td> Provides information about restorable control files </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_COPY_DETAILS </td> 
 <td> 提供可用的控制文件和数据文件副本的相关信息 </td> 
 <td> Provides information about all available control file and datafile copies </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_CORRUPTION </td> 
 <td> 提供从控制文件获得的关于数据文件备份损坏块的相关信息 </td> 
 <td> Provides information about corrupt block ranges in datafile backups from the control file </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_DATAFILE </td> 
 <td> 提供从控制文件获得的关于备份集中的数据文件和控制文件的信息 </td> 
 <td> Provides information about control files and datafiles in backup sets from the control file </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_DATAFILE_DETAILS </td> 
 <td> 提供可还原的数据文件的相关信息 </td> 
 <td> Provides information about restorable datafiles </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_FILES </td> 
 <td> 提供所有的rman备份的信息 </td> 
 <td> Provides information about all RMAN backups (both image copies and backup sets) and archived logs </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_PIECE </td> 
 <td> 提供从控制文件获得的备份片的信息 </td> 
 <td> Provides information about backup pieces from the control file </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_PIECE_DETAILS </td> 
 <td> 提供所有可用备份片的信息 </td> 
 <td> Provides information about all available backup pieces </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_REDOLOG </td> 
 <td> 提供从控制文件获得的在备份集中的归档日志的信息 </td> 
 <td> Provides information about archived logs in backup sets from the control file </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_SET </td> 
 <td> 提供从控制文件获得备份集的信息 </td> 
 <td> Provides information about backup sets from the control file </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_SET_DETAILS </td> 
 <td> 提供从控制文件获得备份集的详细信息 </td> 
 <td> Provides detailed information on backup sets from the control file </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_SPFILE </td> 
 <td> 提供从控制文件获得的在备份集中的服务器参数文件的信息 </td> 
 <td> Provides information from the control file on SPFILEs contained in backup sets </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_SPFILE_DETAILS </td> 
 <td> 提供从控制文件获得的在备份集中的服务器参数文件的详细信息 </td> 
 <td> Provides information from the control file on SPFILEs contained in backup sets </td> 
 </tr> 
 <tr> 
 <td> V$BACKUP_SYNC_IO </td> 
 <td> 提供正在进行的和最近完成的rman备份和还原的性能信息 </td> 
 <td> Provides performance information about ongoing and recently completed RMAN backups and restores </td> 
 </tr> 
 <tr> 
 <td> V$DATABASE_BLOCK_CORRUPTION </td> 
 <td> 提供上一次备份后损坏的数据库的信息 </td> 
 <td> Provides information about database blocks that were corrupted after the last backup </td> 
 </tr> 
 <tr> 
 <td> V$RECOVER_FILE </td> 
 <td> 包含需要进行介质恢复的文件的状态信息 </td> 
 <td> Contains the status of files needing media recovery </td> 
 </tr> 
 <tr> 
 <td> V$RECOVER </td> 
 <td> 提供与恢复区有关的信息 </td> 
 <td> Provides information about recovery areas </td> 
 </tr> 
 <tr> 
 <td> V$RMAN_BACKUP_JOB_DETAILS </td> 
 <td> 提供备份工作的详细信息 </td> 
 <td> Provides details about backup jobs </td> 
 </tr> 
 <tr> 
 <td> V$RMAN_BACKUP_TYPE </td> 
 <td> 提供rman备份类型的信息 </td> 
 <td> Provides information about RMAN backup types </td> 
 </tr> 
 <tr> 
 <td> V$RMAN_CONFIGURATION </td> 
 <td> 提供rman的持久性配置设置有关的信息 </td> 
 <td> Provides information about RMAN persistent configuration settings </td> 
 </tr> 
 <tr> 
 <td> V$RMAN_OUTPUT </td> 
 <td> 提供由rman报告的信息 </td> 
 <td> Displays messages reported by RMAN </td> 
 </tr> 
 <tr> 
 <td> V$RMAN_STATUS </td> 
 <td> 提供rman完成的和正在进行的工作的信息 </td> 
 <td> Contains information on the finished and ongoing RMAN jobs </td> 
 </tr> 
 </tbody> 
</table>

[dbatravel]: https://me.csdn.net/dbatravel