RE: RMAN Restore Archivelog Files -- Very Slow
- From: <rama.ari@xxxxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>
- Date: Sun, 15 Feb 2009 23:49:39 -0500
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@xxxxxxxxx]
Sent: Thursday, February 05, 2009 12:33 PM
To: Ari, Rama
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN Restore Archivelog Files -- Very Slow
You may want to search the Oracle-L archives at
freelists.org<//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<mailto: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.
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.
Other related posts:
