最近一台rac的主机硬件坏了,修好后用添加节点的方式重新加入rac,新添加的实例自然有一个undotbs和online redo。添加完毕我switch了下log,看到2个dataguard的节点都出现了新的undotbs的数据文件。以为ok了。
过了一会儿dataguard的监控报警了,一看alert发现了下面的错误:
No OMF destination specified, unable to create logs
Errors with log /db2/arch/sdavtpst/2_221_686846102.dbf
MRP0: Background Media Recovery terminated with error 1264
Errors in file /usr/u01/app/diag/rdbms/sdavtpst/sdavtpst/trace/sdavtpst_mrp0_17931.trc:
ORA-01264: Unable to create logfile file name
Shutting down recovery slaves due to error 1264
Wed Jun 17 09:35:01 2009
Recovery interrupted!
Recovered data files to a consistent state at change 149642685
Errors in file /usr/u01/app/diag/rdbms/sdavtpst/sdavtpst/trace/sdavtpst_mrp0_17931.trc:
ORA-01264: Unable to create logfile file name
MRP0: Background Media Recovery process shutdown (sdavtpst)
看了新的online redo在dg端生成失败了,导致apply中断。检查了下rac的log_convert参数,没问题。再查了下metalink,发现了类似的错误,应该是因为rac是omf,而我的dg都是单机的文件系统。所以redo创建失败,使用:
ALTER SYSTEM SET db_create_file_dest='/db1/oradata/sdavtpst' SCOPE=BOTH;
指定了下omf的生成路径,重新开启dg的apply,一切恢复。nnd
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/79686/viewspace-1023209/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/79686/viewspace-1023209/