Oracle DataGuard issue: ORA-00600: [kddummy_blkchk] / ORA-10561

  • From: "Gupta, Deepender K" <DGUPTA@xxxxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 13 Dec 2010 11:53:15 -0600

Hello Everyone,

 

We did a switchover to the backup site past weekend and then switched
back to the primary site. After the switchback, the recovery process on
the standby site failed with the ORA 600 error message. We restarted the
database and started the recovery with the "RECOVER STAND BY DATABSAE"
but had the same error messages. Any suggestions?

 

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

Media Recovery Log /u06/arch/rbtp/arch_460544197_1_153892.arc
Mon Dec 13 09:10:44 2010
Errors in file
/u01/app/oracle/admin/rbtp/bdump/rbtp1/rbtp1_p002_761271.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '/u04/oradata/rbtp/redo_rbtp1_03a.log'
Mon Dec 13 09:10:44 2010
Errors in file
/u01/app/oracle/admin/rbtp/bdump/rbtp1/rbtp1_p002_761271.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [15],
[186825], [6401], [], [], [], []
Mon Dec 13 09:10:57 2010
Errors in file
/u01/app/oracle/admin/rbtp/bdump/rbtp1/rbtp1_p002_761271.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [15],
[186825], [6401], [], [], [], []
Mon Dec 13 09:11:03 2010
Trace dumping is performing id=[cdmp_20101213091103]
Mon Dec 13 09:11:03 2010
Errors in file
/u01/app/oracle/admin/rbtp/bdump/rbtp1/rbtp1_p002_761271.trc:
ORA-10562: Error occurred while applying redo to data block (file# 15,
block# 186825)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 15: '/u01/oradata/rbtp/sysaux_01.dbf'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object#
231764
ORA-00600: internal error code, arguments: [kddummy_blkchk], [15],
[186825], [6401], [], [], [], []
Mon Dec 13 09:11:03 2010
Errors with log /u06/arch/rbtp/arch_460544197_1_153892.arc
Mon Dec 13 09:11:03 2010
Media Recovery failed with error 12801
ORA-283 signalled during: ALTER DATABASE RECOVER LOGFILE
'/u06/arch/rbtp/arch_460544197_1_153892.arc' ...
Mon Dec 13 09:11:03 2010
ALTER DATABASE RECOVER CANCEL
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...
Mon Dec 13 09:24:47 2010

Other related posts: