RE: Active data guard NOT change to appluing_log until primary DB switch log file???

I eventually figure out problem. Both side orapw file are not exactly same (case sensitive).

I re-copy primary DB orapw file to standby DB and problem fix.

• On Wed, 9/7/11, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:

> From: Goulet, Richard <Richard.Goulet_at_parexel.com>
> Subject: RE: Active data guard NOT change to appluing_log until primary DB switch log file???
> To: "mccdba1_at_yahoo.com" <mccdba1_at_yahoo.com>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> Cc: "oracle-db-l_at_Groups.ITtoolbox.com" <oracle-db-l_at_Groups.ITtoolbox.com>
> Date: Wednesday, September 7, 2011, 10:59 AM
> On the primary database what is the
> definition of log_archive_dest_2 or whichever your
> using.  Also does your standby database have standby
> logfiles defined?
>
> Richard Goulet
> Senior Oracle DBA/Na Team Leader
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of dba1 mcc
> Sent: Wednesday, September 07, 2011 10:29 AM
> To: oracle-l_at_freelists.org
> Cc: oracle-db-l_at_Groups.ITtoolbox.com
> Subject: Active data guard NOT change to appluing_log until
> primary DB switch log file???
>
> we have ORACLE 11G (11.1.0.7) on LINUX server.  What
> we use is "active data guard".  Our problem is when we
> switch to "active data guard", standby database always on
> "wait_for_gap".  We need switch log on Primary database
> then Standby database will immediate change to
> "APPLYING_LOG".
>
> Any ideal?
>
> Thanks.
>
> =================================================
>
> SQL> alter database recover managed standby database
> using current logfile disconnect;
>
> Database altered.
>
> SQL> select 'Using Active Data Guard' adg from
> v$managed_standby M, v$database D where M.process like
> 'MRP%' and D.open_mode ='READ ONLY';
>
> ADG
> -----------------------
> Using Active Data Guard
>
> SQL> Select process, status, sequence#, block#, blocks,
> delay_mins from v$managed_standby;
>
> PROCESS   STATUS       
> SEQUENCE#     BLOCK# 
>    BLOCKS DELAY_MINS
> --------- ------------ ---------- ---------- ----------
> ----------
> ARCH      CONNECTED     
>        0       
>   0          0   
>       0
> ARCH      CONNECTED     
>        0       
>   0          0   
>       0
> ARCH      CONNECTED     
>        0       
>   0          0   
>       0
> ARCH      CONNECTED     
>        0       
>   0          0   
>       0
> RFS       IDLE     
>             0   
>       0         
> 0          0
> RFS       IDLE     
>             0   
>       0         
> 0          0
> MRP0      WAIT_FOR_GAP     
>   113          0   
>       0          0
>
> 7 rows selected.
>
> SQL> select * from v$archive_gap;
>
> no rows selected
>
> SQL> SELECT max(sequence#) from v$archived_log where
> applied='YES';
>
> MAX(SEQUENCE#)
> --------------
>            112
>
> **** Primary database switch log file
>
> SQL> Select process, status, sequence#, block#, blocks,
> delay_mins from v$managed_standby;
>
> PROCESS   STATUS       
> SEQUENCE#     BLOCK# 
>    BLOCKS DELAY_MINS
> --------- ------------ ---------- ---------- ----------
> ----------
> ARCH      CONNECTED     
>        0       
>   0          0   
>       0
> ARCH      CONNECTED     
>        0       
>   0          0   
>       0
> ARCH      CLOSING       
>      113      49153 
>       539         
> 0
> ARCH      CONNECTED     
>        0       
>   0          0   
>       0
> RFS       IDLE     
>             0   
>       0         
> 0          0
> RFS       IDLE     
>             0   
>       0         
> 0          0
> MRP0      APPLYING_LOG     
>   114          5 
>    204800         
> 0
> RFS       IDLE     
>           114     
>     6          1 
>         0
>
> 8 rows selected.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l