Step by Step Data Guard Broker Configuration in Oracle 19c


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”

Oracle 19c Logical Standby Configuration Step by Step

body of water under blue and white skies

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”