Re: logical standby real time apply does not work unless manually switching logfile
Date: Thu, 11 Aug 2011 09:41:03 +0200
Message-ID: <4E43878F.5030605_at_nordea.com>
If I well understand You, You need to set your log_archive_dest_3 to 'lgwr' - as long as You have it with 'arch', the whole communication to standby goes with archivelogs, so the behaviour is consistent. Of course as others suggested one needs standby logs.
Regards
Remigiusz
W dniu 09.08.2011 20:48, sundar mahadevan pisze:
> 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#CHDGBCGI
> to 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
-- Pole nakazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com> pos : DBA at DIiUSI addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland phone : +48 58 667 17 43 mobile: +48 602 42 42 77 Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, NIP: 586-000-78-20, REGON: 190024711-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 11 2011 - 02:41:03 CDT