Re: Recovering database with no backup!

Yanick Hudon <yannik_at_sympatico.ca> wrote in message news:E15a9.108$z21.45462_at_news20.bellglobal.com...
> Hi all,
>
> Sorry if the post is a little bit long, but i think it worth to
tell if
> ever someone else has the same problem.
>
> After 3 hard days working on a recovery and some reading with
any
> advices from you, i succeeded

[]

> Now the lessons i've got from this crash:
>
> 1) Be sure to always have a backup of the database (even if i
still
> don't know how);
> 2) If #1 is not available, at least get a copy of all the
control files,
> data files, tablespace you're using;
> 3) If you don't have #1 or #2, you're in real trouble.
>
> Last thing: When you're doing this procedure, ensure that you'll
be able
> to recreate all the disk partitions
> like they were before (logical, extended, and
physical
> partitions).
>
> Thanks to all who helped me in this wonderful adventure.
>
>

Primary rule of backup and recovery: It doesn't work until you test it.

IOW do trial run of you recovery process before you have crash. Received on Thu Aug 29 2002 - 13:41:09 CDT