DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, April 9, 2016

ORA-00600: internal error code, arguments: [2619], [4476], [], [], [], [], [], [], [], [], [], []

Problem:

Physical standby recovery reports error in alert log:

Wed Jun 23 01:10:22 2010
Media Recovery Log /mnt/import/recovery_standby/4_77799_650412287.dbf
Errors in file /oracle/diag/rdbms/db1/DB1/trace/DB1_pr00_16417.trc (incident=360443):
ORA-00600: internal error code, arguments: [2619], [77799], [], [], [], [], [], [], [], [], [], []
Incident details in:
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
...
ORA-10877: error signaled in parallel recovery slave
ORA-10877: error signaled in parallel recovery slave
...
MRP0: Background Media Recovery process shutdown


Cause:

ORA-600[2619] is raised due to an invalid next_change# detected in archive log.

In this case, it is caused by the archive log disk space ran out on standby site, causing that archive log not fully written on disk. This lead to ORA-600[2619] when the archive log was applied.

Solution:

1. Clear the disk space where archive log stored on standby site

2. Copy the problem archive log  from the primary site and replace the one on the standby, then restart Managed Recovery.
Archive log should be applied properly now.

1 comment:

Dhivya Shree said...

Database means to maintain and organize all the files in a systematic format where the data can be easily accessible when needed.
Oracle DBA training in chennai | Oracle training in chennai | Oracle course in Chennai