Hello Friend's,
In This Post we will discuss about How to reolve ORA-28365 for Standby database
So let's get started
Error in Alert log : ORA-28365
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Reconfiguration complete (total time 0.2 secs)
2023-03-28T02:37:10.294247+03:00
Stopping change tracking
2023-03-28T02:37:10.298854+03:00
Errors in file /u02/app/oracle/diag/rdbms/cdbtmbp/CDBTESTDB/trace/CDBTESTDB_pr00_177969.trc:
ORA-28365: wallet is not open
2023-03-28T02:37:11.484520+03:00
Background Media Recovery process shutdown (CDBTESTDB)
All grantable enqueues granted
Reconfiguration complete (total time 0.2 secs)
2023-03-28T02:52:59.931684+03:00
Stopping change tracking
2023-03-28T02:52:59.937648+03:00
Errors in file /u02/app/oracle/diag/rdbms/cdbtmbp/CDBTESTDB/trace/CDBTESTDB_pr00_288883.trc:
ORA-28374: typed master key not found in wallet
2023-03-28T02:52:59.980218+03:00
Background Media Recovery process shutdown (CDBTESTDB)
Mount the database and check the status of Wallet :
SQL> select * from gv$encryption_wallet;
INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR KEYSTORE FULLY_BAC CON_ID
---------- -------------------- ---------------------------------------- ------------------------------ -------------------- --------- -------- --------- ----------
2 FILE /u02/app/oracle/admin/CDBTESTDB/tde_wallet OPEN AUTOLOGIN SINGLE NONE NO 1
/
2 FILE OPEN AUTOLOGIN SINGLE UNITED NO 2
2 FILE OPEN AUTOLOGIN SINGLE UNITED NO 3
1 FILE /u02/app/oracle/admin/CDBTESTDB/tde_walletOPEN AUTOLOGIN SINGLE NONE NO 1
/
1 FILE OPEN AUTOLOGIN SINGLE UNITED NO 2
1 FILE OPEN_NO_MASTER_KEY AUTOLOGIN SINGLE UNITED UNDEFINED 3
Solution for the error :
Copy the wallet files from primary to standby same location .After copying files to standby wallet location open the wallet or restart the standby database
SQL> col WRL_PARAMETER for a40
SQL> set lines 200
SQL> select * from gv$encryption_wallet;
INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR KEYSTORE FULLY_BAC CON_ID
---------- -------------------- ---------------------------------------- ------------------------------ -------------------- --------- -------- --------- ----------
2 FILE /u02/app/oracle/admin/CDBTESTDB/tde_wallet OPEN AUTOLOGIN SINGLE NONE NO 1
/
2 FILE OPEN AUTOLOGIN SINGLE UNITED NO 2
2 FILE OPEN AUTOLOGIN SINGLE UNITED NO 3
1 FILE /u02/app/oracle/admin/CDBTESTDB/tde_wallet OPEN AUTOLOGIN SINGLE NONE NO 1
/
1 FILE OPEN AUTOLOGIN SINGLE UNITED NO 2
1 FILE OPEN AUTOLOGIN SINGLE UNITED NO 3
6 rows selected.
Start the recovery for the standby database.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
Alertlog output for the start of recovery
2023-03-28T03:06:57.799247+03:00
Attempt to start background Managed Standby Recovery process (CDBTESTDB)
Starting background process MRP0
2023-03-28T03:06:57.873403+03:00
MRP0 started with pid=104, OS id=386454
2023-03-28T03:06:57.875735+03:00
Background Managed Standby Recovery process started (CDBTESTDB)
2023-03-28T03:07:03.042528+03:00
Starting single instance redo apply (SIRA)
Started logmerger process
2023-03-28T03:07:03.331504+03:00
.... (PID:374004): Managed Standby Recovery starting Real Time Apply
2023-03-28T03:07:03.403535+03:00
max_pdb is 3
2023-03-28T03:07:03.774363+03:00
Reconfiguration started (old inc 4, new inc 6)
List of instances (total 2) :
1 2
My inst 1
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
2023-03-28T03:07:03.802942+03:00
LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived, skipped 0
2023-03-28T03:07:03.803043+03:00
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived, skipped 0
Set master node info
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Reconfiguration complete (total time 0.2 secs)
2023-03-28T03:07:05.144459+03:00
Parallel Media Recovery started with 8 slaves
2023-03-28T03:07:05.283038+03:00
Stopping change tracking
PR00 (PID:387691): Media Recovery Waiting for T-2.S-19023 (in transit)
2023-03-28T03:07:05.382641+03:00
Recovery of Online Redo Log: Thread 2 Group 15 Seq 19023 Reading mem 0
Mem# 0: +RECOC1/CDBTESTDB/ONLINELOG/group_15.9715.1132626173
IM on ADG: Start of Empty Journal
IM on ADG: End of Empty Journal
2023-03-28T03:07:05.450190+03:00
PR00 (PID:387691): Media Recovery Log +RECOC1/CDBTESTDB/ARCHIVELOG/2023_03_28/thread_1_seq_18463.26553.1132626331
2023-03-28T03:07:06.212120+03:00
ALTER SYSTEM SET remote_listener='dcbexa7-scan.griffin-domain.net:1521' SCOPE=MEMORY SID='CDBTESTDB';
2023-03-28T03:07:06.216225+03:00
ALTER SYSTEM SET listener_networks='' SCOPE=MEMORY SID='CDBTESTDB';
2023-03-28T03:07:10.605725+03:00
PR00 (PID:387691): Media Recovery Waiting for T-1.S-18464 (in transit)
2023-03-28T03:07:10.612503+03:00
Recovery of Online Redo Log: Thread 1 Group 10 Seq 18464 Reading mem 0
Mem# 0: +RECOC1/CDBTESTDB/ONLINELOG/group_10.35030.1132626159
ConversionConversion EmoticonEmoticon