Oracle standby库的ORA-01274问题

在standby数据库中，初始化参数STANDBY_FILE_MANAGEMENT设置为MANUAL环境中，当主库新建一个数据文件时，它MRP进程中止，后台介质恢复工作失败。这是因为standby数据库不能自动创建新文件，参数配置决定了。

在alert.log中，日志信息如下：

Thu Apr 11 16:44:37 2013
Primary database is in MAXIMUM PERFORMANCE mode
RFS[4]: Successfully opened standby log 51: "+VG1/lbesup/standby_redo51.log"
Thu Apr 11 16:44:40 2013
Media Recovery Log +VG1/lbesupg/archivelog/2013_04_11/thread_1_seq_16122.1412.812479477
File #12 added to control file as "UNNAMED00012" because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
Errors with log +VG1/lbesupg/archivelog/2013_04_11/thread_1_seq_16122.1412.812479477
MRP0: Background Media Recovery terminated with error 1274
Thu Apr 11 16:44:41 2013
Errors in file /u01/app/Oracle/admin/lbesup/bdump/lbesup_mrp0_10220.trc:
ORA-01274: cannot add datafile "+VG1/lbesup/lb_7881_data01.dbf" - file could not be created
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Thu Apr 11 16:44:43 2013
Errors in file /u01/app/oracle/admin/lbesup/bdump/lbesup_mrp0_10220.trc:
ORA-01274: cannot add datafile "+VG1/lbesup/lb_7881_data01.dbf" - file could not be created
Thu Apr 11 16:44:43 2013
MRP0: Background Media Recovery process shutdown （lbesup）

解决方法很简单，很简单。

SQL> alter database create datafile "/u01/app/oracle/product/10.2.0/db/dbs/UNNAMED00012" as "+VG1/lbesup/lb_7881_data01.dbf";

Database altered.

然后启用恢复进程，问题解决。更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12MongoDB官方提供了更方便的Ubuntu下安装方法Oracle出现ORA-00257错误解决方法相关资讯 Oracle standby ORA-01274

ORA-15041，ORA-01274 故障解决实（06/25/2015 09:13:35）
Oracle 10g 物理standby转为逻辑（08/08/2014 11:17:59）
Oracle DG 修改逻辑Standby端数据（08/16/2013 11:54:27）

Oracle 11g 利用泠备份恢复standby （06/25/2015 08:49:29）
Oracle 10g/11g下如何将物理（09/14/2013 14:00:39）
Oracle DG 逻辑Standby创建说明（08/16/2013 11:50:30）

本文评论查看全部评论（0）