ORA-01122: database file 899 failed verification check as an effect on active duplicate from standby

From: GG <grzegorzof_at_interia.pl>
Date: Mon, 19 Apr 2021 15:33:16 +0200
Message-ID: <bf52beb3-70dd-192e-b53d-d21983f5a640_at_interia.pl>


Hello,

one of 12.1 standby reported this in alert.log as an effect of rman active duplicate (nonprod db refresh) on the same host / node:

MRP0: Background Media Recovery terminated with error 1122 Mon Apr 19 11:30:18 2021
Errors in file
/u02/app/oracle/diag/rdbms/mydbname/DBINST11/trace/DBINST11_pr00_288819.trc:
ORA-01122: database file 899 failed verification check ORA-01110: data file 899:
'+DATAC1/DBINST1_Q/1EDB7A1BF5A2579BE0535C571BACDEC6/DATAFILE/ts_tx_idx.1680.1070270089' ORA-01206: file is not part of this database - wrong database id Managed Standby Recovery not using Real Time Apply Recovery interrupted!
Some recovered datafiles maybe left media fuzzy Media recovery may continue but open resetlogs may fail Mon Apr 19 11:30:21 2021
Errors in file
/u02/app/oracle/diag/rdbms/DBINST1_q/DBINST11/trace/DBINST11_pr00_288819.trc:
ORA-01122: database file 899 failed verification check ORA-01110: data file 899:
'+DATAC1/DBINST1_Q/1EDB7A1BF5A2579BE0535C571BACDEC6/DATAFILE/ts_tx_idx.1680.1070270089' ORA-01206: file is not part of this database - wrong database id Mon Apr 19 11:30:21 2021
MRP0: Background Media Recovery process shutdown (DBINST11)

opened p1 but maybe someone came across ?

Could this be caused by datafile addition while rman dup in progress ?

Regards

Greg

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 19 2021 - 15:33:16 CEST

Original text of this message