您好,欢迎访问一九零五行业门户网

Oracle standby库的ORA-01274问题

在standby数据库中,初始化参数standby_file_management设置为manual环境中,当主库新建一个数据文件时,它mrp进程中止,后台介质
在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.
然后启用恢复进程,问题解决。
其它类似信息

推荐信息