Background Media Recovery terminated with ORA-1274 after adding a Datafile (Doc ID 739618.1)

Last updated on OCTOBER 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.1.0.2 [Release 9.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 26-Sep-2012***
***Checked for relevance on 8-Jul-2015***

Symptoms

Adding a Tablespace / Datafile in Primary Database causes the MRP in Physical Standby Database to terminate with the Error below. STANDBY_FILE_MANAGEMENT = MANUAL is set on the Standby Database.

MRP0: Background Media Recovery terminated with error 1274
ORA-01274: cannot add datafile '...dbf' - file could not be created


In Unix Environment you will get the below Message when try to restart the MRP


ORA-01111: name for data file 163 is unknown - rename to correct file

 BEST Practice,

 

Keep the STANDBY_FILE_MANAGEMENT in AUTO.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms