Oracle动态性能视图|备份相关视图
文章平均质量分 79
WarriorTan
这个作者很懒,什么都没留下…
展开
-
RMAN备份动态性能视图 V$BACKUP_SET
V$BACKUP_SETV$BACKUP_SET displays information about backup sets from the control file. A backup set record is inserted after the backup set is successfully completed.ColumnDataty原创 2016-05-06 16:26:11 · 2948 阅读 · 0 评论 -
RMAN备份动态性能视图 V$BACKUP_SET_DETAILS
V$BACKUP_SET_DETAILS provides detailed information about the backup set. This view will contain an extra row for each backup session that invokes BACKUP BACKUPSET (that is, creates new copies for th原创 2016-05-06 17:28:34 · 1930 阅读 · 0 评论 -
RMAN备份动态性能视图 V$BACKUP_PIECE
V$BACKUP_PIECE displays information about backup pieces from the control file. Each backup set consists of one or more backup pieces.V$BACKUP_PIECE显示有关从控制文件的备份片信息。每个备份集包含一个或多个备份片。C原创 2016-05-07 13:04:54 · 2296 阅读 · 0 评论 -
RMAN备份动态性能视图 V$BACKUP_SET_SUMMARY
该视图中只有一条记录,统计自所有备份集的数据,此视图不常用。V$BACKUP_SET_SUMMARY provides summary information for a backup set.ColumnDatatypeDescriptionNUM_BACKUPSETSNUMBERTotal number o原创 2016-05-07 17:04:27 · 1137 阅读 · 0 评论 -
RMAN备份动态性能视图 V$BACKUP_CORRUPTION
这个视图中记录了备份集中发现的损坏的数据块,通常是当你在RMAN中执行了BACKUP VALIDATE命令对备份集进行检查后,如果发现有操作的数据块,就会向该视图中插入记录。注意不包括控制文件或归档文件,因为这两类文件都是独立个体,一旦损坏就表示彻底完蛋,不可修复,不像数据块,就算某个数据块坏了也没关系,还可以用其他备份集中匹配的数据进行修复。该视图的列定义都比较简单,字面意义理解即可,就不过多描原创 2016-05-07 18:05:54 · 1064 阅读 · 0 评论 -
RMAN备份动态性能视图 V$ARCHIVED_LOG
V$ARCHIVED_LOG displays archived log information from the control file, including archive log names. An archive log record is inserted after the online redo log is successfully archived or cleared (原创 2016-05-07 18:09:29 · 3070 阅读 · 0 评论