前段时间，用disk clone 方式从生产库clone一个数据库，结果数据库无法启动，遇到 ORA-03113: end-of-file on communication channel错误。

检查alter log,发现如下错误：

1
2
3
4
5
6
7
8
9

Sat Aug 16 21:45:24 2008
Errors IN file /DATA/oracle/.../instancename_lgwr_6843.trc:
ORA-00600: internal error code, arguments: [2665], [736064], [32768], [512], [496], [1024], [],[]
Sat Aug 16 21:45:25 2008
Errors IN file /DATA/oracle/.../instancename_lgwr_6843.trc:
ORA-00600: internal error code, arguments: [2665], [736064], [32768], [512], [496], [1024], [],[]
Sat Aug 16 21:45:25 2008
LGWR: terminating instance due TO error 470
Instance terminated BY LGWR, pid = 6843

开始怀疑是SA的clone出了问题，后来重做了几次还是有同样的问题，最后通过SR,ORACLE 给出的说法是两边机器的CPU数目不一样引发了BUG5605818
具体如下：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

In this Document
  Symptoms
  Cause
  Solution
  References
 
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.2
This problem can occur on any platform.
Symptoms
 
Received the following errors while trying the startup the database after increasing the number CPU's on the machine.
 
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [2665], [752928], [32768], [512], [496], [1365], [], []
 
Cause
The cause of the issue is due the following unpublished bug.
Bug 5605818
Status: 80,Development to Q/A
Severity: 2,Severe Loss of Service Fixed In Ver: 11.1
O/S: 38 AIX 4.3 Based Systems (64-bit)
PL Group: Gen/Port: G Error #: - Pub: N
 
Abstract: ORA-600 WHEN REDO OVERFLOW BUFFER
Solution
 
To implement the solution, please execute the following steps:
Increase the LOG_BUFFERS to 4M
When log_buffer is not big enough, the maximum allocatable buffer is not big enough to hold the redo, causing an internal error(2665).
The main triggering factor seems to be when "_log_parallelism_max" is >= 3 nbufs can be small  if the log buffer is small.
Exact values needed to trigger this will vary by platform. It looks like the problem can be avoided by giving a larger "LOG_BUFFER".

这个BUG在10.2.0.4 Patch Set中被FIX。

Popularity: 24% [?]