Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strategy question for 24X7, how to do cold backups?
Hemant K Chitale wrote:
>
> Andrew,
>
> Rather than backing up the archive logs from the
> log identified in Step 5 onwards, I would backup
> ALL archive logs generated since the last Hot Backup.
> Ideally, backup your archive logs to a different tape
> (that is, database hotbackup on one tape and
> archive logs and control file on another).
>
> If you need to recover from my latest Hot Backup but find
> that the tape is unreadable/bad you could go back to the
> previous Hot Backup and roll-forward if the tape containing
> archive logs is good.
This is true and the proper practice. Usually we can go back at least three backups. I did not mention that part because it I do not consider it part of the hot backups itself.
-- Andrew Allen Livonia, MI E- Mailto:ajalle_at_ameritech.netReceived on Sun Sep 30 2001 - 18:53:51 CDT