dataguard questions
edited Jan 23, 2012 2:37AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 5 commentsAnswered
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 NOI 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
0