Re: lost redo logs, but have consitent offline backup

On Thu, 12 Nov 1998 12:36:43 -0800, Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote:

>
>Actually, you are both wrong. There is no reason to back up the online
>redologs of a database that was backed up cold after a normal or immediate
>shutdown. All the user needs to do after restoring the datafiles,
>controlfile, and parameter files, is ALTER DATABASE OPEN RESETLOGS; and
>the redologs will reinitialize.
>
>Good luck,

Try it. It doesn't work on a 7.3 database. RESETLOGS is only allowed after incomplete recovery (i.e. point in time, or change# based recovery). And to do incomplete recovery you need the logs... catch 22.

--
Chuck Hamilton
chuckh_at_safeaccess.net

"Therefore the Lord Himself will give you a sign: Behold, a virgin will be with child, and bear a son, and she will call His name Immanuel." (Isa 7:14 NASB) Received on Fri Nov 13 1998 - 09:23:16 CST