Re: RMAN full resync of recovery catalog hangs
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: pegramrg@xxxxxxxxx, steve.harville@xxxxxxxxx, Howard Latham <howard.latham@xxxxxxxxx>
- Date: Wed, 9 Dec 2009 13:50:32 -0800 (PST)
A number of catalog related bugs.... in 10g and 11g.
A whole bunch.
Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
Check out my new blog series on installing Oracle Database 11gR2 on Windows
using VMWare!
________________________________
From: Robert Pegram <pegramrg@xxxxxxxxx>
To: steve.harville@xxxxxxxxx; Howard Latham <howard.latham@xxxxxxxxx>
Cc: martin.a.berger@xxxxxxxxx; oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, December 9, 2009 1:36:23 PM
Subject: Re: RMAN full resync of recovery catalog hangs
Steve,
Did you recently run "upgrade catalog"? If so, the first time we upgraded our
catalog to support 11G databases, we had a couple of target databases
experiencing similar behavior. Below is my notes from where I resolved the
problem. Apparently I didn't take good notes, but I seem to remember seeing
"control file sequential read" events showing up in the targets database's
v$session_wait view.
=======
Symptom: RMAN full resync of recovery catalog takes extra long time.
FIX:
On Target Database:
SQL> exec dbms_stats.gather_fixed_objects_stats() ;
SQL> alter system flush shared_pool;
RMAN> sql "alter session set optimizer_mode=RULE";
RMAN> resync catalog
=======
HTH
Rob Pegram
Duke University
________________________________
From: Steve Harville <steve.harville@xxxxxxxxx>
To: Howard Latham <howard.latham@xxxxxxxxx>
Cc: martin.a.berger@xxxxxxxxx; oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, December 9, 2009 1:21:02 PM
Subject: Re: RMAN full resync of recovery catalog hangs
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@xxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxx>
>>
>>
>>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@xxxxxxxxx>
>>>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
>>
>>
>>
>
Other related posts:
