RE: Backups failing

  • From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
  • To: Sreejith Nair <sreejithsna@xxxxxxxxx>, "ofabelo@xxxxxxxxx" <ofabelo@xxxxxxxxx>
  • Date: Tue, 30 Aug 2011 16:55:06 +0000

I agree with Sreejith but would suggest the quiesce state is a little more 
restrictive than just not accepting new connections.  From here:

Is this:
Occasionally you might want to put a database in a state that allows only DBA 
transactions, queries, fetches, or PL/SQL statements. Such a state is referred 
to as a quiesced state, in the sense that no ongoing non-DBA transactions, 
queries, fetches, or PL/SQL statements are running in the system.

But if your emca process is hanging with both drop and recreate, then that may 
not be the issue.


-----Original Message-----
From: Sreejith Nair [mailto:sreejithsna@xxxxxxxxx]
Sent: Tuesday, August 30, 2011 10:42 AM
To: ofabelo@xxxxxxxxx
Cc: Sweetser, Joe; Oracle L
Subject: Re: Backups failing

Quiesce mode means no new connections will be accepted. This is when you use 
emca for dropping. With 11.2 database will not come in quiesce mode when 
dropping em repository and objects.

However, I am not sure whether dropping em 'manually' will put database in 
quiesce mode for 10g.
I have done this ( manual drop ) in 11.2 and database does not go in quiesce 
mode. In my case also. Dropping using emca and Repmanager did hang, which is 
why I went for manual drop.

~Sent from my samsung phone

------- Original message -------
> From: Oliver <ofabelo@xxxxxxxxx>
> To: sreejithsna@xxxxxxxxx
> Cc: JSweetser@xxxxxxxx, oracle-l@xxxxxxxxxxxxx
> Sent: 30/8/'11,  21:36
> What is quiesce mode?
> Can someone paste me the content of that note? thanks.
> I've executed recreate but it hangs too,so I've executed drop first (although 
> it hangs too).
> Thanks beforehand.
> El 30/08/2011 16:18, "Sreejith Nair" <sreejithsna@xxxxxxxxx> escribió:

Confidentiality Note: This message contains information that may be 
confidential and/or privileged. If you are not the intended recipient, you 
should not use, copy, disclose, distribute or take any action based on this 
message. If you have received this message in error, please advise the sender 
immediately by reply email and delete this message. Although ICAT Managers, 
LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for 
viruses, it does not guarantee that either are virus-free and accepts no 
liability for any damage sustained as a result of viruses. Thank you.

Other related posts: