Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center