data block corruption urgent plz....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: data block corruption urgent plz....

  1. #1
    Join Date
    Jul 2007
    Posts
    32

    data block corruption urgent plz....

    hi,

    OS:windowsNT
    oracle:10.2

    Last saturday while taking backup (export) via TOAD i got an error like "there is no enough space in the output dumpfile specified location (E drive)".
    There is no enough space in the E: drive to a full DB backup so my export session terminated.

    In that E: i have three datafiles.

    My problem is, yesterday i cant start my database it gives error like
    "cant read datafile header 13
    I/O datablock corruption error" the datafile which is in the E drive is corrupted.

    my question is, Did the export which i took last saturday caused this? plz give me some sugesstions. am in a critical situ...

    Thanx...

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    It doesn't matter what corrupted your datafile; just hope you have a real backup and not an export.

    By the way, still amazes me yet, it doesn't surprises me anymore how people insist to put the words "backup" and "export" in the same phrase. If you do not have a real backup you are going to learn now "export is not a backup"
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    As PAVB said, if you do not have real backup, then recreate the database, import last good dump and let the people reenter all the data since the last dump

  4. #4
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44
    1st find out which block are corrupted by using DBVERIFY utility.

    C:\>dbv file =''your file name'' example =e:\oracle\oradata\test\hr.dbf

    Than you realize which block are corrupted.

    Suppose "datafile 13 block 50000 and 5505"


    Go to RMAN prompt

    RMAN> blockrecover datafile 13 block 5000,5505;

    Those step only work if you have physical backup.
    Last edited by liakat; 07-27-2007 at 01:39 AM.

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