In the previous article, we have seen basics about the Architecture of Oracle Dataguard.

Oracle Dataguard Architecture

We can configure DataGuard with main three stages.

  1. Preparing Primary Database.
  2. Setting up net services between primary and standby database.
  3. Creating Standby Database.

In this article, we will set the parameters on the primary database. We will see parameter setting of Primary database necessary for standby database configuration.

Primary DB Standby DB Primary DB Server IP Standby DB Server IP
testdb std_testdb

Step 1: Your Database must be in archive log mode.

Step 2: Check if a database is enabled for force logging or not. If not enabled, enable it.

Step 3: Set Initialization parameters.

For this configuration, I have set db_name and db_unique_name same, we can change it according to requirement.

Set Initialization parameters remote_login_passwordfile must be set to EXCLUSIVE.

Step 4: Set following parameters on Production to configure data guard :

The primary database is now configured for DataGuard creation.

Here we can see I have set log_archive_dest_4 for Standby Role. That will help us in switchover scenario.

In next article, we will see Oracle Net Configuration for Data Guard.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.