Re: Poor Backup Strategy???

John Giromini wrote:
>
> Glenn Burton wrote:

stuff about not shutting the database down snipped.

> Glenn,
> The best thing to do is perform a recovery using the current backup
> scheme. I believe you will find it will not work.

Glenn is right, recovery will probably not work, especially if you have users who leave connections on overnight (and thus will be holding locks, uncommitted data, etc.)

When I used to work for Oracle, we called this a "meltdown backup". It's a mix of an impure hot and an impure cold backup scheme, with the hopes that things won't blow up.

Just my $.02.

-- 
*****************************************************************************"The ones who love us best / Are the ones we'll lay to rest / And visit their 
graves on holidays at best.
 The ones who love us least / Are the ones we'll die to please / 
 And if it's any consolation / I don't begin to understand." -- The 
Replacements

Robert Lippmann
Intelligent Interactions
201 N. Union Street, Suite 110
Alexandria VA, 22314
(703) 706-9500