RMAN备份动态性能视图 V$BACKUP_CORRUPTION
来源:互联网 发布:js json对象的长度 编辑:程序博客网 时间:2024/06/04 19:22
这个视图中记录了备份集中发现的损坏的数据块,通常是当你在RMAN中执行了BACKUP VALIDATE命令对备份集进行检查后,如果发现有操作的数据块,就会向该视图中插入记录。注意不包括控制文件或归档文件,因为这两类文件都是独立个体,一旦损坏就表示彻底完蛋,不可修复,不像数据块,就算某个数据块坏了也没关系,还可以用其他备份集中匹配的数据进行修复。该视图的列定义都比较简单,字面意义理解即可,就不过多描述了。
V$BACKUP_CORRUPTION
displays information about corrupt block ranges in datafile backups from the control file. Note that corruptions are not tolerated in the control file and archived redo log backups.
RECID
NUMBER
Backup corruption record IDSTAMP
NUMBER
Backup corruption record stampSET_STAMP
NUMBER
Backup set stampSET_COUNT
NUMBER
Backup set countPIECE#
NUMBER
backup piece that contains this corrupt blockFILE#
NUMBER
Absolute file number of the datafile that contains the corrupt blocksBLOCK#
NUMBER
Block number of the first corrupt block in the range of corrupted blocksBLOCKS
NUMBER
Number of corrupted blocks found starting with BLOCK#
CORRUPTION_CHANGE#
NUMBER
Change number at which the logical corruption was detected. Set to 0 to indicate media corruption.MARKED_CORRUPT
VARCHAR2(3)
Indicates whether this corruption was not previously detected by the Oracle Database (YES
) or the Oracle Database had already discovered this corrupt block and marked it as corrupt (NO
). Note that when a corrupt block is encountered in a backup, and was not already marked corrupt by the Oracle Database, then the backup process does not mark the block as corrupt in the production datafile. Thus, this field may beYES
for the same block in more than one backup set.CORRUPTION_TYPE
VARCHAR2(9)
Type of block corruption in the datafile:ALL ZERO
- Block header on disk contained only zeros. The block may be valid if it was never filled and if it is in an Oracle7 file. The buffer will be reformatted to the Oracle8 standard for an empty block.FRACTURED
- Block header looks reasonable, but the front and back of the block are different versions.CHECKSUM
- optional check value shows that the block is not self-consistent. It is impossible to determine exactly why the check value fails, but it probably fails because sectors in the middle of the block are from different versions.CORRUPT
- Block is wrongly identified or is not a data block (for example, the data block address is missing)LOGICAL
- Block is logically corruptNOLOGGING
- Block does not have redo log entries (for example,NOLOGGING
operations on primary database can introduce this type of corruption on a physical standby)
- RMAN备份动态性能视图 V$BACKUP_CORRUPTION
- RMAN备份动态性能视图 V$BACKUP_SET
- RMAN备份动态性能视图 V$BACKUP_SET_DETAILS
- RMAN备份动态性能视图 V$BACKUP_PIECE
- RMAN备份动态性能视图 V$BACKUP_SET_SUMMARY
- RMAN备份动态性能视图 V$ARCHIVED_LOG
- RMAN 动态性能视图
- RMAN备份相关的动态性能视图及监控
- 与rman备份有关的几个动态性能视图
- 动态性能视图:V$FILESTAT
- oracle-动态性能(V$)视图
- oracle 动态性能(V$)视图
- 动态性能视图 V$SESSION_LONGOPS
- RMAN相关动态性能视图及监控
- 动态性能视图v$mystat,v$sesstat,v…
- 动态性能视图v$mystat,v$sesstat,v…
- RMAN备份相关的动态性能表
- 【转】oracle 动态性能(V$)视图
- 数据结构x实验三--串的操作
- Phoenix 导出csv文件
- 动态规划—Problem O
- Android 异步加载图像优化,如:引入线程池、引入缓存
- scale data:线性空间映射
- RMAN备份动态性能视图 V$BACKUP_CORRUPTION
- Filter过滤器及HttpServletRequestWrapper使用
- Linux添加FTP用户并设置权限
- 全志A20 android4.4双屏异显 双屏同显终于可以了
- Move Zeroes
- MWC-MultiWii.cpp主程序理解
- 内存恶鬼drawRect - 谈画图功能的内存优化
- Android Volley完全解析(一),初识Volley的基本用法
- EventSystem