Apply redo for TSE master key re-key failed: wallet error 28365 (Doc ID 1483167.1)

In this Document

APPLIES TO:

SYMPTOMS

The MRP gets terminated on the standby database and the following errors are seen in the alert log:

Media Recovery Log /oracle/admin/xxxxxx/arch/arch1_613210805_76356
Apply redo for TSE master key re-key failed: wallet error 28365
Errors with log /oracle/admin/xxxxxx/arch/arch1_613210805_76356
MRP0: Background Media Recovery terminated with error 28365
Errors in file /oracle/admin/xxxxxx/diag/rdbms/xxxxxx/xxxxxx/trace/xxxxxx_pr00_356476.trc:
ORA-28365: wallet is not open
Thu Mar 11 16:19:07 2010
Recovery interrupted!

CHANGES

CAUSE

Transparent data encryption has been implemented in the environment and the master key has been re-keyed in the primary database.

SOLUTION

After re-keying the master key in the primary database, perform the following steps:

1. Copy the wallet file (ewallet.p12) from the primary database server to the wallet location of the standby database

Note: The old wallet file in the wallet location on the standby database server has to be removed or renamed. The new ewallet.p12 should be present in this location.

2. Make sure the wallet on the standby database is in auto-login mode.

Once the above steps are completed, the MRP resumes and the logs start getting applied on the standby database.