Re: Datafile Header corruption on stage database -Need suggestions as there is no backup/archives
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: shastry17@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Jun 2011 15:32:38 -0700 (PDT)
From where would you transport this tablespace? And since this tablespace
already exists in the database I can't expect using Transportable Tablespaces
to
do you much, if any, good.
What is in this tablespace? You could attempt to take the file offline but
what does Oracle support instruct you to do? You should really create an SR
for
this as a Sev 1 and get the assistance you (hopefully) have paid to receive.
David Fitzjarrell
________________________________
From: Shastry(DBA) <shastry17@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Tue, June 7, 2011 11:18:32 AM
Subject: Datafile Header corruption on stage database -Need suggestions as
there
is no backup/archives
Hi Oracle-l team,
We faced the below issue on May mid 2011 and DB was up and running and we
thought there is an issue in server itself post SA firmware maintenance. When
there was a chance to bounce the server, Database is having hiccups to come up.
Is there an option to use Transportable Tablespace? or keep this datafile
offline and bring the DB up.
Please lend your advice if there is any sort of recovery.
Description: SQL> startup
ORACLE instance started.
Total System Global Area 4731174912 bytes
Fixed Size 2090304 bytes
Variable Size 1140853440 bytes
Database Buffers 3573547008 bytes
Redo Buffers 14684160 bytes
Database mounted.
ORA-01122: database file 550 failed verification check
ORA-01110: data file 50: '/dev/mapper/oraSMSTG_data_010_8600Mp6'
ORA-01251: Unknown File Header Version read for file number 50
Database version = 10.2.0.4
Platform = Linux x86_64
Other related posts:
