Re: lost redo logs, but have consitent offline backup

On Fri, 13 Nov 1998, Chuck Hamilton wrote:

> 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.
>
> 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.

You are right, but as Thomas Kyte just posted, you can trick a totally consistent Oracle database into thinking it has just performed an incomplete recovery. In my rather terse response, I neglected to mention that this would be necessary.

alter database recover database until cancel using backup controlfile; alter database recover cancel;

You don't have to apply any redologs to make this happen.

It is worth noting that in the new world of RMAN, closed database backups do not include the online redologs. It is meaningless data for a database that was closed cleanly. The only catch when you are not using RMAN is that you have to type the above commands to make it work.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Fri Nov 13 1998 - 17:32:53 CST