Re: Datafile Header corruption on stage database -Need suggestions as there is no backup/archives
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Wed, 8 Jun 2011 13:59:49 +0100
Message-ID: <BANLkTikzUcimLf0rCkenVAWJkG+_5tmWwA_at_mail.gmail.com>
On Tue, Jun 7, 2011 at 7:18 PM, Shastry(DBA) <shastry17_at_gmail.com> 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
Date: Wed, 8 Jun 2011 13:59:49 +0100
Message-ID: <BANLkTikzUcimLf0rCkenVAWJkG+_5tmWwA_at_mail.gmail.com>
On Tue, Jun 7, 2011 at 7:18 PM, Shastry(DBA) <shastry17_at_gmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 08 2011 - 07:59:49 CDT