Re: Database backups

On Thu, 21 Mar 2002 14:41:23 -0500, "Dale DeRemer" <dderemer_at_agmc.org> wrote:

>We are new the the Oracle world. We want our ebusiness server to be =
>7x24. Never, ever down. Meaning... no cold backups. So, our question is =
>this: If we use hot backups, (RMAN), and never take a cold backup, will =
>we be able to recover from any failure. Additionally, what is the =
>impact, or difference in recovery time for a system with no cold =
>backups, vs. one with a cold backup done once a week, or once a =
>month?The DB is 75GB and will grow to about 100GB over the next year. It =
>will be updated in batches from our mainframe. Users will not update it. =
>Thanks for your help.=20

Never, ever down. Two remarks:
- that means probably unless your firm goes bankrupt? - it also means you accounted for an UPS and/or a standby database and/or a parallel server environment?
If you don't take these measures, you can make 'no cold backup' whatever you want, but you will definitely experience downtime.

you should be capable to recover from any hot backup. Your description of 'one cold backup per week' is too vague. If that means 'one cold backup per week' instead of 'a hot backup every night', obviously it will take much much longer to recover the database.
As you don't provide any information about the volume of changes, it is impossible to make any estimate on the duration of the recovery.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 21 2002 - 13:59:50 CST