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

From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Wed, 10 Aug 2011 13:23:14 -0400
Message-ID: <CADmQEr768RkLn7gHnrijwQmhZ5kqZf1O9vpDeu93L-gy=8P1SA_at_mail.gmail.com>

I checked other sites(metalink inclusive) for steps in creating logical standby and they all list log_archive_dest_1, log_archive_dest_2 and log_archive_dest_3 specified. Do i need to have all three mandatory and is the cause of my problem? Please advice. Could anyone please post their logical standby log_archive_dest_* parameter settings for primary and logical standby configuration.Thanks.

On Tue, Aug 9, 2011 at 2:48 PM, sundar mahadevan < sundarmahadevan82_at_gmail.com> wrote:

> 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 Wed Aug 10 2011 - 12:23:14 CDT