You may want to search the Oracle-L archives at freelists.org for RMAN performance problems. This has appeared fairly frequently of late. One of the posts lists a MetaLink note that is actually a master list pointing to other notes, all relating to RMAN performance problems. BTW, the 'fix' for many RMAN performance problems: SQL 'ALTER SESSION SET OPTIMIZER_MODE=RULE' Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On Wed, Feb 4, 2009 at 9:42 PM, <rama.ari@xxxxxxxxxxxxx> wrote: > Thanks for reading this email & Thanks in Advance for your help. > > > > We are facing performance issue when trying to restore archive log files > using RMAN catalog. > > > > Environment: > > Oracle Database: 10g (10.2.0.3) RAC > > Database Size: ~350 GB > > Archive Log Files per day: ~30 – 45 > > Archive Log File Size: 200MB > > NetBackup: 6.5 > > Backups: RMAN to VTL (Weekly Full, Daily Incremental) > > > > We restored 350 GB of database using RMAN catalog and it took around 6 Hrs > which is very good. Most of the datafile sizes are around 30GB and some of > the files are couple of GB. > > > > When we try to restore archive log (200MB) files using RMAN Catalog and it > is taking approximately 15 Minutes for each file. If we bypass RMAN catalog > by using backup information from controlfile, it takes approximately 2.5 > Minutes to restore each archive log file. After working with backup team, we > found out that approximately 12 Minutes time was spent for the hand shake > between RMAN Catalog and Netbackup catalog. > > > > Did anyone of you have seen similar situation and what might be the > problem? Have you done any kind of database maintenance work for RMAN > repository database to improve performance? > > > > Thanks, > > *Rama* > > > > This message is for the designated recipient only and may contain > privileged, proprietary, or otherwise private information. If you have > received it in error, please notify the sender immediately and delete the > original. Any other use of the email by you is prohibited. >