UNRECOVERABLE_CHANGE found
Oracle database 19c 19.17.0.0 on Redhat Enterprise 8.6. Same version on primary and standby database.
On primary database, I found unrecoverable_change# in v$datafile
select file#, name, unrecoverable_time, unrecoverable_change#
from v$datafile where unrecoverable_time is not null and unrecoverable_change# > 0;
FILE# NAME UNRECOVER UNRECOVERABLE_CHANGE#
10 /oracle/oradata/bsn268/trading_s_data01_01.dbf 27-MAY-23 12059619 12 /oracle/oradata/bsn268/trading_l_data01_01.dbf 08-APR-25 7607152233 13 /oracle/oradata/bsn268/trading_l_data01_02.dbf 08-APR-25 7607152233
Same query run on standby database, there's only 1 record as below
FILE# NAME UNRECOVER UNRECOVERABLE_CHANGE#
10 /oracle/oradata/bsn268/trading_s_data01_01.dbf 27-MAY-23 12059619
So far I have no problem with the primary database usage. I restarted the primary database ok yesterday and transaction log have been applying on standby without issue. Did some reading and found this knowledge base