1. Introduction

In this section, we will see how to Configure Dbvisit Standby Multiplatform on ODA machines. We are using the Primary database on-premise Linux el7 File system and the Standby database on ODA ASM storage for demonstration purposes.

	Primary	Standby
Machine Name	odatest12	czoda
Type	On-premise	X6-2M
OS	EL7	EL7
Oracle Version	Oracle 19.13.0.0	Oracle 19.13.0.0
Databases	TESTDBV	TESTDBV
CDB / Non-CDB	CDB	CDB
DB Storage	FS	ASM

The primary database TESTDBV is already configured and running on the server odatest12.

We have not shown Oracle installation here since its out of scope. The installation can be performed the same way as any on-premise installation. Please refer to the Oracle documentation installation guide based on the version you would like to install.

[oracle@odatest12 install]$ ps -ef | grep pmon
oracle    1937  2537  0 01:00 pts/0    00:00:00 grep --color=auto pmon
oracle   29636     1  0 Apr30 ?        00:00:07 ora_pmon_TESTDBV

We will see in detail how to configure the standby database on ODA using Dbvisit standby v11.7.0.
For that first, we need to create an empty database using ODA with the same db_name and db_unique_name as that of primary. This will register your standby database in ODA. Once registered, delete standby database-related files. We will use Dbvisit Standby v11.7.0 to create the standby database in ODA.

2. Create a Database on ODA

Login to management URL

Overview of the system information

Go to the Database tab and click on Create Database

Fill in the details here and click on Create. Please provide the DB Name as TESTDBV same as primary db_name. You can either create a new Oracle home or use an existing Home. Storage type can be ASM or ACFS. Here we have chosen ASM

Database TESTDBV complete.

Next step, Shut down the standby database and remove the database-related files. Here we are removing datafiles under ASM disk group +DATA and recovery files under +RECO

[oracle@czoda ~]$ sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 24 07:17:12 2024
Version 19.13.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Enter user-name: /as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

[grid@czoda ~]$ . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base has been set to /u01/app/grid
[grid@czoda ~]$ asmcmd -p
ASMCMD [+] > ls
DATA/
RECO/

ASMCMD [+DATA] > rm -rf TESTDBV
ASMCMD [+RECO] > rm -rf TESTDBV
ASMCMD [+RECO] > exit

3. Dbvisit standby installation

Before installation, please ensure necessary Dbvisit ports are open(7890, 5533,4433) for communication.

Please refer here for more information

3.1 Installation

Please refer here for detailed instructions on Dbvisit installation.

Primary server: odatest12: Installing dbvagentmanager

Standby Server:czoda : Installing dbvagentmanager and dbvcontrol

