Create Standby Database Using Dbvisit

Create Dbvisit Configuration in OCI

Obtain DB_UNIQUE_NAME for each Oracle Database machine

First identify correct DB_UNIQUE_NAMES generated by OCI during Oracle Database machine creation:

You can find the information under Oracle Base Database Service menu:

Click on specific machine:

In Database part of the output, you can see the specific DB_UNIQUE_NAME:

Note down DB_UNIQUE_NAME from both machines.

Create Dbvisit Configuration

In Dbvisit Central Console, choose “New Configuration” → “Start with Oracle”

In the “Create New Database Configuration” menu fill in following:

Choose primary machine
Choose a database, that will be synchronized
Choose a standby machine
Choose a staging directory on primary machine for archived logs copied from ASM
Set Unique Database Name according to the DB_UNIQUE_NAME obtained in “Obtain DB_UNIQUE_NAME for each Oracle Database machine” section
Choose a staging directory for newly arrived archived logs to the standby machine
Press the switch, that the standby database will use ASM for datafiles storage
Fill in +ASM1
Choose a Configuration name
Fill in license key
Click Create Configuration button

Copy Wallet from primary to standby

Before creating the standby database, wallets must be the same on primary as well as on standby side.

You can check location of the wallet by running following query:

sqlplus / as sysdba
SQL> show parameter wallet_root

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
wallet_root                          string      /opt/oracle/dcs/commonstore/wa
                                                 llets/TEST01_8nj_iad

Then copy the wallet from primary to standby machine to the directory with DB_UNIQUE_NAME, that matches to the standby machine. Eg.:

scp -rp /opt/oracle/dcs/commonstore/wallets/TEST01_8nj_iad oracle@dbvphoenix.fsdr.dbvisit:/opt/oracle/dcs/commonstore/wallets/TEST01_xhk_iad

Without copying the wallet, creation of standby database will fail.

Create Standby Database

There is no difference between creating Standby database in OCI and other systems.

You can follow this guide how to do that: https://dbvisit.atlassian.net/wiki/spaces/DSMP/pages/3289350145/Create+DR+Database+for+Oracle#2.--Creating-the-Standby-Database---Control-Center-(GUI)