Re: System Modes QUIESCE / SUSPEND

From: Joachim Hofmann <speicher_at_freenet.de>
Date: Wed, 01 Feb 2006 16:41:25 +0100
Message-ID: <44c35hF1dhufU1@individual.net>

Mladen Gogala wrote:
> With the suspend command, you don't
> need begi/end backup. You do the following:
> alter system checkpoint;
> (wait until the checkpoint is done)
> alter system suspend;
>
> split 'em!
>
> Alter system resume.
>
>

But the manual (Ora 9i DBA Guide 4.17) says:

"do not use the alter system suspent st. as a substitute for placing a tablespace in hot backup mode..."

I am afraid my initial question has not been answered, or maybe I did not express it well.

What I wanted to know: For which database tasks do I use ALTER SYSTEM SUSPEND / ALTER SYSTEM RESUME and for which tasks do I use ALTER SYSTEM QUIESCE RESTRICTED /ALTER SYSTEM UNQUIESCE
?

Joachim Received on Wed Feb 01 2006 - 09:41:25 CST