Friday , October 7 2022

Oracle Data Guard Installation

In today’s article, I will talk about Oracle Data Guard Installation.

I used Oracle Linux 7.6 and Oracle Database 19C while installing.

There are conditions that must be met in order to install Oracle Data Guard. These are as follows:

Oracle database must be Enterprise edition.
Both servers must have the same operating system.
Oracle Software must be the same version on both servers.

After these conditions are met, the necessary steps for installation can be started.

First, we install Oracle Software on the Standby server. Then we create and start the listener service using “netca”.

We write the information of the servers in the “/etc/hosts” file in the Primary and Standby databases.

Settings to be made on the Primary Server:

1. The archive log mode of the database must be turned on. We check if it is open with the following command.

If the database is not in archive mode, we follow the steps below to put the database in archive mode.

We close the database consistently and open it in mount mode.

We put the database in archive mode and open the database.

2. We log all transactions in the database with the following command.

3. In the Primary, we learn the values of the “DB_NAME” and “DB_UNIQUE_NAME” parameters.

4. We set the “LOG_ARCHIVE_CONFIG” parameter in the database.
First we write Primary database DB_UNIQUE_NAME and then we write standby database DB_UNIQUE_NAME.

5. We configure the “remote archive log” option in the database.

6.We set the parameters “LOG_ARCHIVE_FORMAT”, “LOG_ARCHIVE_MAX_PROCESSES”, “REMOTE_LOGIN_PASSWORDFILE” in the database as follows.

7. Considering the switchover situation, we set the following parameters so that the database is ready for migration, and then we restart the database.

8. We edit the tnsnames.ora file on both the primary and standby server. We write standby information to the primary server and primary server information to the standby server.

9. For the switchover situation, we create a page for the standby database from the redologs in the primary database. (It is not mandatory.)

10. We take a backup of the primary database, including archive logs.

11. We create control file and pfile for standby database.

12. We make arrangements for the standby database in the created initorcl_stby.ora file.

Settings to be made in Standby Server:

1.We create the necessary directories on the standby server.

2.Rman backup, archive logs, created control file, pfile and password file taken on the primary server are copied to the standby server using scp.

3. The Listener restarts.

4. We return from the backup copied from the primary database on the server.

5. After the necessary adjustments are made on both the primary and standby servers, we start the log apply process.

6. We can learn whether the archive log files are applied to the standby database with the following command.

 

 

 

Melek Durdu
Author: Melek Durdu

About Melek Durdu

Leave a Reply

Your email address will not be published. Required fields are marked *