Skip to main content
Delphix

How to Transition to Oracle Transparent Data Encryption (TDE) (KBA1035)

 

KBA

KBA# 1035

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

4.3

4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0

4.2

4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1

How to Task

This operation can involve exporting and importing data from the various tablespaces in the production database.

Use Delphix version 4.2.x or higher.

Prerequisites

Follow all Oracle documentation.

To Transition to Oracle Transparent Data Encryption (TDE) - (Delphix Steps)

Complete the following procedure:

  1. Verify that space is available on the Delphix Engine before moving forward with the Oracle portion.
  2. Note

    Note:

    In the least likely outcome, all the blocks will be changed in the database and will take up new space on the Delphix Engine.

     

  3. Disable the dSource(s). Consult the Delphix documentation for your release to find instructions  on Enabling and Disabling Oracle dSources.
  4. Complete the steps as outlined by Oracle, which may include:
    1. Disable the database archive log.
    2. Export the database.
    3. Drop all database tablespaces. 
    4. Build tablespaces with encryption. 
    5. Import the data back.
    6. Enable archive log mode.
  5. Enable the dSource. Consult the Delphix documentation for your release to find instructions  on Enabling and Disabling Oracle dSources.

  6.  Do a full SnapSync of the dSource (How to force a full backup). 

    Note

    Note:

    In Delphix Release 5.3.4.0 and later, this functionality is available in the UI. Consult the Delphix documentation for your release for instructions on Force Full Backup.
    This will perform a FULL backup on a dSource and as such may take some time. As such, you may want to also perform a Double Sync.  For further information on Double Sync, consult the Delphix documentation for instructions on Using the Double Sync option for Oracle SnapSync.

     

  7. A post (or pre) step is to install/copy the wallet and execute the appropriate setup on the target server's ORACLE_HOMEs as required to provision virtual databases (VDBs) to those Target Environments.

Related Articles

The following articles may provide more information or related information to this article: