When delete stmts are issued on primary, resync/recovery process on standby side is very slow. Logs are shipped fine and fast , but recovery process is slow. Is there some configuration needs to be updated?
Normall all other dmls are fast in the resync process.
Primary : RAC
Standby: Phy. standby on standalone
vsysdate date := sysdate ;
cursor lgsarcchk is
select thread#,sequence#,first_time,name,applied from V$ARCHIVED_LOG
where trunc(first_time) >= trunc(sysdate-3)
order BY first_time ;
for lgsarc in lgsarcchk
if lgsarc.applied = 'YES' then
dbms_output.put_line('Thread#'||lgsarc.thread#||' sequence# '|| rpad(lgsarc.sequence#,45)||' Status => '||lgsarc.applied||' applied at '||lgsarc.first_time);
im using above cmd to check and also alert log of standby prints when it applies.
Alert log msg:
Media Recovery Log /MOUNTPOINT/DBNAME/ARCHIVELOGNUMBER.arc
That helps some. I'm still unclear where, which server, Primary or Standby that you run that PL/SQL from.
This is worth a look:
>'||lgsarc.applied||' applied at '||lgsarc.first_time
FIRST_TIME in V$ARCHIVED_LOG is not the Apply Time. Your query does not show the apply time but the timestamp of the first change in that archivelog. An archivelog may contain 1minute of changes of 12hours of changes -- the "gap" you would perceive may be 1minute or 12hours !
Hemant K Chitale