Re: Oracle DataGuard issue: ORA-00600: [kddummy_blkchk] / ORA-10561
- From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
- To: DGUPTA@xxxxxxxxxxx
- Date: Mon, 13 Dec 2010 20:56:55 +0100
Hi,
please specify DB and OS version.
BTW, oracle has many bugs regarding this function.
Maybe you're hitting the bug 5599596: Block corruption / OERI
[kddummy_blkchk] on clustered or compressed tables
Stefano
On 13 December 2010 18:53, Gupta, Deepender K <DGUPTA@xxxxxxxxxxx> wrote:
> 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
--
http://www.stefanocislaghi.eu
--
//www.freelists.org/webpage/oracle-l
Other related posts:
