RE: Active data guard NOT change to appluing_log until primary DB switch log file???
Date: Wed, 7 Sep 2011 14:59:27 +0000
Message-ID: <7642C3D639A75E4284658CAA38BF60A402928A_at_US-BOS-VEX001.eu.pxl.int>
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
Received on Wed Sep 07 2011 - 09:59:27 CDT