About standby redo logs

  • From: Kamus <kamusis@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 05 Jan 2005 22:33:15 +0800

I create 4 standby redo log groups, and use LGWR in primary site to
transfer redo data, all are good. 
But when I query the V$STANDBY_LOG view,
I found that only the status column of GROUP# 4(the first group of my
standby redo logs) value is "ACTIVE" while all the others(5-7) are
also, only GROUP# 4's sequence# is a value greate than 0
and THREAD# is 1, all others are 0 and 0.

Any explains.

Kamus <kamusis@xxxxxxxxx>

A Oracle8i & 9i Certified DBA from China


Other related posts: