ODA Bare Metal Systems

Owned by Shalini Anbu
Last updated: May 07, 2024 by Jakub Sejba
12 min read

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.

 

Primary

Standby

 

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.

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.

[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 v11.7.0 to create the standby database in ODA.

2. Create a Database on ODA

  1. Login to management URL

oda-login.png

  1. Overview of the system information

oda01.png

 

  1. Go to the Database tab and click on Create Database

  1. Fill in the details here and click on Create. Please provide the DB Name as TESTDBV same as primary db_name. You can either create a new Oracle home or use an existing Home. Storage type can be ASM or ACFS. Here we have chosen ASM

  1. Database TESTDBV complete.

 

 

  1. Next step, Shut down the standby database and remove the database-related files. Here we are removing datafiles under ASM disk group +DATA and recovery files under +RECO

[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.

Primary server: odatest12: Installing dbvagentmanager

Standby Server:czoda : Installing dbvagentmanager and dbvcontrol
Dbvisit Standby Version: 11.7.0

[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

 

Standby server

 

3.2 Create Dbvisit configuration

  1. Login to Console

  1. Click on New Configuration

3. Select the primary host

  1. 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)

  1. DDC configuration TESTDBV is created

3.3 Create DR 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 db_create_file_dest(2), db_recover_file_dest(3), db_file_name_convert(3)

Note that for this example, the primary system is a Linux machine, not ODA. If the primary system is ODA, few other ora init parameters need to be changed too. Please navigate to Create DR Database for Oracle | 4. Create Standby Database on Oracle Database Appliance (ODA) for more details.

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

Â