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.

然后启用恢复进程，问题解决。