Re: Datafile Header corruption on stage database -Need suggestions as there is no backup/archives

From: Shastry(DBA) <"Shastry>
Date: Wed, 29 Jun 2011 21:43:33 +0530
Message-ID: <BANLkTimxDcaBw2NoGYW+3pbo-B6GHm_KAQ_at_mail.gmail.com>

Hi all,
Since the database didnt have any backups, we had to recopy as the application team decided to go for fresh copy from production. Thanks everyone for the valuable suggestions.

Regards,
Shastry

>
>
> On Wed, Jun 8, 2011 at 9:50 PM, Stefan Knecht <knecht.stefan_at_gmail.com>wrote:
>
>> I would double check that you actually have the correct device mapped to
>> your /dev/mapper file.
>>
>> Perhaps something got screwed with the mapping after a reboot. Perhaps
>> somebody changed it earlier on, and the change didn't become active until
>> you rebooted.
>>
>> Many things could have happened, but a physical corruption is perhaps the
>> most unlikely to hit the header of your file.
>>
>> Check your setup thoroughly. Check if you have an earlier version of the
>> map device map config files, perhaps the unix admin takes backups or keeps a
>> history of these.
>>
>> Stefan
>>
>>
>>
>> =========================
>>
>> Stefan P Knecht
>> CEO & Founder
>> s_at_10046.ch
>>
>> 10046 Consulting GmbH
>> Schwarzackerstrasse 29
>> CH-8304 Wallisellen
>> Switzerland
>>
>> Phone +41-(0)8400-10046
>> Cell +41 (0) 79 571 36 27
>> info_at_10046.ch
>> http://www.10046.ch
>>
>> =========================
>>
>>
>> On Tue, Jun 7, 2011 at 8: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.
>>> 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
>>>
>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 29 2011 - 11:13:33 CDT