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

  • From: GG <grzegorzof@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 19 Apr 2021 15:33:16 +0200

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


--
//www.freelists.org/webpage/oracle-l


Other related posts:

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