ITPub博客

首页 > Linux操作系统 > Linux操作系统 > MRP0: Background Media Recovery terminated with error 1274

MRP0: Background Media Recovery terminated with error 1274

原创 Linux操作系统 作者:ad007520 时间:2012-05-02 00:02:51 0 删除 编辑
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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21993926/viewspace-722525/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-06-28

  • 博文量
    137
  • 访问量
    248178