Re: Need a reality check!

        You shouldn't without good reason. The only potential problem is that

while in backup mode the redo log entries (and the archives they become)  

are larger. If you are tight for disk space ...

        I recently replaced a hot backup that put all tablespaces in backup mode, did the backup, and then put them back in normal mode. It had bee n
running for six months with no problems.

        Although it "weren't broke" I replaced it because it was a static procedure requiring script editing whenever a tablespace or datafile was  

added or deleted. (With over 20 database instances and only two DBAs I

wanted to create a dynamic hot backup process able to adjust to a changing environment without human intervention.)   

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 9/25/00, 7:10:01 PM, kal121_at_my-deja.com wrote regarding Need a realit y
check!:

> What do you think of the practice of putting ALL OF YOUR TABLESPACES i
 n
> hot backup mode simultaneously? Is this a good idea or bad idea and wh
y?

> (Of course I would never do this myself, but what do you all think of
> it?)
 

> Thank you

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Sep 25 2000 - 22:39:53 CDT