Re: Rule number 1 of an Oracle recovery process

From: Sean M <smckeownNO_at_BACKSIESadelphia.net>
Date: Wed, 21 Aug 2002 09:06:59 -0600
Message-ID: <3D63AC93.3203ED3A@BACKSIESadelphia.net>

Nuno Souto wrote:
>
> TAKE AN IMMEDIATE BACKUP OF YOUR CURRENT CONTROLFILES, IF THEY ARE
> ACCESSIBLE.
Definitely a good idea.

> I've seen this happen so many times it's not even funny anymore:
> if a recovery process needs to be re-started because something went wrong
> and you haven't kept a copy of a controlfile as it was before you started
> the recovery, you are stuck big time.

I don't think it's as bad as this. You can always recreate your controlfile via sql and perform any recovery you would have otherwise performed with the real deal. Sure, it's more complicated and therefore prone to error, so the backup you mentioned is good advice. But I wouldn't go so far as to say you're "stuck big time."

Regards,
Sean Received on Wed Aug 21 2002 - 10:06:59 CDT