RE: Applying Archive Logs for STANDBY Database
- From: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
- To: <bnsarma@xxxxxxxxx>, "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 Apr 2006 14:09:28 -0700
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?
Other related posts:
