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 and the Standby database on ODA 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
Dbvisit Standby Version: 11.7.0
[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)
The task is finished and the standby database is created successfully
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 the primary is unavailable. The standby is activated in read/write mode with reset logs. Please refer here for detailed information
