Re: Is this method of offline backup OK?

Murali wrote:
>
> > Sorry, "alter database add logfile"? Why would I do that? Why wouldn't
> > I just do an alter database clear logfile group "x"? That way I don't
> > have to bother getting the file format correct, and I don't have to
> > bother dropping the old groups.
> >
>
> Sorry for jumping in at this juncture, but why drop, add or clear
> logfiles ? You can do an "alter database recover until cancel" (fake
> recovery) and then open resetlogs. That will create the logfiles anew.
> Unless, of course, you have something against resetting the logs back
> to zero (I know some people who dont like it).

That should work as well. It's basically the same thing I suggested, via different route - you're forcing Oracle to clear, and create if they don't exist, the online redo logs.

Regards,
Sean Received on Thu Mar 14 2002 - 10:18:07 CST