Oracle物理备库大量trc文件报"Redo Shipping Client Established Network Login"
Oracle大量trc文件报"Redo Shipping Client Established Network Login"
如下,每分钟包含trm+trc会产生4个文件。
trc的内容均为:
Redo Shipping Client Established Network Login
根据mos文档"Repeated "Redo Shipping Client Established Network Login" tracing in the RFS trace (文档 ID 2011184.1)"描述。
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
SYMPTOMS
Repeated "Redo Shipping Client Established Network Login" tracing in the RFS trace file, as following:
Redo Shipping Client Established Network Login
Redo Shipping Client Established Network Login
Redo Shipping Client Established Network Login
Redo Shipping Client Established Network Login
CHANGES
Upgraded the database version to 11.2.0.4
CAUSE
This is due to Bug:18766012
SOLUTION
There are two Options to get rid of this Problem:
1. Ignore those Traces and create an OS-Job to regularly delete those Tracesfiles
2. Apply Patch 18766012 for your Platform on Top of 11.2.0.4 at least on the Standby Database.
Note that this Bug is fixed in 12.x, too.
对应Patch 18766012有两个对应的补丁:
p18766012_112040_Linux-x86-64.zip
p18766012_11204160419_Linux-x86-64.zip
两个我都检测过了,没有冲突。
然而无论哪个补丁,在线打或者离线打完之后,还是会产生大量的rfs的trc文件。
搞不懂。