Re: Ques: backup redo-log files to tape.

A hot backup is in-consistent.

This means that -- at a minimum -- you need all the redo that was generated durring the backup. So the tactic is to do a log switch after the datafiles backup (which gets the latest log archived) and then backup all the archived logs.

But remember, if you crash several days after the backup, you will need all the archive logs since the start of the backup until now as well as the current log file.

Konstantin Kivi wrote:

> Gerard H. Pille <ghp_at_skynet.be> wrote:
> > They are plain files for the OS, so go ahead.
> > --
> > Kind Regards,
>
> If there any sense in backuping them at all
> during hot backup?
>
> It looks like archived logs must be sufficient for recovery.
> One point in storing them may be in that
> we will have complete database ready to start at the
> some point in time. But what about the way that
> files are copied? There is no such thing like
> 'alter redo log begin backup'.
>
> What All think about this?
>
> --
> Sincerely Yours, Konstantin Kivi, Russia, konst_at_sirena.rinet.ru
> aka <k-kivi_at_usa.net>, 2:5020/457.24_at_fidonet.org
>
>
Received on Tue Nov 17 1998 - 07:46:11 CST