oracle数据坏块处理（一）-通过rman备份修复

表有坏块时，全表查询会报错： 这时候如果有前面正常的rman备份，那么我们就可以通过rman备份直接对数据文件块做恢复先对数据文件做个逻辑检查：RMAN> backup check logical VALIDATE DATAFILE '+EXB_DATA/exb/datafile/cuteinfo.290.948015321'; Starting backup at 13-APR-22 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=65 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00005 name=+EXB_DATA/exb/datafile/cuteinfo.290.948015321 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 28    FAILED 0              355          1280            12504828     File Name: +EXB_DATA/exb/datafile/cuteinfo.290.948015321   Block Type Blocks Failing Blocks Processed   ---------- -------------- ----------------   Data       0              775                Index      0              0                  Other      1              150    或者直接检查数据文件：VALIDATE DATAFILE 5 检查完，我们可以通过视图查询到坏块信息 select * from v$database_block_corruption;      FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO     CON_ID ---------- ---------- ---------- ------------------ --------- ----------          28        355424          1                  0 CORRUPT            0 使用rman进行块恢复： RMAN> blockrecover datafile 28 block 355424 from backupset;Starting recover at 13-APR-22 using channel ORA_DISK_1channel ORA_DISK_1: restoring block(s) channel ORA_DISK_1: specifying block(s) to restore from backup set restoring blocks of datafile 00028 channel ORA_DISK_1: reading from backup piece /arch/backup/12c/full_0413_hi0qrt9h_1_1.bak channel ORA_DISK_1: piece handle=/arch/backup/12c/full_0413_hi0qrt9h_1_1.bak tag=TAG20220413T164537 channel ORA_DISK_1: restored block(s) from backup piece 1 channel ORA_DISK_1: block restore complete, elapsed time: 00:00:01starting media recovery media recovery complete, elapsed time: 00:00:03Finished recover at 13-APR-22块恢复后，执行BLOCKRECOVER CORRUPTION LIST，会自动按照V$DATABASE_BLOCK_CORRUPTION进行修复(耗时较长)： RMAN> BLOCKRECOVER CORRUPTION LIST;Starting recover at 13-APR-22 using channel ORA_DISK_1starting media recovery media recovery complete, elapsed time: 00:00:00Finished recover at 13-APR-22 个时候再访问v$database_block_corruption就看不到详细的坏块信息了： SQL> select * from v$database_block_corruption;no rows selected再使用dbv检查发现没有坏块了。