...
In this section, we will see how to Configure Dbvisit standby Standby Multiplatform on ODA machines. For demonstration purposes, we 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.
| 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 Multiplatform v11.7.0 to create the standby database in ODA.
...
Fill in the details here and click on Create. Please provide the Db DB Name as TESTDBV same name as primary db_name. You can either choose to 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 diskgroup disk group +DATA and recovery files under +RECO
...
3. Dbvisit standby installation
3.1 Installation
Please refer to the user guide for detailed instructions on Dbvisit installation.
Please make sure 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 : Install dbvagentmagerserver: odatest12: Installing dbvagentmanager
Standby : Install dbvagentmanger Server:czoda : Installing dbvagentmanager and dbvcontrol
| 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 |
...
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.4 Create
...
Standby 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 convert parametersdb_create_file_dest(2), db_recover_file_dest(3), db_file_name_convert(3)
...
Check the progress and task is completed
...
4.
...
Check log gap report
...
5.
...
Graceful switchover
...
6.
...
Activation
...