Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

Table of Contents
stylenone

1. Introduction

The section of the user guide explains installing Dbvisit Standby MP on AWS EC2 instances. In this guide, we focus on both primary and standby on the AWS. The setup will be a single instance primary database and a single instance standby database on Linux Platform. The data files are stored on a standard filesystem. This is just an example, and it does not limit the possibility of storing the data files on an ASM, using the Windows operating system, or using any supported Oracle platforms that are available on AWS.

...

The next steps that were completed are.

3.1 Oracle Installation

Info

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.

Installing Oracle on both primary and standby. Create a new database on the primary server.

...

Standby Installation: Both Agentmanager agentmanager and control center are installed on the standby server for this example.

...

After installing agentmanager and control center. The web GUI can be accessed using the link https://<control center installed server>server name>:4433

In our case its https://ono.dbv-aws.envbuilder.cubicle-labs.com:4433/

...

The process of zero data loss role reversal is called graceful switchover. The details are discussed here . Below is the image after the switchover process is completed. The new primary is now ono.dbv-aws.envbuilder.cubicle-labs.com and the standby is rima.dbv-aws.envbuilder.cubicle-labs.com . The automated standby update is enabled in the reverse direction and rima’s is getting synced at regular intervals with archivelogs from ono.

...

7. Activation

This option is useful when the primary is unavailable or cannot be accessed at the moment, the standby database is opened read-write mode with resetlogs. The details of this option are discussed here in the user guide.

activate.pngImage Added

All the options and functions that can be performed with onpremise to onpremise configuration, can be performed with cloud to cloud configurations as well. We have discussed only few options above, but it is possible to do all the below.

  1. Test Standby Activation

  2. Test Opening standby read-only

  3. Snapshots

  4. View detailed log gap report

  5. Backup & Send logs

  6. Apply logs

  7. Synchronization

  8. Start/Stop database

  9. Advanced Options