Database Security Products (MOSC)

MOSC Banner

DB Clone with TDE Column Encryption

We're looking to use TDE Column encryption with a local wallet for production and clone the production database to lower environments using file level snapshots (not RMAN).

Ideally, we would like to
1. clone the DB to a staging environment on a different host from production

2. Open the staging database with credentials to access the encrypted data

3. Update the values in the encrypted columns to test/dummy data

4. Turn off TDE encryption

5. Clone the staging database to DEV/TEST/QA databases as needed.

What is the best way to manage the wallet access in the staging environment?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center