Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RMAN hangs after 10.2 upgrade

RMAN hangs after 10.2 upgrade

From: Rich Holland [oramail] <oramail_at_guidancetech.com>
Date: Fri, 2 Mar 2007 10:15:37 -0500
Message-ID: <00f001c75cdd$a21743f0$5da80d46@CABLOE21441>


We recently upgraded a dozen or so databases from 9.2.0.(6|7) to 10.2.0.2 + patch 10 on Win32. Now when we execute a 'connect target' in RMAN, it runs very slow - a 'show all' command takes a couple minutes to complete. 'exit' takes ~5 minutes. We're not using a recovery catalog, and our control files are around 15M. If we don't connect to the database, RMAN starts & stops very fast, as expected - it just seems to be trodding through molasses whenever it's connected to the database.  

Here's a 'show all' in one of the systems:  

using target database control file instead of recovery catalog

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 21 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'\\backupserver\orab

kup\DEV\dev_ctrl_%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'E:\ORACLE\DEV\102\DATABASE\SNCFBWP.ORA';
 # default  

Has anyone else seen similar problems with 10.2? We poked around in metalink but didn't see anything..  

Thanks!
Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 02 2007 - 09:15:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US