12.2.0.1 wallet

Hi all, the wallet for out 12.2.0.1 database was deleted (inadvertently) and we do not have a backup for it (yes I know that's bad).

I have dropped the encrypted tablespaces and I have dropped the schema that owned all the objects that were in the encrypted tablespaces.

I have tried to:

administer key management create keystore 'wallet path' identified by "password";

worked

administer key management set keystore open identified by "password";

worked

administer key management set key identified by "password" with backup;

failed:

ORA-28374: typed master key not found in wallet

Found in this note 1541818.1:

As of 12c it is not allowed to remove the wallet even no encrypted object has been created.  Any attempt to re-key another wallet will generate the error "ORA-28374".