构建并修复逻辑损坏块和物理损坏块(三)

2014-11-24 00:34:04 · 作者: · 浏览: 50
188 to 8191 Dba:0x01400014 ------------------------------------------------------- ff060000 l .... <16 bytes per line>

而逻辑损坏的修复,通常是使用dbms_repair 包将损坏块忽略

SQL> exec dbms_repair.skip_corrupt_blocks('SYS','T1');

PL/SQL procedure successfully completed.

SQL> update t1 set object_name=rownum;

22849 rows updated.

SQL> commit;

Commit complete.