这篇文章主要介绍“怎么解决Oracle中dg主库创建文件备库未同步问题”，在日常操作中，相信很多人在怎么解决Oracle中dg主库创建文件备库未同步问题问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”怎么解决Oracle中dg主库创建文件备库未同步问题”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

环境

备库standby_file_management参数为MANUAL

主库创建数据文件时备库应用失败

主库

SQL>createtablespacetestdatafile'+DATA/dgpri/datafile/test01.dbf'size50m;

备库开启实时应用

ALTERDATABASERECOVERMANAGEDSTANDBYDATABASEUSINGCURRENTLOGFILEDISCONNECTFROMSESSION;

查看日志

ArchivedLogentry19addedforthread1sequence30rlc1015097842ID0x3b7defacdest2:RFS[6]:Nostandbyredologfilesavailableforthread1RFS[6]:Openedlogforthread1sequence31dbid998109615branch1015097842ThuAug0101:20:032019MediaRecoveryLog/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_30_1015097842.dbfFile#6addedtocontrolfileas'UNNAMED00006'becausetheparameterSTANDBY_FILE_MANAGEMENTissettoMANUALThefileshouldbemanuallycreatedtocontinue.Errorswithlog/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_30_1015097842.dbfMRP0:BackgroundMediaRecoveryterminatedwitherror1274Errorsinfile/u01/app/oracle/diag/rdbms/dgphy/dgphy/trace/dgphy_pr00_74382.trc:ORA-01274:cannotadddatafile'+DATA/dgpri/datafile/test01.dbf'-filecouldnotbecreated....ManagedStandbyRecoverystartingRealTimeApplyThuAug0101:22:102019Errorsinfile/u01/app/oracle/diag/rdbms/dgphy/dgphy/trace/dgphy_dbw0_74012.trc:ORA-01186:file6failedverificationtestsORA-01157:cannotidentify/lockdatafile6-seeDBWRtracefileORA-01111:namefordatafile6isunknown-renametocorrectfileORA-01110:datafile6:'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00006'File6notverifiedduetoerrorORA-01157MRP0:BackgroundMediaRecoveryterminatedwitherror1111Errorsinfile/u01/app/oracle/diag/rdbms/dgphy/dgphy/trace/dgphy_pr00_82248.trc:ORA-01111:namefordatafile6isunknown-renametocorrectfileORA-01110:datafile6:'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00006'ORA-01157:cannotidentify/lockdatafile6-seeDBWRtracefileORA-01111:namefordatafile6isunknown-renametocorrectfileORA-01110:datafile6:'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00006'ManagedStandbyRecoverynotusingRealTimeApply

此时备库执行

SQL>alterdatabasecreatedatafile'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00006'as'+DATA/dgphy/datafile/test01.dbf';Databasealtered.

再开启实时应用

SQL>ALTERDATABASERECOVERMANAGEDSTANDBYDATABASEUSINGCURRENTLOGFILEDISCONNECTFROMSESSION;Databasealtered.

查看日志

ALTERSYSTEMSETstandby_file_management='MANUAL'SCOPE=BOTH;alterdatabasecreatedatafile'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00006'as'+DATA/dgphy/datafile/test01.dbf'Completed:alterdatabasecreatedatafile'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00006'as'+DATA/dgphy/datafile/test01.dbf'ThuAug0101:23:042019ALTERDATABASERECOVERMANAGEDSTANDBYDATABASEUSINGCURRENTLOGFILEDISCONNECTFROMSESSIONAttempttostartbackgroundManagedStandbyRecoveryprocess(dgphy)ThuAug0101:23:042019MRP0startedwithpid=24,OSid=82426MRP0:BackgroundManagedStandbyRecoveryprocessstarted(dgphy)startedlogmergerprocessThuAug0101:23:102019ManagedStandbyRecoverystartingRealTimeApplyParallelMediaRecoverystartedwith2slavesWaitingforallnon-currentORLstobearchived...Allnon-currentORLshavebeenarchived.ThuAug0101:23:102019Archiverprocessfreedfromerrors.NolongerstoppedMediaRecoveryLog/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_30_1015097842.dbfCompleted:ALTERDATABASERECOVERMANAGEDSTANDBYDATABASEUSINGCURRENTLOGFILEDISCONNECTFROMSESSIONMediaRecoveryLog/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_31_1015097842.dbfMediaRecoveryWaitingforthread1sequence32(intransit)

此时实时应用已经成功完成

查看进程

SQL>!ps-ef|grepmrporacle743651000:43?00:00:00ora_mrp0_dgphyoracle8179780300001:19pts/1400:00:00/bin/bash-cps-ef|grepmrporacle8179981797001:19pts/1400:00:00grepmrp

查看数据文件

SQL>selectnamefromv$datafile;NAME--------------------------------------------------------------------------------+DATA/dgphy/datafile/system.277.1015099429+DATA/dgphy/datafile/sysaux.278.1015099475+DATA/dgphy/datafile/undotbs1.280.1015099527+DATA/dgphy/datafile/users.281.1015099533+DATA/dgphy/datafile/example.279.1015099511+DATA/dgphy/datafile/test01.dbf6rowsselected.

发现问题已经解决了，最后

altersystemsetstandby_file_management='AUTO';

到此，关于“怎么解决Oracle中dg主库创建文件备库未同步问题”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！