Datafile Header corruption on stage database -Need suggestions as there is no backup/archives
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Jun 2011 23:48:32 +0530
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:
