Re: question on archived logs

With hot or or online backups, if you have to recover then you will need the redo log information
from the time that the tablespace was put into backup mode until the tablespace was taken
out of backup mode.

The initial switch just makes it clearer what redo information was generated before the first
tablespace backup.

The archive log all moves the pre-hot backup redo information to the arch_dest location usually
to be sent off to tape.

The important step is to get the redo log information that is generated during the hot backup
archived off and then backed up to tape. The file backups taken during the hot backup are
useless without the redo log information generated during the hot backup.

Perform a log switch and archive log all after the tablespace backups, and then sent those
archived log files off to tape.

Hope this helps,

Phil Cook
Pavel006 wrote in message <20000308094814.01559.00001091_at_ng-cb1.aol.com>...
>I have a backup script that does online
>backup and backs up archived logs
>
>Before doing a backup on archived logs,
>the script does
>
>step 1. "alter system switch logfile"
> to flush current online logfile.
>
>step 2. "alter system archive log all"
> to archive logfiles that are full
> but not yet archived.
>
>step 3. Does a backup of archived logfiles
>
>i want to know Is step 2 required in the script?
>
>Thanks in advance
>
>
>
>
>
>
Received on Wed Mar 08 2000 - 00:00:00 CST