RMAN恢复坏块（有备份）

来源：互联网发布：mysqldump导出表数据编辑：程序博客网时间：2024/05/16 12:06

坏块产生之前进行了备份SQL> select count(1) from testbbed;select count(1) from testbbed*ERROR at line 1:ORA-01578: ORACLE data block corrupted (file # 5, block # 136)ORA-01110: data file 5: '/u01/app/oracle/oradata/single2/test1.dbf'RMAN> blockrecover datafile 5 block 136;Starting recover at 17-FEB-16using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=38 device type=DISKchannel ORA_DISK_1: restoring block(s)channel ORA_DISK_1: specifying block(s) to restore from backup setrestoring blocks of datafile 00005channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/SINGLE2/backupset/2016_02_17/o1_mf_nnndf_TAG20160217T043412_cd71y4j6_.bkpchannel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/SINGLE2/backupset/2016_02_17/o1_mf_nnndf_TAG20160217T043412_cd71y4j6_.bkp tag=TAG20160217T043412channel ORA_DISK_1: restored block(s) from backup piece 1channel ORA_DISK_1: block restore complete, elapsed time: 00:00:01starting media recoverymedia recovery complete, elapsed time: 00:00:01Finished recover at 17-FEB-16SQL> select count(1) from testbbed;  COUNT(1)----------      2834

0 0