MRP0: Background Media Recovery
terminated with error 1274 [ID 739618.1] |
|
|
Modified
10-APR-2011 Type PROBLEM Status PUBLISHED |
|
In this Document
Symptoms
Cause
Solution
Applies to:
Oracle Server - Enterprise Edition - Version:
9.2.0.8 to 11.2.0.2 - Release: 9.2 to 11.2
Information in this document
applies to any platform.
Symptoms
Adding a Tablepace / 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
Cause
This Error occurs if we add a
Datafile OR Tablespace in PRIMARY Database and that could not be translated to
the Standby Database due to these Reasons:
* Standy_file_management is
set to MANUAL
* Primary & Physical Standby are having different file
structures and DB_FILE_NAME_CONVERT is not set according to the Directory
Structures in Primary and Standby
The Redo Log generated from Primary
will have Information about the Tablespace / Datafile added however it could not
be created successfully in Physical Standby Database due to the
standby_file_management = MANUAL
or is not able to find the specified Folder
due to a missing / incorrect Filename Conversion.
The File Entry is added to
Standby Controlfile as "UNNAMED0000n" in /dbs or /database
folder depends on
the Operating System and eventually the MRP terminates.
Alert
Log in Standby Shows MRP is terminated with below error
=================================================================
File
#5 added to control file as 'UNNAMED00005' because
the parameter
STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created
to continue.
MRP0: Background Media Recovery terminated with error 1274
Thu Sep 25 19:02:35 2008
Errors in file
c:\oracle\product\10.2.0\admin\mystd\bdump\mystd_mrp0_3436.trc:
ORA-01274:
cannot add datafile 'D:\ORADATA\PRIM\SALES01.DBF' - file could not be created