Some weird phenomenons on oracle data guard physical standby on 11g?
From: Quanwen Zhao <quanwenzhao_at_gmail.com>
Date: Thu, 1 Jun 2023 21:13:37 +0800
Message-ID: <CABpiuuRbx2q2Oj8Gfs3Zw38vpfSVS9YqijTQceEfjxoDP20W2g_at_mail.gmail.com>
Hello my oracle friends :-),
Date: Thu, 1 Jun 2023 21:13:37 +0800
Message-ID: <CABpiuuRbx2q2Oj8Gfs3Zw38vpfSVS9YqijTQceEfjxoDP20W2g_at_mail.gmail.com>
Hello my oracle friends :-),
I've found out some weird phenomenons on oracle data guard physical standby on 11g of production system on my customer.
- The status are all showing *CLEARING* on 9 number of redo log files and the status is *CURRENT* on another redo log file (*the group number is from 11 to 20*).
- The total *11* number of standby redo log files (*the group number is from 21 to 31*) have always switched (*the status is from UNASSIGNED to ACTIVE*) on only between *21* and *22* and the rest of 23 - 31 seem to not have been their turn forever. I've observed it from alert log.
Those two number of descriptions above is normal? At the same time I've glanced at Oracle 19c Data Guard Physical Standby, the status are always *UNUSED* (never showing CLEARING and CURRENT) on redo log files, 11g and 19c has a different action?
Any ideas for this? Thanks in advance!
Best Regards
Quanwen Zhao
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 01 2023 - 15:13:37 CEST