Replicate & DataGuard with VIP failover

How to normalize Dbvisit Standby configuration with Oracle DataGuard and/or Dbvisit Standby using VIP failover.

Manual VIP failover is done by simple remote ssh by any other 3rd party cluster software is preferred to create HA (VCS, Oracle CRS, Linux-HA, Heartbeat, ...)

Pre-requisites

Node 1 - dbvlin216.dbvisit.co.nz DB_UNIQUE_NAME SRCDB, SID SRCDB
Node 2 - dbvlin217.dbvisit.co.nz DB_UNIQUE_NAME SRCDB_STBY, SID SRCDB

Oracle RDBMS installed
Oracle DataGuard or Dbvisit Standby installed https://oracle-base.com/articles/12c/data-guard-setup-using-broker-12cr1

OS VIP configuration

VIP1 - dbvlin-dg-vip.dbvisit.co.nz (this VIP will be used by dedicated Oracle listener and running always on primary node)
VIP2 - dbvlin-sb-vip.dbvisit.co.nz (this VIP will be used by MINE process and running always on standby node)

#/etc/hosts

172.16.1.176    dbvlin216.dbvisit.co.nz dbvlin216
172.16.1.177    dbvlin217.dbvisit.co.nz dbvlin217
172.16.1.2    dbvlin-dg-vip.dbvisit.co.nz dbvlin-dg-vip
172.16.1.4    dbvlin-sb-vip.dbvisit.co.nz dbvlin-sb-vip

#/etc/sysconfig/network-scripts/ifcfg-eth0:1

DEVICE="eth0:1"
ONBOOT=no
BOOTPROTO=static
IPADDR=172.16.1.2
NETMASK=255.255.255.0
GATEWAY=172.16.1.1
TYPE=Ethernet
NM_CONTROLLED="yes"
IPV6INIT="no"

#/etc/sysconfig/network-scripts/ifcfg-eth0:2

DEVICE="eth0:2"
ONBOOT=no
BOOTPROTO=static
IPADDR=172.16.1.4
NETMASK=255.255.255.0
GATEWAY=172.16.1.1
TYPE=Ethernet
NM_CONTROLLED="yes"
IPV6INIT="no"

User Equivalence

Set user equivalence on dbvlin216 & dbvlin217 for users oracle and root

https://oracle-base.com/articles/linux/user-equivalence-configuration-on-linux#manual

Oracle Stack Configuration

Listeners

Static listener listener_vip will be reallocated together with VIP dbvlin-dg-vip during switchover/failover operation

#dbvlin216

#dbvlin217

Tnsnames

tnsnames.ora file is common on all (source & target servers)

Redo & Archive Logs Location Unification

We need to have the same name and physical location of online redo and archive logs on both primary & standby site. Database are configured as follows

log_archive_dest_1 is local and pointed to FRA
log_archive_dest_2 is used by DG Broker to and pointed to standby database
log_archive_dest_3 is local and will be used by MINE process as the absolute path of archive log will be the same on primary and standby using following format: /u01/app/oracle/oradata/SRCDB/archivelogs/%t_%s_%r.dbf

SRCDB

Dbvisit Replicate configuration

Use SRCDB_DG as the source database SID (the same SID will be used as the target in this configuration)

Use dbvlin-sb-vip.dbvisit.co.nz as the interface of MINE process.

Set REDO_READ_METHOD=ARCHONLY before starting processes.

Switchover

Custom shell script is used from switchover operation

Example output