fbpx

Category: Oracle

Posted on

Implementing Transparent Data Encryption in Oracle 19c Step by Step

bird s eye view photography of road in the middle of desert

Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables and tablespaces.

After the data is encrypted, this data is transparently decrypted for authorized users or applications when they access this data. TDE helps protect data stored on media (also called data at rest) in the event that the storage media or data file is stolen.

In this guide I will show you how to implemente Oracle TDE on RAC, but you should be able to modify the procedure for a standalone database.

Continue reading “Implementing Transparent Data Encryption in Oracle 19c Step by Step”
Posted on

Step by Step Data Guard Broker Configuration in Oracle 19c

pexels-photo-2166711.jpeg

If you want to manage an Oracle data guard easily, then you should use a data guard broker.

The Oracle Data Guard broker is a distributed management framework that automates and centralizes the creation, maintenance, and monitoring of Data Guard configurations.

In my configuration, I have already created a Data Guard. You can check this post to see how I created it.

BCN is the primary database and PARIS is the standby database.

In the commands below you can remove the sid=’*’ if you don’t have a RAC database and you should be good to go.

Continue reading “Step by Step Data Guard Broker Configuration in Oracle 19c”