rman 恢复数据块
renjixinchina
2012-07-26 10:35:58
Linux操作系统
原创
backup validate datafile 1;
backup validate check logical database;--全库检测
select * from v$database_block_corruption where file#=4;
blockrecover datafile 4 block 35 from backupset;
如需要恢复v$database_block_corruption全部坏块
BLOCKRECOVER CORRUPTION LIST
ORA-01578(数据块损坏)跳过坏块
FLASHBACK 恢复表