ORA-600 [4555] On The Standby Database (Doc ID 1216563.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 and later
Information in this document applies to any platform.

Symptoms


Encountered ORA-00600 in our standby database while trying to recover and here is the Alert log file from the standby database:



Alert log from Standby database:

Thu Sep 23 09:22:48 2010
Standby Database mounted.
Completed: alter database mount standby database
Thu Sep 23 09:25:24 2010
RFS: No standby redo logfiles available
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
Thu Sep 23 10:38:08 2010
Full restore complete of datafile 4 /oradata1/istpdn/bdoist_1.dbf
checkpoint is 54425404466
Thu Sep 23 10:42:26 2010
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
Thu Sep 23 10:59:23 2010
alter database recover automatic standby database
Thu Sep 23 10:59:23 2010
Media Recovery Start
Thu Sep 23 10:59:23 2010
Media Recovery Log /oradata4/istpdn/arch/1_1902385.dbf
Thu Sep 23 10:59:28 2010
Errors in file /ora2/istpdn/oracle/admin/udump/istpdn_ora_29596.trc:
ORA-00600: internal error code, arguments: [4552], [1], [0], [], [], [], [], []
Recovery interrupted.
Recovered data files restored to a consistent state at change 53660054442
Thu Sep 23 10:59:45 2010
Media Recovery failed with error 10562
ORA-283 signalled during: alter database recover automatic standby database...
Thu Sep 23 11:00:18 2010
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created
RFS: No standby redo logfiles created

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms