Capture reading is delayed by 30 minutes, the status is "waiting" when reading online redo logs. This occurs on dates when there is no Daylight Saving change.
sp_ctrl> show capture deail
It is related to daylight saving time logic (DST) we put into redolog ensure parameter
Workaround : Disable the time check.
1. For shareplex versions below than 7.5.2.34:
sp_ctrl> stop capture
sp_ctrl> set param SP_OCT_REDOLOG_ENSURE 0
sp_ctrl> start capture
NOTE: There is a chance that capture can read ahead of oracle thus reading incomplete blocks. To avoid this risk please upgrade to 7.5.2.34 or higher and use parameter set param SP_OCT_USE_DST 0 (see item 2 below).
2. For shareplex version 7.5.2.34 and up:
sp_ctrl> stop capture
sp_ctrl> set param SP_OCT_USE_DST 0
sp_ctrl> start capture
Status : Will be fixed in later versions
Important:
If you have set SP_OCT_USE_DST to 0, you must set this parameter back to 1 on the day of Daylight Savings Change. Otherwise capture may have 1 hour delay during the 1 hour window when Daylight Saving changes. You can change it back to 0 afterwards.
If you do not use SP_OCT_USE_DST parameter, then you do not need to make any change on the day of Daylight Savings Change.
Check the time of both OS & ORACLE.
sqlplus / as sysdba
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
SQL> SELECT SYSDATE,CURRENT_DATE FROM DUAL;
2.$date
$echo $TZ
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center