Re: Applying Archive Logs for STANDBY Database

  • From: Riyaj Shamsudeen <rshamsud@xxxxxxxxxxxx>
  • To: bnsarma@xxxxxxxxx
  • Date: Thu, 27 Apr 2006 15:56:42 -0500

I have seen *some* improvement in using parallel clause. Sorry, I didn't measure the performance improvement though.

alter database recover managed standby database parallel 16;

As I remember, one process reads the log file, but the application of those change vectors were performed by slaves.. Depending upon your bottleneck, this may or may not help you though.

BN wrote:
Greetings
2 CPU HP-UX 11.11 Oracle 9.2.0.7 <http://9.2.0.7> STANDBY Database
Applying 450 Archive Logs of 20 MB each took 2.30 hrs,
Is there a way to tune this to cut this time?

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2006