My Oracle Support Banner

Physical Standby Instance Terminates with ORA-600 [2878] while trying to Mount (Doc ID 2761370.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.
Issue started after customer tried to fix one of the UNNAMED00nnn at Standby with "wrong file size".

Symptoms

# Standby instance terminates with ORA-600 [2878] while trying to mount database.

-- Standby Alert Log

ALTER DATABASE MOUNT
..

Errors in file /xxxx/app/oracle/admin/xxxx/diag/rdbms/xxxx/xxxx/trace/xxxx_dbw0_xxx.trc (incident=xxxxxx):
ORA-00600: internal error code, arguments: [2878], [481], [6553600], [4194303], [], [], [], [], [], [], [], []
Incident details in: /xxxx/app/oracle/admin/xxxx/diag/rdbms/xxxx/xxxx/incident/incdir_xxxxx/xxxx_dbw0_xxx_ixxxxxx.trc

..

2021-03-15T19:59:02.184372+02:00
USER (ospid: xxx): terminating the instance due to error 471

Changes

Issue started after trying to fix one of the UNNAMED00nnn datafile at Standby with a "wrong file size".

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.