>데이터 베이스 >MySQL 튜토리얼 >Oracle standby库的ORA-01274问题

Oracle standby库的ORA-01274问题

WBOY
WBOY원래의
2016-06-07 17:28:161310검색

在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

성명:
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.