6 Replies Latest reply: Apr 5, 2014 2:15 AM by Renu-Oracle RSS

    no data reply after restarted physical standby database

    592815

      Brian and friends

      I do not  see data replication after restart physical database that host down 3 days in other city..The primary and standby DB role does not be changed.

      In  dataguard11.2 (primary and physical standby DB), We startup database and restarted apply server

      alter database recover managed standby database cancel;

      alter database recover managed standby database using current logfile disconnect;

      The physical DB is READ ONLY WITH APPLY mode pe sql  in SELECT open_mode FROM V$DATABASE;

      But i did not see data replication processing.

      We  take below reviewing in physical standby DB.

      1)

      select *FROM V$ARCHIVE_GAP;

      no any valu return

      2)

      SELECT name, value, datum_time, time_computed FROM V$DATAGUARD_STATS  WHERE name like 'apply lag';

      shoNAME VALUE DATUM_TIME TIME_COMPUTED

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

      apply lag               03/25/2014 08:54:17

       

       

      3) history lag value

      SELECT * FROM V$STANDBY_EVENT_HISTOGRAM WHERE NAME = 'apply lag' AND COUNT > 0;

      no value

      4) SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;

       

       

      PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS

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

      ARCH      CLOSING               1      25897     120832       1301

      ARCH      CLOSING               1      25898     100352        710

      ARCH      CONNECTED          0          0          0          0

      ARCH      CLOSING               1      25896     350208       1353

      RFSRFS    IDLE                     0          0          0          0

      MRP0      WAIT_FOR_GAP    1          1          0          0

      RFSRFS    IDLE                     0          0          0          0

       

      7 rows selected.

       

      ALso

      SQL> SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ# -

      FROM V$ARCHIVE_DEST_STATUS -

      WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';

       

      no DESTINATION value but status is valid. have archived _sql#

       

      Under this situation, what do we need to do?

      Thanks

       

      new dba

        • 1. Re: no data reply after restarted physical standby database
          592815

          select *from V$DATAGUARD_STATS;

           

          NAME                VALUE    UNIT                          TIME_COMPUTED          DATUM_TIME                                                                                                                                                                                                                                                                                                                                                                                                                                                        

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

          transport lag                  day(2) to second(0) interval  03/25/2014 14:15:49                                                                                                                                                                                                                                                                                                                                                                                                                                                                              

          apply lag                      day(2) to second(0) interval  03/25/2014 14:15:49                                                                                                                                                                                                                                                                                                                                                                                                                                                                              

          apply finish time              day(2) to second(3) interval  03/25/2014 14:15:49                                                                                                                                                                                                                                                                                                                                                                                                                                                                              

          estimated startup time 11      second                        03/25/2014 14:15:49                                                                                                                                                                                                                                                                                                                                                                                                                                                                              

          • 2. Re: no data reply after restarted physical standby database
            oscrub
            PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS
            --------- ------------ ---------- ---------- ---------- ----------
            ...
            MRP0      WAIT_FOR_GAP    1          1          0          0
            

             

            The standby database is waiting for the archivelog with sequence 1? What happened on the primary database? Was it just restarted, or was there recovery done and and opened with resetlogs? Are there any error messages within the alert log, or you can also try querying V$DATAGUARD_STATUS with the query: select message from v$dataguard_status order by timestamp;

            • 3. Re: no data reply after restarted physical standby database
              ASulthan

              hi,

              Can you post alert log primary and physical database?

              • 4. Re: no data reply after restarted physical standby database
                Anar Godjaev

                HI,

                 

                Can you Please send me Primary and Secondary location alert log.

                 

                tail -50f alert_DBname. log

                 

                Thank you

                • 5. Re: no data reply after restarted physical standby database
                  Anar Godjaev

                  And past result in Secondary location:

                   

                  select name, value from v$dataguard_Stats;

                   

                  Thank you

                  • 6. Re: no data reply after restarted physical standby database
                    Renu-Oracle

                    Hi,

                     

                    Provide below:

                     

                     

                     

                    Primary: SQL> select thread#, max(sequence#) "Last Primary Seq Generated"

                    from v$archived_log val, v$database vdb

                    where val.resetlogs_change# = vdb.resetlogs_change#

                    group by thread# order by 1;

                     

                     

                     

                    PhyStdby:SQL> select thread#, max(sequence#) "Last Standby Seq Received"

                    from v$archived_log val, v$database vdb

                    where val.resetlogs_change# = vdb.resetlogs_change#

                    group by thread# order by 1;

                     

                     

                     

                    PhyStdby:SQL>select thread#, max(sequence#) "Last Standby Seq Applied"

                    from v$archived_log val, v$database vdb

                    where val.resetlogs_change# = vdb.resetlogs_change#

                    and val.applied='YES'

                    group by thread# order by 1;

                     

                    Thanks,