RMAN Restore Archivelog Files -- Very Slow
- From: <rama.ari@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Feb 2009 00:42:30 -0500
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.
Other related posts:
