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

You could do that ( recover backup from day #1 and roll forward all logs since then ), however if on day #583 one of your disks fail, causing you to loose a datafile, you *could* just simply restore all or a portion of day #582's HOT backup and only roll forward the logs generated since then ( yesterday ).

Hot backups allow you to stay online while executing a backup. You do NOT need a Cold backup to recover a database. This does assume that your online redo is sufficiently protected from single points of failure though.

24/7 is very difficult to achieve when you consider how frequently patches and new-releases of the RDBMS code become available and/or are required for whatever reason. Instead of worrying about how to implement the backup and recovery so much, you should consider how you will upgrade or patch Oracle software, your OS and your application software while remaining online and available 24/7.

-Kevin

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:u66a5sy4q.fsf_at_verizon.net...
> On Wed, 26 Sep 2001, paled_at_home.com wrote:
>
> > If you do not have a cold backup prior to putting the database
> > into production, you have committed a grave error. I suggest
> > that you grab a the backup and recovery handbook (Velpuri) and
> > the Oracle docs - Backup and recovery guide for your version -
> > and do some heavy reading. The DBA checklists book (O'Reilly)
> > has some good material on this subject.
>
> I am not putting anything into production. I've just never quite
> understood the best strategy for this. As I read things, and
> they don't make sense, I try to read more. At some point, I come
> to the newsgroup for their take on it. That's what I'm doing
> here. No emergency, just Oracle conversation.
>
> > If you can afford the downtime window, I would:
>
> Well, this was the jist of my post. How does one not have to
> recover from the day #1 backup and all of the redo logs from day
> #1 if you are truly 24x7?
>
> --
> Galen Boyer
> Everyone in town, now, they probably all agree,
> I'm _lying_ in the bed I made.
Received on Wed Sep 26 2001 - 09:22:20 CDT