Lift & shift - Oracle 19c with TDE Column Level Encryption
Hi,
- A 19c database with column-level TDE enabled is backed up using RMAN.
- The database is imported into a new environment using RMAN DUPLICATE command.
- In both source and target environments are Multi-Tenant (1 PDB) & ALL_ENCRYPTED_COLUMNS shows that many user table columns are encrypted.
- In the target environment have not created any wallet or keystore yet.
- In Source, keystore_configuration=FILE is the value for TDE.
In this case, How efficiently can proceed to implement TDE in Target.
Option a. Can create new Wallet & Key Store in Target.
- In this case, I believe I need to encrypt all the columns which are already showing encrypted.
Tagged:
0