Home >Database >Mysql Tutorial >Oracle standby库的ORA-01274问题

Oracle standby库的ORA-01274问题

WBOY
WBOYOriginal
2016-06-07 17:28:161305browse

在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.
 
然后启用恢复进程,问题解决。

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn