KCBR: Number of read descriptors = 4096 問題解決

Oracle10g RAC 64Bit .

Standby使用了32Bit的Linux系統。 結果發現Standby上恢復的時候報錯資訊如下： 

出現一下錯誤的可能原因是Primary DB和Standby DB使用的Linux系統不一樣，一個是64bit, 一個是32bit .  

/u01/product/admin/tpc/bdump/tpc1_p002_26111.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/product/oracle
System name:    Linux
Node name:      gnd-dataguard
Release:        2.6.9-5.ELsmp
Version:        #1 SMP Wed Jan 5 19:30:39 EST 2005
Machine:        i686
Instance name: tpc1
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 26111, image: (P002)

*** 2008-09-07 22:22:13.262
*** SERVICE NAME:() 2008-09-07 22:22:13.205
*** SESSION ID:(1312.3114) 2008-09-07 22:22:13.205
KCBR: Number of read descriptors = 4096
KCBR: Media recovery blocks read (ASYNC) = 19198
KCBR: Redo cache copies/changes = 59948/59946
KCBR: Influx buffers flushed = 133 times
KCBR: Reads = 1344 reap (1230 no-op, 0 one), 223 all

--------------------------------------------------------------------------------------------------- 

Oracle 10g RAC Production DB :

Red Hat Enterprise Linux AS release 4 (Nahant)
Kernel 2.6.9-5.ELsmp on an i686
login:

---------------------------------------------------------------------------------------------------    

Oracle 10g  Stadnby DB : 

Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
Kernel 2.6.9-42.ELlargesmp on an x86_64
login:

---------------------------------------------------------------------------------------------------     

 

 

 

 

==================

Metalink 解釋：

==================

Subject: ORA-00600 and ORA-12801 During the recovery

RDBMS Version: 10.2.0.2
Operating System and Version: Windows 2003 Server 64 bit
Error Number (if applicable): ORA-00600
Product (i.e. SQL*Loader, Import, etc.):
Product Version:

ORA-00600 and ORA-12801 During the recovery

Hi experts,

I have been facing with a problem for 2 days but found no solution yet.

I have two systems: a SAP 4.7E with Oracle 10.2.0.2 patch 14 running on Windows 2003 Server 32 bit(named:YBT), and a SAP 4.7E with Oracle 10.2.0.2 patch 14 running on Windows 2003 Server 64 bit(named:YBB). I am trying to restore the database from YBT to YBB using the online backup. When I try to apply archives ,after restore, using the command "recover database using backup controlfile until cancel;"

I get the following errors:
ORA-00283: recovery session canceled due to errors
ORA-12801: error signaled in parallel query server P002
ORA-00600: internal error code, arguments: [kcbvmap_1], [], [], [], [], [], [], []

ORA-01112: media recovery not started

When I search the ybb_p002_3712.trc, I see the error:
kcbvfb: scanned 0 pinned 0 cloned 0 written 0 transferred 0 latched 0, total 0
kcbvmap: unable to find victim buffer
*** 2007-08-03 09:49:38.343
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcbvmap_1], [], [], [], [], [], [], []

When I search the logfiles of the other query servers I see the error:
*** SERVICE NAME:() 2007-08-03 09:49:41.250
*** SESSION ID:(161.1) 2007-08-03 09:49:41.250
Slave exiting with ORA-10388 exception
KCBR: Number of read descriptors = 256
KCBR: Influx buffers flushed = 1 times
KCBR: Reads = 1 reap (1 no-op, 0 one), 3 all

I am waiting for your answers.
Thanks and best regards,

Tolga AKINCI

---

From: 03-Aug-07 14:24
Subject: Re : ORA-00600 and ORA-12801 During the recovery

This error is unpublished/undocumented. I suggest you open a SR.

---

From: 06-Aug-07 06:02
Subject: Re : ORA-00600 and ORA-12801 During the recovery

Hi

Error ORA-12801 occurs when a parallel query server encountered an exception as described in the accompanying message(s).Here you can observer Ora-00600 and Ora-00283 along with it in the error stack.To rectify the problem,correct the error described in the accompanying message.
It is recommended to open a SR with Oracle Support to diagnose Ora-00600.

Regards
Rajkiran

---

From: 08-Aug-07 07:38
Subject: Re : ORA-00600 and ORA-12801 During the recovery

Hi,

I doubt you are using different OS versions of windows YBT is 32 Bit and YBB is 64 Bit. that is the reason why you are getting the error. you cannot restore a online backup to a different host which is not compitable with the source.


Regards,
Neeraj