Re: Archive log confusion

kal121_at_my-deja.com wrote:
> <<snipped>>
> I've also read that you only need those archive logs that are older
> than the timestamp of the beginning of your last hot backup. But even
> this doesn't entirely make sense because 31 is the next sequence to be
> archived (the ARCH is slow), so 31 will be older than 12:00:01 by the
> time it is archived, but log 33 is first online redo log being written
> to at the time of the hot backup, not 31. 31 has changes in it that are
> older than the start of the hot backup, so that hot backup doesn't need
> those changes. It only needs changes in 33, right?
>
> Somebody please clarify.

And what if your online backup has a problem and you need to recover from the previous online backup? The best strategy is to backup up all archive logs. If you have the disk space keep enough archive logs on disk to recover forward from the previous TWO backups. That said, your assumption is right and you only need the logs from the one that was current when you started the backup.

Big Al Received on Tue Sep 26 2000 - 20:50:30 CDT