...
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 Standby database
Choose the configuration, select Setup Disaster Recovery
...
Check the progress and task is completed
...
4. Check log gap report
...
5. Graceful switchover
...
6. Activation
...