Re: RMAN full resync of recovery catalog hangs

From: Steve Harville <steve.harville_at_gmail.com>
Date: Wed, 9 Dec 2009 13:21:02 -0500
Message-ID: <4f41b9050912091021m727744f8gc5ff8cfce18c13b6_at_mail.gmail.com>

More Info:
I'm backing up to tape
The target and the repository databases are both 11.1.0.7.0 I have crosschecked and deleted several times, only a few days of backups are in the control file.

Steve Harville

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

On Wed, Dec 9, 2009 at 11:39 AM, Steve Harville <steve.harville_at_gmail.com>wrote:

> 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 - 12:21:02 CST