oracle坏块修复

oracle 12.2数据库坏块修复

1、进行坏块扫描

run{
allocate channel ch0 type disk;
backup  VALIDATE check logical database ;
release channel ch0 ;

}

 

2、执行rman命令修复坏块

rman target /

recover corruption list;

3、检查是否还有坏块

SELEcT file#, block#,corruption type FRoM v$database block corruption;