ORA-10878: parallel recovery slave died unexpectedly

I face with this issue when try to add standby file on standalone 11.2.0.1 database with ASM on AIX operating system:

Symptoms:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE
*
ERROR at line 1:
ORA-10878: parallel recovery slave died unexpectedly

Error in alert log:

error in alert:

Thu Jan 12 10:42:13 2012
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x0] [PC:0x100137314, kggibr()+52] [flags: 0x0, count: 1]
Errors in file /oracle11g/db/TEST/11.2.0/log/diag/rdbms/stby/STBY/trace/STBY_pr04_9830594.trc (incident=201896):
ORA-07445: exception encountered: core dump [kggibr()+52] [SIGSEGV] [ADDR:0x0] [PC:0x100137314] [Invalid permissions for mapped object] []

Solution:

ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE USING CURRENT LOGFILE DISCONNECT noparallel;

Referance:
Bug 9728806 – ORA-7445 [kggibr()+52] during recovery on IBM AIX POWER Systems [ID 9728806.8]



“ORA-10878: parallel recovery slave died unexpectedly” için 3 cevap

  1. […] which will then in normal operation mode apply only one log at the time. Diggout out from Helios’s Blog Tags: Parallel Media Recovery Comments (0) Trackbacks (0) Leave a comment […]

  2. Thanks a Lot !! Good documentation really helpful in real envirnoment

Yorum bırakın