Media Recovery terminated with error 28365 # TDE

>>> >>>> >>>> >>>

scenario # created Oracle Wallet <<

>> MRP stopped on standby # 

SQL> select * from v$dataguard_status where severity in ('Error','Fatal') and timestamp > (sysdate -1);

FACILITY SEVERITY   DEST_ID MESSAGE_NUM ERROR_CODE CAL TIMESTAMP

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

MESSAGE

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

Log Apply Services Error 0   4         28365 YES  13-OCT-16

MRP0: Background Media Recovery terminated with error 28365

SQL> select * from v$encryption_wallet;

WRL_TYPE  WRL_PARAMETER  STATUS

————————————————————————————————

file     /u02/encrypt/    CLOSED

Resolution # >>>> 
Steps to perform to resolve Issue on standby >>>
shutdown the standby database 
scp cwallet.sso & ewallet.p12 to standby server wallet location from primary 
Mount the database 
Start MRP process 

SQL> select open_mode from v$database;

OPEN_MODE

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

MOUNTED

SQL> shut immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

From Primary > scp cwallet.sso and ewallet.p12 

[oracle@dg1 encrypt]$ scp * oracle@192.168.56.104:/u02/encrypt/

oracle@192.168.56.104's password: 

cwallet.sso                                   100% 2923     2.9KB/s   00:00    

ewallet.p12                                   100% 2845     2.8KB/s   00:00 

SQL> startup mount;

ORACLE instance started.

Total System Global Area  835104768 bytes

Fixed Size     2257840 bytes

Variable Size   541068368 bytes

Database Buffers   289406976 bytes

Redo Buffers     2371584 bytes

Database mounted.

SQL> select * from v$encryption_wallet;

WRL_TYPE  WRL_PARAMETER  STATUS

————————————————

file     /u02/encrypt/    OPEN

> Start the MRP on standby< 

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select process from v$managed_standby where process like 'MRP%';

PROCESS

---------

MRP0

>>> 

--Nikhil Tatineni--

--Dataguard-- 
Links Related to Datagaurd <
Applying logs with delay # Standby database #
http://www.oracleinmemory.com/2016/07/dataguard-delay-parameter.html
Physical Standby # Active Dataguard 11g
http://www.oracleinmemory.com/2016/07/physical-standby-active-dataguard-11g.html
Snapshot standby # 11g
http://www.oracleinmemory.com/2016/07/dataguard-converting-physical-standby.html
Troubleshooting #
Dataguard # oldest online log sequence 0
http://www.oracleinmemory.com/2016/07/dataguard-oldest-online-log-sequence-0.html