RE: Backups failing

From: Uzzell, Stephan <SUzzell_at_MICROS.COM>
Date: Tue, 30 Aug 2011 17:06:13 +0000
Message-ID: <DF78EADE484D37419A53F5C898629DB7E5A496_at_USMAIL2K1001.us.micros.int>

But IIRC, quiesce does not complete while there are other active connections. So you end up with a state where no users can connect until the quiesce is done, the quiesce cannot complete until all users are gone and you end up having to kill users or bounce the DB...

Stephan Uzzell

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sweetser, Joe Sent: Tuesday, 30 August, 2011 12:55
To: Sreejith Nair; ofabelo_at_gmail.com Cc: Oracle L
Subject: RE: Backups failing

I agree with Sreejith but would suggest the quiesce state is a little more restrictive than just not accepting new connections. From here: http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/start004.htm

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.

-joe

-----Original Message-----
From: Sreejith Nair [mailto:sreejithsna_at_gmail.com] Sent: Tuesday, August 30, 2011 10:42 AM To: ofabelo_at_gmail.com
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.

Sreejith
~Sent from my samsung phone

• Original message -------
  > From: Oliver <ofabelo_at_gmail.com>
  > To: sreejithsna_at_gmail.com
  > Cc: JSweetser_at_icat.com, oracle-l_at_freelists.org
  > 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_at_gmail.com> 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. m����
�祊�l��?���j ����� †Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Aug 30 2011 - 12:06:13 CDT