Re: Is this method of offline backup OK?

Murali wrote:
>
> 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).

Oh, and one reason some people probably don't like the resetlogs route (and the reason I suggested the clear logfile option) is that, in an archivelog database, a resetlogs forces you to have to take a backup immediately after the resetlogs operation. For a large database, that could be a unnecessary recovery delay.

Regards,
Sean Received on Thu Mar 14 2002 - 10:21:59 CST