Re: RMAN full resync of recovery catalog hangs

From: Steve Harville <steve.harville_at_gmail.com>
Date: Wed, 9 Dec 2009 11:39:07 -0500
Message-ID: <4f41b9050912090839q65ce2b9clfe2e4183caeddf8e_at_mail.gmail.com>

I had done crosscheck and delete several times but I did it again today. I had the same result of resync catalog hanging. I verified that the seq# was the same the entire time while it was waiting on SQL Net message from client.

Here's the commands I used:

RMAN>crosscheck archivelog all;
RMAN>delete noprompt force expired archivelog all;

RMAN>crosscheck backup;
RMAN>delete noprompt force expired backup;

RMAN>crosscheck copy;
RMAN>delete noprompt force expired copy;

Steve Harville

http://www.linkedin.com/in/steveharville

On Wed, Dec 9, 2009 at 2:57 AM, Howard Latham <howard.latham_at_gmail.com>wrote:

> I had a similar problem after several attempts at crosscheck and delete
> expired it all started working again.
>
> 2009/12/9 Martin Berger <martin.a.berger_at_gmail.com>
>
> Steve,
>>
>> just to make sure: is the seq# the same all the time for the session with
>> " waiting for SQL*Net" event?
>>
>> Martin
>>
>>
>> On Tue, Dec 8, 2009 at 15:22, Steve Harville <steve.harville_at_gmail.com>wrote:
>>
>>> RMAN full resync of recovery catalog hangs
>>>
>>> When I check in the catalog database the session is waiting for SQL*Net
>>> message from client.
>>> ....
>>>
>>
>>
>>
>
>
>
> --
> Howard A. Latham
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 09 2009 - 10:39:07 CST