Re: File needs media recovery after recovery :(

"André Hartmann" <andrehartmann_at_hotmail.com> schrieb im Newsbeitrag news:40b650af$0$26347$9b4e6d93_at_newsread4.arcor-online.net...
> > <*Don't try this offhand*>
> > Do you have to "open resetlogs"?
> > </>
>
> I am sorry but what do you mean by that ????? close and re-opwen the
> database with resetlogs ? I cannot shutdown the dataabse. it needs 24/7
> availability.

You got lots of other good advice in this thread, so I'll be brief: - You've got a desaster on your hand. Face it as it is. - The standard solution is to do an inclomplete recovery, losing all   new data in the other data files too.
- If you *know* there are no consistency issues (like, those datafiles   serve different applications) you can set up a different database,   export the new stuff, do the inclomplete recovery on the database   containing bugen, export the partially recovered bugen into the   other database and then transfer all the stuff back into the first   database.
  However, I don't think you can do that without downtime. - My strong advice is: I agree with s.kapitza in that you should go   to oracle support for help. I did that too, once, when I had shot   a tablespace and they were very helpful and I got away with 45 minutes   downtime and no data loss. (Was a much easier problem though.)

Lots of Greetings!
Volker Received on Fri May 28 2004 - 04:28:39 CDT