Home » RDBMS Server » Server Administration » ORA-00600:kcbz_check_objd_typ_3
ORA-00600:kcbz_check_objd_typ_3 [message #247167] Sun, 24 June 2007 22:38 Go to next message
boomslaang
Messages: 4
Registered: June 2007
Junior Member
Hello All,

We ve a production rac with 2 nodes on 10.2.0.2 on Solaris 10.

On the node2, since few days in the alert.log file 'am getting the message

ORA-00600: \345\206\205\351\203\250\343\202\250\343\203\251\343\203\274\343\203\273\343\202\263\343\203\274\343\203\211\343\200\201\345\274\225\
346\225\260: [ORA-00600: \345\206\205\351\203\250\343\202\250\343\203\251\343\203\274\343\203\273\343\202\263\343\203\274\343\203\211\343\200\20
1\345\274\225\346\225\260: [kcbz_check_objd_typ_3],[14],[0],[16],[],[],[],[]
ORA-06512: "SYS.DBMS_STATS", \350\241\21419066
],[],[],[],[],[],[],[]

Metalink Note:4430244.8 says,

Workaround:
Do not use segment advisor to prevent the problem occuring.
Use "alter system flush buffer cache" to clear bad blocks
from the cache (In RAC the block may have sourced from a
different instance so you need to flush all buffer caches).


What all things will i hve to take care before FLUSHING the buffer cache ???

TIA,

JJ
Re: ORA-00600:kcbz_check_objd_typ_3 [message #247168 is a reply to message #247167] Sun, 24 June 2007 22:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Ensure you have a good & current backup along with tested & correct restoration procedure.
Re: ORA-00600:kcbz_check_objd_typ_3 [message #247194 is a reply to message #247168] Mon, 25 June 2007 00:40 Go to previous messageGo to next message
boomslaang
Messages: 4
Registered: June 2007
Junior Member
Has this flushing of the buffer cache got that much impact ??
Re: ORA-00600:kcbz_check_objd_typ_3 [message #247197 is a reply to message #247167] Mon, 25 June 2007 00:55 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Time will tell & you will live & learn.
It is NEVER a bad thing to have current backups & valid restore procedures.
Previous Topic: Save Pfile Permanently
Next Topic: Archived Redo logs - Oracle Apps
Goto Forum:
  


Current Time: Mon Dec 02 09:15:23 CST 2024