corrupt datafile 2004-06-12 - By Terry Sutton
A new client has a serious corruption error. During a hot backup (not RMAN) Thursday morning it was discovered that a datafile was corrupted on the disk. When the database is started up, the following error occurs:
"ORA-01122 (See ORA-01122.ora-code.com): database file 5 failed verification check
ORA-01110 (See ORA-01110.ora-code.com): data file 5:
'/ora2/app/oracle/admin/dbn/data/dbn_data_01.dbf '
ORA-01251 (See ORA-01251.ora-code.com): Unknown File Header Version read for file number 5 "
When dbverify is run against this file, every block is indicated as corrupt, which isn 't surprising.
We have a copy of the datafile from Wednesday 's hot backup, but they don 't have the archivelogs necessary to sync this datafile with the rest of the database. And we don 't have the other datafiles from Wednesday 's backup, so we can 't just go back to the state the database was in then.
Any ideas on what they can do? I can 't think of anything (other than going back to an export they have from 6 months ago, which seems to be the only historical backup they have).
--Terry
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD >
<META http-equiv=Content-Type content= "text/html; charset=iso-8859-1 " >
<META content= "MSHTML 6.00.2800.1400 " name=GENERATOR >
<STYLE > </STYLE >
</HEAD >
<BODY bgColor=#ffffff >
<DIV > <FONT face=Arial size=2 >A new client has a serious corruption error.
During a hot backup (not RMAN) Thursday morning it was discovered that a
datafile was corrupted on the disk. When the database is started up, the
following error occurs: </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT > </DIV >
<DIV > "ORA-01122 (See ORA-01122.ora-code.com): database file 5 failed verification check <BR >ORA-01110 (See ORA-01110.ora-code.com): data
file 5: <BR > '/ora2/app/oracle/admin/dbn/data/dbn_data_01.dbf ' <BR >ORA-01251 (See ORA-01251.ora-code.com):
Unknown File Header Version read for file number 5 " <BR > </DIV >
<DIV > <FONT face=Arial size=2 >When dbverify is run against this file, every block
is indicated as corrupt, which isn 't surprising. </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >We have a copy of the datafile from
Wednesday 's hot backup, but they don 't have the archivelogs necessary to sync
this datafile with the rest of the database. And we don 't have the
other datafiles from Wednesday 's backup, so we can 't just go back to the state
the database was in then. </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >Any ideas on what they can do? I can 't think
of anything (other than going back to an export they have from 6 months ago,
which seems to be the only historical backup they have). </FONT > </DIV >
<DIV > <FONT face=Arial size=2 > </FONT > </DIV >
<DIV > <FONT face=Arial size=2 >--Terry </FONT > </DIV > </BODY > </HTML >
|
|
