Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Dataguard主库alert日志如下:
Mon Sep 22 09:49:16 2014
Error 9945 received logging on to the standby
Mon Sep 22 09:55:37 2014
Error 9925 received logging on to the standby
Mon Sep 22 09:57:54 2014
Error 9945 received logging on to the standby
Mon Sep 22 10:04:00 2014
Error 9945 received logging on to the standby
Mon Sep 22 10:13:22 2014
最近并没有对这套环境进行过调整。google和MOS 上也没什么帮助信息。
检查了一下standby的日志发现,原来standby的空间不够了,奇怪的是nagios并没有报警。
Sun Sep 21 04:24:47 2014
Non critical error ORA-48181 caught while writing to trace file "/u01/ora/diag/rdbms/orastd01/trace/orastd01_rfs_12547.trc"
Error message: Linux-x86_64 Error: 28: No space left on device
Additional information: 1
Writing to the above trace file is disabled for now on...
RFS[113]: Possible network disconnect with primary database
Sun Sep 21 04:24:48 2014
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 49404-49408
DBID 1807841883 branch 770961807
FAL[client]: All defined FAL servers have been attempted.
------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that's sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
------------------------------------------------------------
Sun Sep 21 04:24:48 2014
Non critical error ORA-48181 caught while writing to trace file "/u01/ora/diag/rdbms/orastd01/trace/orastd01_rfs_12543.trc"
Error message: Linux-x86_64 Error: 28: No space left on device
Additional information: 1
Writing to the above trace file is disabled for now on...
RFS[110]: Possible network disconnect with primary database
解决了standby的空间问题,主库上的错误也随之消失。