data guard - Root Fan

October 20, 2021June 9, 2024

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.

September 26, 2021June 9, 2024

Oracle 19c Data Guard Configuration Step by Step

If you want to setup an Oracle 19c Data Guard then you need to have 2 servers.

A physical Data Guard is the default Oracle Data Guard configuration.

Provides a physically identical copy of the primary database, with on-disk database structures that are identical to the primary database on a block-for-block basis. The database schema, including indexes, are the same.

A physical standby database is kept synchronized with the primary database, through Redo Apply, which recovers the redo data received from the primary database and applies the redo to the physical standby database.