logical standby real time apply does not work unless manually switching logfile

From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Tue, 9 Aug 2011 14:48:30 -0400
Message-ID: <CADmQEr5-_GKgAfRLcsgmvRg2zQkLa0+CgzJ47cXQ_zmP3XxHfQ_at_mail.gmail.com>

Hi All,
Good day. I set up a logical standby but real time apply does not work. If i switch the logfile, then the redo log file gets archive and get applied over. I looked at the various sql commands here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ls.htm#CHDGBCGIto see what is wrong but nothing comes up. Appreciate your help.Thanks in advance.

Few responses for the sql statements:

On primary:

14:34:15 sys_at_MFPROD SQL>select current_scn from v$database;

            CURRENT_SCN

---

          5288795814937

Parameter settings:

log_archive_config                   string      dg_config=(MFPROD,MFPRODLS)
log_archive_dest_1                   string      LOCATION=/u01/arch/mfprod
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=MFPROD
log_archive_dest_3                   string      SERVICE=mfprod_logstdby

arch ASYNC VALID_FOR=(ONLINE_LOGFILE, ALL_ROLES) DB_UNIQUE_NAME=MFPRODLS

On Logical standby:

14:32:20 sys_at_MFPRODLS SQL>SELECT DEST_ID, RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS WHERE DEST_ID=3;  DEST_ID RECOVERY_MODE
-------- -----------------------

       3 LOGICAL REAL TIME APPLY 14:47:02 sys_at_MFPRODLS SQL>SELECT REALTIME_APPLY FROM V$LOGSTDBY_STATE;

REALTIME_APPLY

---

Y

Parameter settings:

log_archive_config                   string      dg_config=(MFPROD,MFPRODLS)
log_archive_dest_3                   string

LOCATION=/u01/arch/mfprod_stdby VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=MFPRODLS 14:38:37 sys_at_MFPRODLS SQL>SELECT APPLIED_SCN, LATEST_SCN, MINING_SCN, RESTART_SCN FROM V$LOGSTDBY_PROGRESS;          APPLIED_SCN LATEST_SCN MINING_SCN RESTART_SCN
-------------------- -------------------- --------------------

---

       5288795813413 5288795813413 5288795813414 528879581341

--

http://www.freelists.org/webpage/oracle-l Received on Tue Aug 09 2011 - 13:48:30 CDT