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 >> >> >> >