Thursday 31 March 2016

ORA-10877: error signaled in parallel recovery slave

During restore and recovery we have encountered the below error.









Cause :  We are restoring full database from tape backup for older date.
And this is prod to Dev DB refresh.

While restoring we only copy prod backup pieces.This prod DB was encrypted and we did not copy the Wallet key. that cause the issue.

Action: Copy the wallet key from Prod to target in the wallet location and restart the recovery again.
To find the wallet location

SQL> select * from v$encryption_wallet;

If wallet is not created than create the wallet in DEV env with the below steps

1. Modify sqlnet.ora file with wallet location .
modification on (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = <Wallet directory location/dbname>)))
2   .Run this in unix command:

orapki wallet create -wallet <Wallet directory location/dbname> -auto_login -pwd password

3.sqlplus / as sysdba

4.alter system set encryption key identified by "password";
Note: This password should be same with Prod password

5.alter system set wallet open identified by "password";
6.select * from v$encryption_wallet;



1 comment:

  1. Thank you for the reminder. I have been chasing my alert log and retrying my restore several times. Then I checked my wallet file after reading your blog and, you guessed it, it was in the wrong directory. Thanks much for publishing this!!

    ReplyDelete