RE: Backups failing

  • From: Oliver <ofabelo@xxxxxxxxx>
  • To: "Sweetser, Joe" <JSweetser@xxxxxxxx>
  • Date: Tue, 30 Aug 2011 18:15:31 +0100

A colleague has done a new connection with a user non-dba and it works so I
understand that drop command hangs and it didn't enter in quiesce
mode,correct? Thanks
El 30/08/2011 18:09, "Oliver" <ofabelo@xxxxxxxxx> escribió:
> Thanks to all. It hangs,so it didn't enter in quiesce mode.
> Can someone paste me the manual steps for dropping EM manually? thanks
> beforehand.
> El 30/08/2011 17:55, "Sweetser, Joe" <JSweetser@xxxxxxxx> escribió:
>> I agree with Sreejith but would suggest the quiesce state is a little
> 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
> 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
> dropping em repository and objects.
>> However, I am not sure whether dropping em 'manually' will put database
> 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
> 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
> 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: