RE: corrupt datafile
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 12 Jun 2004 16:03:29 -0500
Terry - Here is the Oracle manual chapter to help you decide if TSPITR might
help.
http://www.cise.ufl.edu/help/database/oracle-docs/server.920/a96572/ostspitr
.htm
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS
Sent: Saturday, June 12, 2004 3:59 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: corrupt datafile
Terry - You may want to consider a TSPITR. Tablespace Point-In-Time
Recovery. Do you have another server that you can perform this on? Then
export/import the data back to your production system.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Terry Sutton
Sent: Saturday, June 12, 2004 3:22 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: corrupt datafile
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: database file 5 failed verification check
ORA-01110: data file 5:
'/ora2/app/oracle/admin/dbn/data/dbn_data_01.dbf'
ORA-01251: 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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
