Re: BIG PROBLEM - NEED HELP

"Anna C. Dent" <anacedent_at_hotmail.com> wrote in message news:7Ms6b.113890$kP.53787_at_fed1read03...

> > ITīS VERY URGENT
nothing is urgent when you lost data files.

> The FIRST thing you should do is calm down, take a couple of deep
> breaths and then start a full system backup. While it runs, you'll
> have time to rationally decide what your "best" option is and how
> to accomplish that goal. Just getting the DB open, is the least of
> your current problems.

Very good point. At the very least, backup the current control file and redo logs. Without those in their condition just after the incident, it's awfully hard to go back and re-try anything...

>
> The following need to be answered:
> What caused the two files to disappear?
> What can be done to prevent additional files from going missing?
> How are you going to recover the data that was in the two lost files?
>

Very good points, all of them. Time for a cuppa and some serious thinking, rather than just mindless knee-jerk reactions.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam