Database Software

Hi all,

I have configured a data guard between the primary database srv01 and a standby physical database srv02.
To verify the redo log tranmission services, I have issued the following statements:

SQL> conn sys/s@srv01 as sysdba
Connected.

SQL> SELECT THREAD#, SEQUENCE#, ARCHIVED, STATUS FROM V$LOG;

   THREAD#  SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
         1         55 YES INACTIVE
         1         56 NO  CURRENT
         1         54 YES INACTIVE

SQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;

MAX(SEQUENCE#)    THREAD#
-------------- ----------
            55          1

SQL> SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ#
  2  FROM V$ARCHIVE_DEST_STATUS
  3  WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';

DESTINATION
-------------------------------------------------------------------------
STATUS    ARCHIVED_THREAD# ARCHIVED_SEQ#
--------- ---------------- -------------
E:\oracle\oradata\ora10g\arc
VALID                    1            55

ora10g2
VALID                    1            55


SQL> SELECT LOCAL.THREAD#, LOCAL.SEQUENCE# FROM
  2   (SELECT THREAD#, SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=1)
  3   LOCAL WHERE
  4   LOCAL.SEQUENCE# NOT IN
  5   (SELECT SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND
  6   THREAD# = LOCAL.THREAD#);

   THREAD#  SEQUENCE#
---------- ----------
         1         42

My question is: based on the output of the last SELECT, does it mean the log sequence number 42 was not sent to the standby database?

Oracle 10g Enterprise Edition Release 10.2.0.4.0
Windows 2003 Server