转载请注明出处,http://blog.csdn.net/guoyjoe/article/details/30965303
<强>
复苏经理:释放11.2.0.3.0——生产snippet_file_name=" blog_20140615_9_8362021 "> gyj@PROD>选择id、名称、dbms_rowid.rowid_relative_fno (rowid), dbms_rowid.rowid_block_number(从gyj_t1 rowid);ID名称DBMS_ROWID.ROWID_RELATIVE_FNO (ROWID) DBMS_ROWID.ROWID_BLOCK_NUMBER (ROWID) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1 oracledba 5 20869
[root@jfdb ~] # su -甲骨文(oracle@jfdb ~)美元bb parfile=持平。三种密码:bb:释放2.0.0.0.0 -有限生产snippet_file_name=" blog_20140615_4_7129331 "> BBED>验证DBVERIFY -验证文件开始=/u01/app/oracle/oradata/刺激/tp01。dbf块=20869块20869腐败腐败块相对dba: 0 x01405185(文件0块20869)骨折块验证数据中发现坏块:类型:6格式:2 rdba: 0 x01405185最后改变scn: 0 x0000.00176fed seq: 0 xff flg: 0 x06 spare1: 0 x0 spare2: 0 x0 spare3:尾巴0 x0一致性值:0 x6fed0601检查值块头:0 xc1be计算块校验和:0 x0 DBVERIFY -验证完成总块检查:1总块加工(数据):0总失败的(数据)块:总块加工(指数):0 0总块失败(指数):0总块空:0总块标志着腐败:1块流入总额:531没有找到消息;产品=RDBMS;设施=bb
gyj@PROD>改变系统冲洗buffer_cache;系统的改变。gyj@PROD>选择id、名称、dbms_rowid.rowid_relative_fno (rowid), dbms_rowid.rowid_block_number(从gyj_t1 rowid);选择id、名称、dbms_rowid.rowid_relative_fno (rowid), dbms_rowid.rowid_block_number (rowid)从gyj_t1 *误差在1号线:ora - 01578: ORACLE数据块损坏(文件# 5、# 20869块)ora - 01110: 5:数据文件'/u01/app/ORACLE/oradata/刺激/tp01。dbf的
RMAN>备份验证功能5;开始备份在使用通道ORA_DISK_1通道ORA_DISK_1 08-JUN-14:开始完全数据文件备份设置通道ORA_DISK_1:功能(s)备份指定的输入数据文件文件数量设置=00005名=/u01/app/oracle/oradata/刺激/tp01。dbf通道ORA_DISK_1:备份设置完成,运行时间:00:00:07 Datafiles列表=================文件状态标志着腐败的空块块检查高SCN - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 5 0 114 64000 1659211失败文件名称:/u01/app/oracle/oradata/刺激/tp01。dbf块类型阻塞失败处理- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -数据1 58883指数0 4221 0 782验证发现snippet_file_name=癰log_20140615_7_6738333”名称==癶tml”>“代码”类gyj@PROD>选择文件#,#块,块,CORRUPTION_CHANGE #,从v $ database_block_corruption CORRUPTION_TYPE文件#=5;文件#块#块CORRUPTION_CHANGE # CORRUPTIO - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 5 20869 1 0骨折
RMAN>blockrecover丢失5块20869;08-JUN-14使用通道ORA_DISK_1通道ORA_DISK_1开始恢复:恢复块(s)渠道ORA_DISK_1:指定阻止(s)恢复备份设置恢复丢失块00005频道ORA_DISK_1:读取备份块/u01/app/oracle/产品/11.2.0/dbs/01 pab691_1_1通道ORA_DISK_1:块处理=/u01/app/oracle/产品/11.2.0/dbs/01 pab691_1_1标签=TAG20140608T153040通道ORA_DISK_1:阻止(s)恢复备份块1频道ORA_DISK_1:块恢复完整,运行时间:00:00:01媒体开始复苏媒介恢复完成,运行时间:00:00:01完成恢复在08-JUN-14
gyj@PROD>选择文件#,#块,块,CORRUPTION_CHANGE #,从v $ database_block_corruption CORRUPTION_TYPE文件#=5;没有行选择
gyj@PROD>选择id、名称、dbms_rowid.rowid_relative_fno (rowid), dbms_rowid.rowid_block_number(从gyj_t1 rowid);null基于rman的坏块恢复
