Re: Datafile header surgery
- From: "Kurt Van Meerbeeck" <kurtvm@xxxxxxxxxx>
- To: Adam.Donahue@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 10 Jan 2007 19:02:19 +0000
I would go with rebuilding ...
Chances are high it's not only the file header that's corrupt - probably
some zero'd out blocks here and there - who knows...
And zero out means ... really really gone.
You might be able to extract some data out with a data unloader tho.
(expect for the zero'd out blocks of course)
ps - i'm a KBC customer ;-)
>----- Oorspronkelijk bericht -----
>Van: Donahue, Adam [mailto:Adam.Donahue@xxxxxxxxx]
>Verzonden: woensdag, januari 10, 2007 07:07 PM
>Aan: oracle-l@xxxxxxxxxxxxx
>Onderwerp: Datafile header surgery
>
>Has Oracle (or anyone else) published the header format for database
>datafiles?
>
>I ask because one of our datafiles was corrupted due to an nStor outage
>yesterday, and thus is triggered an ORA-01251 when one attempts to
>recover it:
>
>01251, 00000, "Unknown File Header Version read for file number %s"
>// *Cause: Read of the file header returned a record but its version
>cannot
>// be identified. Either the header has been corrupted, or the
>file
>// is not a valid database file.
>// *Action: Have the operating system make the correct file available to
>// the database, or recover the file.
>
>The database is in development and therefore isn't backed up, but before
>rebuilding I thought it might be interesting to attempt a manual hack to
>the header to get the database to load so that data could be extracted.
>Any other potential workarounds here?
>
>Adam
>
>--
>This message may contain confidential, proprietary, or legally privileged
>information. No confidentiality or privilege is waived by any transmission to
>an unintended recipient. If you are not an intended recipient, please notify
>the sender and delete this message immediately. Any views expressed in this
>message are those of the sender, not those of any entity within the KBC
>Financial Products group of companies (together referred to as "KBC FP").
>
>This message does not create any obligation, contractual or otherwise, on the
>part of KBC FP. It is not an offer (or solicitation of an offer) of, or a
>recommendation to buy or sell, any financial product. Any prices or other
>values included in this message are indicative only, and do not necessarily
>represent current market prices, prices at which KBC FP would enter into a
>transaction, or prices at which similar transactions may be carried on KBC
>FP's own books. The information contained in this message is provided "as is",
>without representations or warranties, express or implied, of any kind. Past
>performance is not indicative of future returns.
>
>--
>//www.freelists.org/webpage/oracle-l
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
