Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Unanswered: datafile corruption.

    hello all,
    we are using oracle 8.1.5 on solaris.
    Our db is in archive log mode.
    one of the datafile is corrupted due to which when certain tables are queried we encounter the following error...

    ORA-00376:file 15 cannot be read at this time
    ORA-01110:datafile 15 '/u02/...'

    when we query v$datafile the "status" is shown as "RECOVER".

    when we give SQL>recover datafile '/u02/...' ; we get..

    ORA-00283: recovery session canceled due to errors
    ORA-01122: database file 15 failed verification check
    ORA-01110: data file 15: '/u02/oracle/dbs/oradata/gfelcra/temp.dbf'
    ORA-01251: Unknown File Header Version read for file number 15

    very few segments(tables and indexes) are pointing to the file #15.

    Can anyone please provide me the right work around for the problem.

    THanks & Regards,
    Sridhar

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    restore the database file from your last good backup. Restore all your backed up archive logs since the last good backup, issue the recover command on the datafile. You will now be up. If you are not running in archive log mode and do not have any backups then you are out of luck.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89
    Quote Originally Posted by beilstwh
    restore the database file from your last good backup. Restore all your backed up archive logs since the last good backup, issue the recover command on the datafile. You will now be up. If you are not running in archive log mode and do not have any backups then you are out of luck.

    Thanks beilstwh,
    few of our recent archeived log files are been deleted accedentally.I redirect all the segments pointing to "datafile 15" to other tablespace(alter table move tablespace/rebuild index).It works,meaning now we are not getting the error mesg. anymore.
    but Iam not sure weahter this is a proper solution.

    Thanks & Regards,
    Sridhar

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If you have moved all the objects out of the tablespace into another one and the corrupted tablespace is empty then I would drop the tablespace and then rebuild it (if needed). You do not want to keep a corrupted tablespace around.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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