2018-05-22 Oracle 01578 block currupt

Published on:

KSWHS01因換硬碟,導致 block corrupt

依照這兩篇所述,資料移轉救回
http://logic.edchen.org/how-to-resolve-ora-01578-ora-01110-and-ora-26040

https://docs.oracle.com/cd/B28359_01/server.111/b28310/repair004.htm#ADMIN11835

1.用 sysdba的身份登入
2.Skip corrupted blocks

BEGIN
DBMS_REPAIR.SKIP_CORRUPT_BLOCKS (
     SCHEMA_NAME => 'KSADMIN',
     OBJECT_NAME => 'WHSSTOCK',
     OBJECT_TYPE => dbms_repair.table_object,
     FLAGS => dbms_repair.skip_flag);
END;
/

3.Move table to other place

alter table ksadmin.whsstock move;
  1. BEGIN
    DBMS_REPAIR.SKIP_CORRUPT_BLOCKS (
     SCHEMA_NAME => 'KSADMIN',
     OBJECT_NAME => 'WHSSTOCK',
     OBJECT_TYPE => dbms_repair.table_object,
     FLAGS => dbms_repair.NOSKIP_FLAG);
    END;
    /
    

Comments

comments powered by Disqus