[oracle@odatest12 install]$ ./install-agent-v11.7.0
+----------------------------------------------------------------------+
|          ____  _                  _ _           __  __ ____          |
|         / ___|| |_ __ _ _ __   __| | |__  _   _|  \/  |  _ \         |
|         \___ \| __/ _' | '_ \ / _' | '_ \| | | | |\/| | |_) |        |
|          ___) | || (_| | | | | (_| | |_) | |_| | |  | |  __/         |
|         |____/ \__\__,_|_| |_|\__,_|_.__/ \__, |_|  |_|_|            |
|          Copyright 2024                   |___/   By Dbvisit         |
+----------------------------------------------------------------------+

Welcome to Dbvisit StandbyMP setup version v11.7.0.

? Please carefully read the end-user license agreement at https://dbvisit.com/eula. Do you agree to the terms of this agreement? Yes
? Which directory should the software be installed into? /opt/dbvisit

- - - You are now configuring the Dbvisit StandbyMP Agent - - -

The Agent will listen on the following discovered addresses:
 -  127.0.0.1
 -  10.0.2.15
 -  10.1.1.227
? Agent File Transfer Port: 7890
? Fully Qualified Domain Name for this host: odatest12.qadev.cz
? Fully Qualified Domain Name for the Control Center: czoda
? Agent Communications Port: 5533
Each Dbvisit StandbyMP Agent and the Dbvisit StandbyMP Control Center must
be configured with the same passphrase. This is how we know that they are all
intended to be part of the same system. Please specify a strong passphrase - we
suggest at least 12 characters, containing at least 2 numbers and 2 symbols.
? Passphrase: *******
? Confirm Passphrase: *******

- - - Dbvisit StandbyMP Agent configuration finished - - -


- - - Ready to perform installation - - -

? Do you wish to proceed with the setup using the supplied configuration options? Proceed with setup

- - - Performing installation - - -

Copying software files to '/opt/dbvisit'...
Writing Agent configuration file '/opt/dbvisit/standbymp/conf/dbvagentmanager.ini'...

- - - File creation complete - - -


- - - Configuration Summary - - -

Install Directory:                                  /opt/dbvisit
Fully Qualified Domain Name for this host:          odatest12.qadev.cz
Fully Qualified Domain Name for the Control Center: czoda
Agent Communications Port:                          5533
Agent File Transfer Port:                           7890

- - - Installation Summary - - -

The following actions have been performed:
 -  Installed Dbvisit StandbyMP Agent software into: /opt/dbvisit/standbymp
 -  Agent settings are available in the configuration file: /opt/dbvisit/standbymp/conf/dbvagentmanager.ini
 -  Generated new security certificates in: /opt/dbvisit/standbymp/certificates

- - - INSTALLATION SUCCESSFUL - - -


To enable the installed Dbvisit StandbyMP components to run as system services, you will need to execute some commands as the "root" user in order to complete the setup.

To start the system service(s), you can run:
	sudo /opt/dbvisit/standbymp/bin/dbvagentmanager service start

[oracle@odatest12 install]$ ps -ef | grep dbv
oracle   17802     1  4 06:29 ?        00:00:00 /opt/dbvisit/standbymp/bin/dbvagentmanager service run
oracle   17823  2537  0 06:29 pts/0    00:00:00 grep --color=auto dbv
[oracle@odatest12 install]$

Standby server

[oracle@czoda install]$ ./install-agent-v11.7.0
+----------------------------------------------------------------------+
|          ____  _                  _ _           __  __ ____          |
|         / ___|| |_ __ _ _ __   __| | |__  _   _|  \/  |  _ \         |
|         \___ \| __/ _' | '_ \ / _' | '_ \| | | | |\/| | |_) |        |
|          ___) | || (_| | | | | (_| | |_) | |_| | |  | |  __/         |
|         |____/ \__\__,_|_| |_|\__,_|_.__/ \__, |_|  |_|_|            |
|          Copyright 2024                   |___/   By Dbvisit         |
+----------------------------------------------------------------------+

Welcome to Dbvisit StandbyMP setup version v11.7.0.

? Please carefully read the end-user license agreement at https://dbvisit.com/eula. Do you agree to the terms of this agreement? Yes
? Which directory should the software be installed into? /opt/dbvisit

- - - You are now configuring the Dbvisit StandbyMP Agent - - -

The Agent will listen on the following discovered addresses:
 -  127.0.0.1
 -  10.100.100.250
 -  192.168.17.2
 -  192.168.16.24
 -  192.168.122.1
? Agent File Transfer Port: 7890
? Fully Qualified Domain Name for this host: czoda.dbvisit.cz
? Fully Qualified Domain Name for the Control Center: czoda
? Agent Communications Port: 5533
Each Dbvisit StandbyMP Agent and the Dbvisit StandbyMP Control Center must
be configured with the same passphrase. This is how we know that they are all
intended to be part of the same system. Please specify a strong passphrase - we
suggest at least 12 characters, containing at least 2 numbers and 2 symbols.
? Passphrase: *******
? Confirm Passphrase: *******

- - - Dbvisit StandbyMP Agent configuration finished - - -


- - - Ready to perform installation - - -

? Do you wish to proceed with the setup using the supplied configuration options? Proceed with setup

- - - Performing installation - - -

Copying software files to '/opt/dbvisit'...
Writing Agent configuration file '/opt/dbvisit/standbymp/conf/dbvagentmanager.ini'...

- - - File creation complete - - -


- - - Configuration Summary - - -

Install Directory:                                  /opt/dbvisit
Fully Qualified Domain Name for this host:          czoda.dbvisit.cz
Fully Qualified Domain Name for the Control Center: czoda
Agent Communications Port:                          5533
Agent File Transfer Port:                           7890

- - - Installation Summary - - -

The following actions have been performed:
 -  Installed Dbvisit StandbyMP Agent software into: /opt/dbvisit/standbymp
 -  Agent settings are available in the configuration file: /opt/dbvisit/standbymp/conf/dbvagentmanager.ini
 -  Generated new security certificates in: /opt/dbvisit/standbymp/certificates

- - - INSTALLATION SUCCESSFUL - - -


To enable the installed Dbvisit StandbyMP components to run as system services, you will need to execute some commands as the "root" user in order to complete the setup.

To start the system service(s), you can run:
	sudo /opt/dbvisit/standbymp/bin/dbvagentmanager service start

[oracle@czoda install]$ ./install-control-v11.7.0
+----------------------------------------------------------------------+
|          ____  _                  _ _           __  __ ____          |
|         / ___|| |_ __ _ _ __   __| | |__  _   _|  \/  |  _ \         |
|         \___ \| __/ _' | '_ \ / _' | '_ \| | | | |\/| | |_) |        |
|          ___) | || (_| | | | | (_| | |_) | |_| | |  | |  __/         |
|         |____/ \__\__,_|_| |_|\__,_|_.__/ \__, |_|  |_|_|            |
|          Copyright 2024                   |___/   By Dbvisit         |
+----------------------------------------------------------------------+

Welcome to Dbvisit StandbyMP setup version v11.7.0.

? Please carefully read the end-user license agreement at https://dbvisit.com/eula. Do you agree to the terms of this agreement? Yes
? Which directory should the software be installed into? /opt/dbvisit

- - - You are now configuring the Dbvisit StandbyMP Control Center - - -

The Control Center will listen on the following discovered addresses:
 -  127.0.0.1
 -  10.100.100.250
 -  192.168.17.2
 -  192.168.16.24
 -  192.168.122.1
? Control Center Web Server Port: 4433
? Agent Communications Port: 5533
Each Dbvisit StandbyMP Agent and the Dbvisit StandbyMP Control Center must
be configured with the same passphrase. This is how we know that they are all
intended to be part of the same system. Please specify a strong passphrase - we
suggest at least 12 characters, containing at least 2 numbers and 2 symbols.
? Passphrase: *******
? Confirm Passphrase: *******

- - - Dbvisit StandbyMP Control Center configuration finished - - -


- - - Ready to perform installation - - -

? Do you wish to proceed with the setup using the supplied configuration options? Proceed with setup

- - - Performing installation - - -

Copying software files to '/opt/dbvisit'...
Writing Control Center configuration file '/opt/dbvisit/standbymp/conf/dbvcontrol.ini'...

- - - File creation complete - - -


- - - Configuration Summary - - -

Install Directory:              /opt/dbvisit
Control Center Web Server Port: 4433
Agent Communications Port:      5533

- - - Installation Summary - - -

The following actions have been performed:
 -  Installed Dbvisit StandbyMP Control Center software into: /opt/dbvisit/standbymp
 -  Control Center settings are available in the configuration file: /opt/dbvisit/standbymp/conf/dbvcontrol.ini
 -  Generated new security certificates in: /opt/dbvisit/standbymp/certificates

- - - INSTALLATION SUCCESSFUL - - -


To enable the installed Dbvisit StandbyMP components to run as system services, you will need to execute some commands as the "root" user in order to complete the setup.

To install the system service(s), you can run, substituting the name of the user to run as if it is different from the current user:
	sudo /opt/dbvisit/standbymp/bin/dbvcontrol service install --user oracle
To start the system service(s), you can run:
	sudo /opt/dbvisit/standbymp/bin/dbvcontrol service start

[oracle@czoda install]$ ps -ef | grep dbv
oracle   95964     1  2 06:27 ?        00:00:00 /opt/dbvisit/standbymp/bin/dbvcontrol service run
oracle   97265     1  2 06:27 ?        00:00:00 /opt/dbvisit/standbymp/bin/dbvagentmanager service run
oracle   97527 65682  0 06:27 pts/3    00:00:00 grep --color=auto dbv

3.2 Create Dbvisit configuration

Login to Console

Click on New Configuration

3.Select the primary host

Choose the database(1) TESTDBV, chose the standby host(2) czoda, Dbvisit archsource (3) and archdest(4) locations, choose Yes(6) ASM, and enter ASM instance name (7), Apply the license key(8) and create the configuration(9)

DDC configuration TESTDBV is created

3.3 Create DR database

Choose the configuration, select Setup Disaster Recovery

Choose the temporary backup location on primary and standby to hold full Compressed RMAN backup of the primary database.

Here our primary is Filesystem, so we need to verify and set db_create_file_dest(2), db_recover_file_dest(3), db_file_name_convert(3)

Check the progress and task is completed

3.4. Check log gap report

4. Graceful switchover

This is a zero data loss role reversal process performed in a controlled environment. Please refer here for detailed information. After the switchover, the primary is now czoda and standby is odatest12

5. Activation

The Activate failover task is performed when primary is unavailable and standby is activated in read/write mode with reset logs. Please refer here for detailed information

Configuring Oracle Database Appliance ( ODA ) and Dbvisit Standby