Re: quick hot backup question...

Glen A Stromquist wrote:
>
> I've had this discussion with you before regarding doing a log switch after
> the datafiles are copied then copying the archive log generated during the
> backup, and in the past went to great pains writing my script to do just
> that. However after I "restored" a database to another location (clone) from
> a set of hotbackup files and applied all the archive logs to it, I realized
> that what I was doing was ok, but not really necessary, like you said.

As Howard noted, there's not really a great reason to switch logs before the backup. However, there may be good reasons to do an archive log current after the backup. One typical reason is if you have an automated cloning operation, you want all the redo generated during the backup to actually be archived so that you can take those logs and recover the clone. Sure, if you waited long enough that redo would get archived on its own, but sometimes you don't want to wait.

Regards,
Sean Received on Mon Mar 25 2002 - 20:24:36 CST