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:

*** 2014-05-13 15:54:17.600 14021 krsr.c 
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文件。

搞不懂。