Enable before-image encryption for a Replication-enabled target database

To enable before-image encryption on the target database, you must recreate the target database from the source database.

Follow these steps to enable before-image encryption on the Replication-enabled target database:

  1. Shut down the source database and the target database.

    Use the following command for each database:

    proshut db-name
  2. Disable replication on each database.

    Use the following command to disable replication on each database: 

    DSRUTIL db-name -C DisableSiteReplication { source | target }
  3. If before-image encryption is not already enabled on the source database, enable it by using the following command: 
    proutil source-db-name -C enableencryption -biencryption enable

    When you enable before-image encryption, the before image is automatically truncated.

  4. Enable the database as a Replication source database using the following command: 
    proutil source-db-name -C enableSiteReplication source
  5. Back up the database using the following command: 
    probkup source-db-name source-db-backup-name
  6. Copy the backup volume or volumes to the target computer.
  7. Copy the source database structure file (source-db-name.st) to the target database directory on the secondary computer and rename it to match the target database name. Make any modifications necessary to the file to match the configuration of the target database.
  8. Copy the source database key store (source-db-name.ks) to the target database directory and rename it with the name of the target database (target-db-name.ks).

    The source database key store was created when you enabled the database for transparent data encryption.

  9. Restore the target database from the source backup volume or volumes using the following command: 
    prorest target-db-name source-db-backup-name
  10. Enable the database as a target database using the following command: 
    proutil target-db-name -C enableSiteReplication target
  11. Configure the Replication property files for both the source and target databases.
  12. Start both databases.