Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003

    Red face Unanswered: Oracle data file corrupted

    hi friends,

    "###<block no> oracle datafile corrupted"

    This is the message I am getting when i try to insert,
    delete,update rows to the tables in the database.
    But i can run select queries without any problem.

    My database export file size is of around 3 GB.
    Database version is Oracle8.0.6 on Windows platform.

    Expecting your sincere reply at the earliest.

    Thanking you.
    Last edited by binoy_jd; 03-18-04 at 02:21.

  2. #2
    Join Date
    Jan 2004
    Have you run dbverify on the datafile?

    Do you know the object which contains the corrupted block?

  3. #3
    Join Date
    Jul 2003
    what does your alert.log say regarding this error?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Jan 2004
    First need to confirm about the extent of the damage ie the objects that are damaged. For which there is a diagnostics
    DBMS_ADMIN or maybe the name is not correct but its available in Orcale docs
    Do u run the DB in Archivelogmode?
    U have two options.
    1. If u have a good consistent backup of the datafile copy it and do media recovery...
    2.Use some diagnostics like DBMS_REPAIR package which will skip the corrupted portion when Oracle will be scanning for data.

    In any case u might loose data.
    Last edited by kausik_m123; 03-18-04 at 11:36.

Posting Permissions

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