Problema:
No meu ambiente de testes usando Oracle Data Guard e com algumas tablespaces com TDE me deparei com o seguinte erro:
PR00 (PID:396056): MRP0: Background Media Recovery terminated with error 28365
2024-03-15T03:12:42.419136+00:00
Errors in file /u01/app/oracle/diag/rdbms/thdr/thdr/trace/thdr_pr00_396056.trc:
ORA-28365: wallet is not open
2024-03-15T03:12:43.000571+00:00
Recovery interrupted!
Recovered data files to a consistent state at change 32232590
Stopping change tracking
Solução:
Verifiquei a wallet na base de dados standby e estava fechada.
set lines 300
col name for a15
col wrl_type for a10
col status for a30
select p.con_id, p.name, p.open_mode, ew.wrl_type, ew.wallet_type, ew.status
from v$pdbs p join v$encryption_wallet ew on (ew.con_id = p.con_id)
order by p.con_id;
CON_ID NAME OPEN_MODE WRL_TYPE WALLET_TYPE STATUS
---------- --------------- ---------- ---------- -------------------- ------------------------------
2 PDB$SEED READ ONLY FILE UNKNOWN CLOSED
3 THPDB MOUNTED FILE UNKNOWN CLOSED
SQL> show parameter tde
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
one_step_plugin_for_pdb_with_tde boolean FALSE
tde_configuration string KEYSTORE_CONFIGURATION=FILE
Abrir a wallet e o standby voltou a sincronizar:
SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY senha$00;
keystore altered.
Voce pode deixar a keystore como auto-login, assim sempre que o banco de dados for reiniciado a wallet vai estar aberta.
SQL> ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE '/u01/app/oracle/admin/THDR/wallet/tde/' identified by senha$00;
keystore altered.
select p.con_id, p.name, p.open_mode, ew.wrl_type, ew.wallet_type, ew.status
from v$pdbs p join v$encryption_wallet ew on (ew.con_id = p.con_id)
order by p.con_id;
SQL> SQL> SQL> SQL> 2 3
CON_ID NAME OPEN_MODE WRL_TYPE WALLET_TYPE STATUS
---------- --------------- ---------- ---------- -------------------- ------------------------------
2 PDB$SEED READ ONLY FILE AUTOLOGIN OPEN
3 THPDB MOUNTED FILE AUTOLOGIN OPEN
Comentários