RE: RMAN Restore Archivelog Files -- Very Slow

From: <rama.ari_at_accenture.com>
Date: Sun, 15 Feb 2009 23:49:39 -0500
Message-ID: <ED8E9B3F84B33441B49A70715CCA55EBA8541D49F6_at_AMRXM3111.dir.svc.accenture.com>

Jared

We have tried your suggestions plus rest of the team suggestions but there is no luck yet. Symantec is recommending using (database format 'bk_%U_%t') for backups so that it guarantees uniqueness in generated file names with timestamp. Without this, there will be performance degradation as the NetBackup catalog grows. We still have to test it.

Thanks,
Rama

---

From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Thursday, February 05, 2009 12:33 PM To: Ari, Rama
Cc: oracle-l_at_freelists.org
Subject: Re: RMAN Restore Archivelog Files -- Very Slow

You may want to search the Oracle-L archives at freelists.org<http://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_at_accenture.com<mailto:rama.ari_at_accenture.com>> 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.

No virus found in this incoming message. Checked by AVG - www.avg.com
Version: 8.0.233 / Virus Database: 270.10.18/1936 - Release Date: 02/05/09 11:34:00

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Feb 15 2009 - 22:49:39 CST