RE: RMAN Restore Archivelog Files -- Very Slow

From: John Hallas <>
Date: Thu, 5 Feb 2009 14:37:57 +0000
Message-ID: <>

How long does it take to do a backup spfile command to disk? We had problems recently on a couple of servers where the RMAN backup was never finishing and indeed was timing out. Tracing just showed a controlfile enqueue (IIRC). However the issue was corrected by identifying a couple of rogue processes which were consuming excessive cpu.

The simple test for us was rman target / followed by backup spfile;

HTH John

From: [] On Behalf Of Sent: 05 February 2009 05:43
Subject: RMAN Restore Archivelog Files -- Very Slow

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.

Oracle Database: 10g ( 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?


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.

Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.

If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.

Wm Morrison Supermarkets PLC accepts no liability or responsibility for anything said in the email or its attachments and gives no warranty as to accuracy. It is the policy of Wm Morrison Supermarkets PLC not to enter into any contractual or other obligations by email.

Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.

Received on Thu Feb 05 2009 - 08:37:57 CST

Original text of this message