Re: Datafile Header corruption on stage database -Need suggestions as there is no backup/archives
- From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- To: shastry17@xxxxxxxxx
- Date: Wed, 8 Jun 2011 13:59:49 +0100
On Tue, Jun 7, 2011 at 7:18 PM, Shastry(DBA) <shastry17@xxxxxxxxx> wrote:
> 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.
>
> 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
Hi,
Looks like your database is using raw devices.
Did you check if this block device exist
'/dev/mapper/oraSMSTG_data_010_8600Mp6' and if user oracle has full
access to it ?
Do you have a backup of this file ? You can restore this database from
backup using RMAN and then open db.
Is this DB running in archive log mode ?
regards,
--
Marcin Przepiorowski
http://oracleprof.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
