Re: corrupt datafile

In article <954R9.1116$KM.90452994_at_newssvr17.news.prodigy.com>, Karsten says...
>
>ronia wrote:
>> Supose I have only a datafile data.dbf
>> I not have system.dbf, redologs.dbf temp.dbf etc.
>>
>> Are anyway to recover the data. At least manualy???
>> I heard that Oracle Consulting can do it.
>>
>Hmm. Bad situation. Yes, Oracle Consulting can do it ... they have a
>tool - actually from the developers - that can read a DBF file as though
>it were an ordinary O/S file and produce a SQL Loader CSV file. If you
>are ambitious enough, you could write a similar tool (but I suspect you
>need to retrieve the data right now ... not 6 months from now when you
>might finish coding the tool).

Zip. I think you're talking about DUL, which is a Support tool, not Consulting. And IIRC, it MUST be used by a support engineer, rather than anyone else.

Pete
>
>I doubt the following will work (never tried it myself), but you might
>give it a go before spending the big money to bring in a Consultant:
>
>1. Place your data file (data.dbf) in the directory of another database
>(create one if you don't have another handy).
>
>2. Create a new tablespace in this other db that refers to data.dbf as
>its datafile. You might have to place it offline for now. If Oracle
>complains at this point, and you don't know what it's complaining about,
>call the Consultant.
>
>3. Bounce the database. At this point, I expect Oracle will complain
>about the datafile being out of sync with the control file. Perform a
>recovery and reset the control file (resetlogs). There will be nothing
>to recover for data.dbf in the redo logs on this other db.
>
>4. If the above fails, call Oracle support. In fact, I'd probably do
>that anyhow because they might have a solution that they can walk you
>thru that's more "correct" than my wild guess procedure.
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Jan 03 2003 - 06:58:34 CST