这个问题比较郁闷,发现昨晚logical standby无缘无故的停了apply,DBA及相关人员没有进行过手工停止,alert日志的信息如下,且并没有关于停止命令的记录,比如Completed: alter database stop logical standby apply的信息。查资料未果,那么问题究竟出在哪里呢?
alert.log:
Tue Jul 28 22:30:22 2009
LOGSTDBY Apply process AS02 pid=117 OS id=628164 stopped
Tue Jul 28 22:30:22 2009
LOGSTDBY Apply process AS05 pid=120 OS id=562154 stopped
Tue Jul 28 22:30:22 2009
LOGSTDBY Apply process AS01 pid=116 OS id=742588 stopped
Tue Jul 28 22:30:22 2009
LOGSTDBY Apply process AS08 pid=123 OS id=706270 stopped
Tue Jul 28 22:30:22 2009
LOGSTDBY Apply process AS07 pid=122 OS id=595864 stopped
Tue Jul 28 22:30:22 2009
LOGSTDBY Apply process AS03 pid=118 OS id=824362 stopped
Tue Jul 28 22:30:22 2009
LOGSTDBY Analyzer process AS00 pid=115 OS id=692862 stopped
Tue Jul 28 22:30:22 2009
LOGSTDBY Apply process AS04 pid=119 OS id=583328 stopped
Tue Jul 28 22:30:22 2009
LOGSTDBY Apply process AS06 pid=121 OS id=661042 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, reader MS00 pid=104 OS id=750260 sid=2231 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, preparer MS09 pid=114 OS id=586042 sid=2184 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, preparer MS04 pid=109 OS id=669184 sid=2160 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, builder MS01 pid=106 OS id=623828 sid=2223 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, preparer MS05 pid=110 OS id=713448 sid=2206 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, preparer MS08 pid=113 OS id=775230 sid=2222 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, preparer MS06 pid=111 OS id=624062 sid=2179 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, preparer MS07 pid=112 OS id=593962 sid=2193 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, preparer MS02 pid=107 OS id=709318 sid=2202 stopped
Tue Jul 28 22:30:23 2009
LOGMINER: session#=1, preparer MS03 pid=108 OS id=623472 sid=2217 stopped
Tue Jul 28 22:30:29 2009
LOGSTDBY status: ORA-16128: User initiated stop apply successfully completed
Wed Jul 29 00:02:54 2009
RFS LogMiner: Client enabled and ready for notification
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10322123/viewspace-610700/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10322123/viewspace-610700/