Re: Oracle Data Recovery

> as you could have mounted the database after re-installing the oracle
> binaries, created a service, etc.

Out of curiosity, can you elaborate on the "etc." part of this equation? I would be very interested to learn, for future reference, how to perform this type of recovery in the correct manner.

"Paul Drake" <paled_at_home.com> wrote in message news:3B7E3520.FA1D58BE_at_home.com...
> Tim Mason wrote:
> >
> > A customer have two web servers running Windows NT, Cold Fusion and
> > Oracle 8.05. The systems drives are arranged with the first 2 drives
> > in Raid 1 as C:, the last 3 drives are Raid 5 as D:.
> >
> > The Oracle database files reside on the D: Last week an NT admin
> > crashed both system and had to rebuild the systems C:, this also wiped
> > out the installation of Oracle. We have been unable to access the ORA
> > files. We originally attempted to create a table space and point it
> > at an existing ORA file. This action appeared to clear the ora file
> > and was stopped before it deleted all the data. Is there a way to
> > recover the data from these ORA files? If there is can anyone give me
> > any pointers as to how to do this.
> >
> > Thanks,
> > Tim Mason
>
> Tim,
>
> You were fine up to the point in which you used the command:
>
> CREATE TABLESPACE <tablespace_name> DATAFILE <file_name> REUSE;
>
> as you could have mounted the database after re-installing the oracle
> binaries, created a service, etc.
>
> At this point - you're hosed. The headers in the datafile are gone.
>
> Do you have *any* backups of the data files?
>
> Oracle Worldwide Support is your best bet - the data unloader tool may
> be able to salvage some data.
> It starts at around $10,000 for a tech to show up with the tool.
>
> As far as the remaining datafiles, you may still be able to mount them.
> So you still have the SYSTEM tablespace's datafile?
>
> Backup everything that you do have before doing anything else.
>
> I wish you luck,
>
> Paul
Received on Sun Aug 19 2001 - 12:45:05 CDT