Re: Some weird phenomenons on oracle data guard physical standby on 11g?

From: Howard Latham <howard.latham_at_gmail.com>
Date: Thu, 1 Jun 2023 14:30:35 +0100
Message-ID: <CAPCNhx1pgj0zJOJu5HV2TXBGWcDXD7mo9iO2WaXpTFa5AXBqXw_at_mail.gmail.com>



Are they part of the dB. ? Are they the same size?

On Thu, 1 Jun 2023, 14:15 Quanwen Zhao, <quanwenzhao_at_gmail.com> wrote:

> 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-l
Received on Thu Jun 01 2023 - 15:30:35 CEST

Original text of this message