Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strategy question for 24X7, how to do cold backups?

Re: Strategy question for 24X7, how to do cold backups?

From: Andrew Allen <ajallen_at_mailhost.det.ameritech.net>
Date: Sun, 30 Sep 2001 23:53:51 GMT
Message-ID: <3BB7B0A9.5B219F9A@mailhost.det.ameritech.net>


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.net
Received on Sun Sep 30 2001 - 18:53:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US