| Table of Contents | ||
|---|---|---|
|
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.
...
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
...
| 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.
...
| 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
...
Click on New Configuration
...
DDC configuration TESTDBV is created
...
3.3 Create DR database
Choose the configuration, select Setup Disaster Recovery
...
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
...