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]

About these ads

One Response to ORA-10878: parallel recovery slave died unexpectedly

  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 [...]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: