Skip to main content

Posts

Showing posts from June, 2017

Why Oracle DataGuard real time apply has apply lag?

Here is the case: On standby database: Check the apply lag: SQL>         select name,value from v$dataguard_stats where name in ('transport lag','apply lag') and (value > '+00 01' or value is null); NAME                 VALUE                                                                           -------------------- --------------------                                                           apply lag            +00 08:19:40                                                                    SQL> SELECT INST_ID,  DEST_ID,  DEST_NAME,  STATUS,  TYPE,  SRL,  RECOVERY_MODE FROM  gV$ARCHIVE_DEST_STATUS WHERE  DEST_ID=1;    INST_ID    DEST_ID DEST_NAME                            STATUS    TYPE           SRL RECOVERY_MODE ---------- ---------- ------------------------------------ --------- -------------- --- -----------------------          2          1 LOG_ARCHIVE_DEST_1                   VALID     LOCAL          NO  MANAGED REAL TIME A