...

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.

Info
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.

Code Block
[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.

Table of Contents

style	none

2. Create a Database on ODA

Login to management URL

Image Modified

Overview of the system information

Image Modified

Go to the Database tab and click on Create Database

Image Modified

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

Image Modified

Database TESTDBV complete.

Image Modified

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

Code Block

[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
Dbvisit Standby Version: 11.7.0

Code Block

[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

Code Block

[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

Code Block

[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

Code Block

[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

Code Block

[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

Image Modified

Click on New Configuration

Image Modified

3. Select the primary host

Image Modified

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)

Image Modified

DDC configuration TESTDBV is created

Image Modified

3.

...

3 Create

...

DR database

Choose the configuration, select Setup Disaster Recovery

Image Modified

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

Image Modified

...

Image Modified

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)

Image Modified

...

Check the progress and task is completed

...

4. Check log gap report

...

5. Graceful switchover

...

Note
Note that for this example, the primary system is a Linux machine, not ODA. If the primary system is ODA, few other ora init parameters need to be changed too. Please navigate to https://dbvisit.atlassian.net/wiki/spaces/DSMP/pages/3289350145/Create+DR+Database+for+Oracle#4.-Create-Standby-Database-on-Oracle-Database-Appliance-(ODA) for more details.

Image Added

The task is finished and the standby database is created successfully

Image Added

3.4. Check log gap report

Image Added

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

Image Added

5. Activation

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

Image Modified

Versions Compared

Old Version 2

New Version Current

Key

1. Introduction

2. Create a Database on ODA

3. Dbvisit standby installation

3.1 Installation

3.2 Create Dbvisit configuration

3.

3 Create

DR database

4. Check log gap report

5. Graceful switchover

3.4. Check log gap report

4. Graceful switchover

5. Activation

Page Comparison

Versions Compared

Old Version 2

New Version Current

Key

1. Introduction

2. Create a Database on ODA

3. Dbvisit standby installation

3.1 Installation

3.2 Create Dbvisit configuration

3.

3 Create

DR database

4. Check log gap report

5. Graceful switchover

3.4. Check log gap report

4. Graceful switchover

5. Activation