ITPub博客

首页 > 数据库 > Oracle > MRP进程起不来:ORA-00600: internal error code, arguments, [227424], [], []

MRP进程起不来:ORA-00600: internal error code, arguments, [227424], [], []

原创 Oracle 作者:DBA_每日记 时间:2019-10-16 15:36:36 0 删除 编辑

问题背景:

客户数据库服务架构为一主一备,某日备库操作系统意外重启,重启后Oracle MRP进程起不来,

报错:ORA-00600: internal error code, arguments: [2619], [227424], [], [], [], [], [], [], [], [], [], []


1> 检查MRP进程


SQL> select process,status from v$managed_standby;


PROCESS STATUS

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

ARCH CONNECTED

ARCH CONNECTED

MRP0 WAIT_FOR_LOG

RFS RECEIVING


没有MRP进程,说明备库没有处于恢复状态。尝试启动MRP进程

alter database recover managed standby database  disconnect from session ;


MRP进程起不来,报错日志如下:


Clearing online redo logfile 5 complete

Media Recovery Log /oraarchivelog/xxxx/oradb_1_227424_866810169.arc

Errors in file /u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_pr00_5429.trc  (incident=48266):

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

Incident details in: /u01/oracle/diag/rdbms/oradb/oradb/incident/incdir_48266/oradb_pr00_5429_i48266.trc

Completed: ALTER DATABASE RECOVER  managed standby database disconnect from session  

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors with log /oraarchivelog/oradb/oradb_1_227424_866810169.arc

MRP0: Background Media Recovery terminated with error 600

Errors in file /u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_pr00_5429.trc:

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

Recovery interrupted!

Errors in file /u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_pr00_5429.trc:

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

Errors in file /u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_mrp0_5426.trc  (incident=48257):

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

ORA-10877: error signaled in parallel recovery slave 

ORA-10877: error signaled in parallel recovery slave 

ORA-10877: error signaled in parallel recovery slave 

ORA-10877: error signaled in parallel recovery slave 

ORA-10877: error signaled in parallel recovery slave 

ORA-10877: error signaled in parallel recovery slave 

ORA-10877: error signaled in parallel recovery slave 

Incident details in: /u01/oracle/diag/rdbms/oradb/oradb/incident/incdir_48257/oradb_mrp0_5426_i48257.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

MRP0: Background Media Recovery process shutdown (oradb)

Dumping diagnostic data in directory=[cdmp_20180328134814], requested by (instance=1, osid=5429 (PR00)), summary=[incident=48266].

Sweep [inc][48266]: completed

Sweep [inc][48257]: completed

Sweep [inc2][48266]: completed

Sweep [inc2][48257]: completed


发现这个600错误是备库在执行恢复的过程中,发现227424这个归档日志有问题或者找不到,导致日志应用失败,

错误原因是因为Errors with log /oraarchivelog/oradb/oradb_1_227424_866810169.arc

这条日志有问题,把归档日志下的这条日志删除,然后从主库传输过来这条日志,


2> 手动重新应用这条日志

alter database register OR replace logfile '/home/oracle/oradb_1_227424_866810169.arc';


3> 开启日志应用

alter database recover managed standby database disconnect from session;

或者数据库open状态下

alter database recover managed standby database using current logfile disconnect from session;

修复完成,问题解决


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69950231/viewspace-2660197/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
聚焦人文和技术,分享干货,共同成长

注册时间:2019-10-09

  • 博文量
    177
  • 访问量
    238557