9 Replies Latest reply: Dec 2, 2013 12:52 PM by TSharma-Oracle RSS

    Logical Standby Dataguard is not working properly

    user10674190

      Primary database is not synchronized with Logical Standby. When I make a query on v$logstdby_progress "Mining Time" column is NULL:

       

      SQL> SELECT APPLIED_TIME, APPLIED_SCN, MINING_TIME, MINING_SCN

        2  FROM V$LOGSTDBY_PROGRESS;

       

      APPLIED_TIME APPLIED_SCN MINING_TIME MINING_SCN

      ------------ ----------- ----------- ----------

      01/12/2013 2 83572690658         

       

       

      Also, when I look on v$logstdby_process colunm STATUS, I see ORA-16240 error:

       

      SQL> select SID, SPID, HIGH_SCN, TYPE, STATUS from v$logstdby_process; 

       

             SID SPID                       HIGH_SCN TYPE                           STATUS

      ---------- ------------------------ ---------- ------------------------------ --------------------------------------------------------------------------------

             866 19277                               COORDINATOR                    ORA-16240: Waiting for log file (thread# 1, sequence# 0)

       

       

       

      Please, could anybody help me? Thanks in advance. Leonardo.