Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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:

  1. Choose primary machine

  2. Choose a database, that will be synchronized

  3. Choose a standby machine

  4. Choose a staging directory on primary machine for archived logs copied from ASM

  5. Set Unique Database Name according to the DB_UNIQUE_NAME obtained in “Obtain DB_UNIQUE_NAME for each Oracle Database machine” section

  6. Choose a staging directory for newly arrived archived logs to the standby machine

  7. Press the switch, that the standby database will use ASM for datafiles storage

  8. Fill in +ASM1

  9. Choose a Configuration name

  10. Fill in license key

  11. Click Create Configuration button

Copy Wallet fro primary to standby

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

You can check locaction 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)

  • No labels