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:
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@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.
Sreejith
~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:
