11.2.0.3
I have been running some tests. I want to see if my understanding of this is ok. I think we need to make sure to back up the wallet, because if it is gone, we will lose data.
We are using the following command to create a wallet:
ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY <mypassword>
This creates the wallet. I then create tables with the following syntax:
create table test (
mytest varchar2(30) encrypt using 'AES256' no salt);
Works fine.
Test Case
1. rename the wallet.
2. try to re-create the wallet with the same password.
ERROR: ORA-28362: master key not found
3. tried querying the table next and got the same error.
No data was entered into the table. This tells me that we need the original wallet if something happens to it and it cannot be replaced, we cannot recreate a new one and retrieve data.
is this correct? So it is critical to back this up with an OS backup? Or will RMAN handle it for me?