DCS-10045: Validation error encountered: Backup password is mandatory to take OSS backup for non-tde enabled database on Oracle Cloud DB backup


Issue: Post migration, Automatic Backup fails with the following error for non-TDE enabled migrated Oracle Database releases 11.2.0.4 and 12.1.0.2. 


DCS-10045: Validation error encountered: Backup password is mandatory to take OSS backup for non-tde enabled database... 



Solution: 

  1. Find the TDE wallet location.
    The Oracle Cloud Infrastructure provisioned database instance will have following entry in sqlnet.ora.
    ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE) (METHOD_DATA=(DIRECTORY=/opt/oracle/dcs/commonstore/wallets/ tde/$ORACLE_UNQNAME)))
  2. Remove the cwallet.sso file from the wallet location.

For example, /opt/oracle/dcs/commonstore/wallets/tde/$ORACLE_UNQNAME. 


Oracle Database 11g Release 2, do the folowing steps. location. 


Check the wallet status


select * from v$encryption_wallet;


WRL_TYPE

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

WRL_PARAMETER

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

STATUS

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

file

/u01/app/oracle/product/11.2.0.4/dbhome_1/admin/PROD/wallet

OPEN


Close the wallet in the database.
SQL> alter system set wallet close; 


Connect to database using SQL*Plus as sysdba and verify the current wallet 


Open the wallet using the wallet password.

SQL> alter system SET WALLET open IDENTIFIED BY "walletpassword" 


Set the master encryption key.

SQL> alter system set encryption key identified by "walletpassword"


Recreate the autologin SSO file.

orapki wallet create -wallet /opt/oracle/dcs/ commonstore/wallets/tde/$ORACLE_UNQNAME -auto_login


Retry Automatic Backup. 


Oracle Database 12c following steps


SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;

If the STATUS column contains a value of OPEN_NO_MASTER_KEY, you must create and activate the master encryption key. 


Close the wallet in the database.
SQL> alter system set wallet close;

Open the wallet-using password.

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE open IDENTIFIED BY
"walletpassword" CONTAINER=all;

Set the master encryption key. 

SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "walletpassword" with backup; 


Log in to each PDB and run 

SQL> ALTER SESSION SET CONTAINER = PDB_NAME;
SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "walletpassword" with backup;

Create the auto login keystore.
SQL> ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM
KEYSTORE 'path to wallet directory' IDENTIFIED BY "walletpassword"; 


Retry Automatic Backup. 








If you like please follow and comment