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

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