RE: Backups failing
From: Oliver <ofabelo_at_gmail.com>
Date: Tue, 30 Aug 2011 18:15:31 +0100
Message-ID: <CALQkqm9McqAuN2H20baeUOnLPHSpJA_qasUJz65i++NsdUcK4Q_at_mail.gmail.com>
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_at_gmail.com> 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_at_icat.com> escribió:
>> 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.
Date: Tue, 30 Aug 2011 18:15:31 +0100
Message-ID: <CALQkqm9McqAuN2H20baeUOnLPHSpJA_qasUJz65i++NsdUcK4Q_at_mail.gmail.com>
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_at_gmail.com> 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_at_icat.com> escribió:
>> 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 30 2011 - 12:15:31 CDT