corrupted data block recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: corrupted data block recovery

  1. #1
    Join Date
    Oct 2001
    Posts
    2
    hi,

    I am Junior member. I have got problem of data block corruption error in one large table.

    can anyone guide me that how to do the recovery?

    Thanks in advance

    Junior member

  2. #2
    Join Date
    Oct 2001
    Location
    Buffalo, NY
    Posts
    46
    First off,a couple ?s...are you in archive mode? what BU method are you using, e.g. RMAN, cold, hot?
    Tim Hussar

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Extracting good rows from the table is a huge process.
    You must know various methods, like using ROWID (min / max) , PK etc.

    The simple solution is:
    Create a temp table by using CREATE TABLE aaa SELECT * from corrupted table order by PK DESC.
    Then Use INSERT INTO aaa SELECT * from corrupted table order by PK ASC.

  4. #4
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    you may be helped by this:

    run dbverify to fix that corruption..if it is at Oracle level that will take care of it.
    after that:
    create temp_x as select * from x
    extract the index definitions on x or note on ehich columns you have indexes and what type. also constraints.
    drop table x
    rename temp_x as x and recreate the indexes.
    enable constraints.
    sonofsita
    http://www.ordba.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width