RE: Applying Archive Logs for STANDBY Database

Here are some ideas:  

1. Try a variety of degrees of parallel recovery (recovery_parallelism parameter)
2. Tune standby by examining wait events and addressing highest waits (if addressable)
3. Check for buffer cache efficiency and if necessary, increase size on standby
4. Determine top redo generating jobs and sessions on primary (using v$sesstat/redo size) and determine if they can be reduced or eliminated.

Jeremiah Wilton

ORA-600 Consulting

http://www.ora-600.net  

From: BN  

2 CPU HP-UX 11.11 Oracle 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?

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