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