You might be able to increase your recovery parallelism. What is it set
to? On a 6 node rac, you have a lot of data that all has to be applied
from a single node, which of course creates a noticeable choke point.
On Tue, Aug 30, 2016 at 2:47 PM, Andy Klock <andy@xxxxxxxxxxxxxxx> wrote:
Whoops! I hate it when people don't include that info. This is a newly
upgraded 12.1.0.2 Apr PSU six node RAC, running SuSE 11 on HPE Superdome X,
with a 3.5 TB SGA. Should have mentioned ADG:
SQL> select protection_mode, protection_level,open_mode from v$database;
PROTECTION_MODE PROTECTION_LEVEL OPEN_MODE
-------------------- -------------------- --------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE READ ONLY WITH APPLY
Not sure if this just an MRP (serialization) bottleneck issue or if there
actually is something I can do to make it go faster.
Thanks Andrew
On Tue, Aug 30, 2016 at 2:52 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>
wrote:
Are you in maximum availability mode?
Oracle Version and OS?
On Tue, Aug 30, 2016 at 12:49 PM, Andy Klock <andy@xxxxxxxxxxxxxxx>
wrote:
Hi Listers,
Hoping you can offer some comparisons for me in regards to Data Guard
APPLY throughput. We've got some beefy servers HP Superdomes on top rate
EMC storage. We generate up to 8TB of REDO a day. We don't experience
Transport Lags, but do have periods when our Apply Rate (100~MB/Sec) just
isn't enough to keep up with our REDO generation. I've reviewed DOC:
Data Guard Physical Standby - Monitoring Redo Generation and Managed
Recovery Performance
<https://support.oracle.com/epmos/faces/KMConsolidatedSearch?_adf.ctrl-state=mh20572at_215&_afrLoop=306597344292033#>(Doc
ID 1552335.1)
But, would like to get some real world metrics from those of you pushing
DG. What are your average Apply Rates?
SQL> select type,item,sofar,sysdate time from v$recovery_progress where
total=0;
TYPE ITEM SOFAR TIME
------------------------------ -------------------- ----------
-----------------
Media Recovery Average Apply Rate 76301 20160830
12:47:56
Media Recovery Redo Applied 1165240 20160830
12:47:56
Media Recovery Last Applied Redo 0 20160830
12:47:56
Media Recovery Elapsed Time 15638 20160830
12:47:56
Media Recovery Standby Apply Lag 3 20160830
12:47:56
Thanks!
Andy K
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'