2 Replies Latest reply: Aug 20, 2009 4:41 AM by 629264 RSS

    Dataguard:How to check the timestamp of archivelog generation?

    629264
      Hi ,

      I want to test my DR database.

      Is there any dictionary view provided the three below information.

      1.When archivelog created in primary?
      2.When archivelog created in standby server?(Network latency)
      3.When logs applied in DR database?

      Thanks & Regards,
      Vinoth
        • 1. Re: Dataguard:How to check the timestamp of archivelog generation?
          704810
          Hi

          Use the below queries

          On the standby database, queries the V$ARCHIVED_LOG view to verify the redo data was received and archived on the standby database:

          SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
          SEQUENCE# FIRST_TIME NEXT_TIME
          ---------- ------------------ ------------------
          8 11-JUL-02 17:50:45 11-JUL-02 17:50:53
          9 11-JUL-02 17:50:53 11-JUL-02 17:50:58
          10 11-JUL-02 17:50:58 11-JUL-02 17:51:03
          11 11-JUL-02 17:51:03 11-JUL-02 18:34:11
          4rows selected.

          1)Verify new archived redo log files were applied.

          On the standby database, query the V$ARCHIVED_LOG view to verify the archived redo log files were applied.

          SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

          SEQUENCE# APP
          --------- ---
          8 YES
          9 YES
          10 YES
          11 YES
          4 rows selected.
          • 2. Re: Dataguard:How to check the timestamp of archivelog generation?
            629264
            Hi Ravi,

            Thanks.I know that these logs are applying in the DR.

            I want to check the latency between two sites.


            211 20:AUG:2009 05:08:53 20:AUG:2009 05:08:31

            What is First_time & next time?