我的物理备库因ora 01274问题导致MRP终止并启动失败。这个问题处理起来很简单,但是百度搜了篇文章差点把我带坑里,因此我把MOS的标准步骤写下来,给各位朋友一个参考。
这个DG环境在两周前已经搭建好,今天需要正式切换。切换前,惯例先检查下主备库状态。这一查发现备库已经有一周多没有应用日志了。由于DG搭建是有一个checklist的,因此不会是忘记开启MRP,肯定是中间有问题导致日志应用断了。查看备库alert,发现如下报错:
Fri Nov 24 16:39:15 2017
File #9 added to control file as 'UNNAMED00009' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/app/oracle/diag/rdbms/dbnamestby/dbname/trace/dbname_pr00_46964.trc:
ORA-01274: cannot add datafile '+DATA/dbnameprmy/datafile/datafile.491.960914347' - file could not be created
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovery stopped due to failure in applying recovery marker (opcode 17.30).
Datafiles are recovered to a consistent state at c