Step by Step Data Guard Broker Configuration in Oracle 19c

If you want to manage a data guard you can use a 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”

Oracle 19c Logical Standby Configuration Step by Step

To create an Oracle logical standby, you need to first have a physical data guard.

Make sure to read this post first and then come back.

A logical standby contains the same logical information as the production database, although the physical organization and structure of the data can be different.

The logical standby database is kept synchronized with the primary database through SQL Apply, which transforms the data in the redo received from the primary database into SQL statements and then executes the SQL statements on the standby database.

Continue reading “Oracle 19c Logical Standby Configuration Step by Step”