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 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
0