Re: backup and recovery procedures / resetlog

From: Sean M <smckeownNO_at_BACKSIESearthlink.net>
Date: Tue, 02 Jul 2002 14:07:02 -0600
Message-ID: <3D2207E6.612BDAD0@BACKSIESearthlink.net>

Sybrand Bakker wrote:
>
> 1 Assume your restore fails. Need I say more. If you didn't make a
> backup of the current situation you've just lost everything.

Sort of. You can always re-restore your backup, recreate your controlfile, and, assuming your incomplete recovery stops short of the redo in the online redo logs, try your recovery again.

> 2 The hot backup will be inconsistent, as every hot backup. Which is
> why the redologs come into play. You can't go back to before the
> resetlogs,NEVER.

"NEVER" is too strong a word. See Richard Foote's response to Howard in the "Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb" thread:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&frame=right&rnum=31&thl=991247960,991246033,991246600,991241786,991240073,991227138,991224325,991222295,990642254,990531371,991351908,991270838&seekm=afji88%24o5h%241%40lust.ihug.co.nz#link38

Obviously this is messy, painful, and most likely unsupported. But still possible.

Futhermore there are completely supported methods of restoring pre-resetlogs backups of certain datafiles to a post-resetlogs database (read-only tablespaces, read-write backups taken immediately prior to the resetlogs, etc.).

Regards,
Sean Received on Tue Jul 02 2002 - 15:07:02 CDT