High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

dataguard questions

Hi All..
I work on 10.2.0.4 oracle database on windows 2003 server. We have a remote standby which i recently built.
I executed the following query on my primary database after my standby creation: 
select  substr(DESTINATION,1,8) DEST,DEST_ID,STANDBY_LOGFILE_COUNT,STANDBY_LOGFILE_ACTIVE,SRL
from V$ARCHIVE_DEST_STATUS
 
DEST          DEST_ID STANDBY_LOGFILE_COUNT STANDBY_LOGFILE_ACTIVE SRL
---------- ---------- --------------------- ---------------------- ---
                    1                     0                      0 NO
STUSTDBY            2                     6                      4 NO 
                    3                     0                      0 NO
                    4                     0                      0 NO
                    5                     0                      0 NO
                    6                     0                      0 NO
                    7                     0                      0 NO
                    8                     0                      0 NO
                    9                     0                      0 NO
                   10                     0                      0 NO
I have 5 standby redo logs. The above query says I have got 6(STANDBY_LOGFILE_COUNT) which is misleading. The above query also tells me it is not using SRL (SRL =NO)<br/>SQL> select group#,sequence#,status from v$standby_log;
 
    GROUP#  SEQUENCE# STATUS
---------- ---------- ----------
         4      10188 ACTIVE
         5          0 UNASSIGNED
         6          0 UNASSIGNED
 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center