Configuring Active Data Guard (ADG) using Oracle Database 12c (With Container Database and Pluggable Databases) - Part-5

Setting Threshold & RedoRoutes Properties for Primary Database, Standby Database & FAR SYNC Database

[oracle@dbnode]$ export ORACLE_SID=cdb
[oracle@dbnode]$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome
[oracle@dbnode]$ cd /u01/app/oracle/product/12.1.0/dbhome/bin
[oracle@dbnode]$ dgmgrl
DGMGRL for Linux: Version 12.1.0.1.0 - 64bit Production
Copyright (c) 2000, 2012, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/oracle
Connected as SYSDG.

DGMGRL> disable fast_start failover;
Disabled.

DGMGRL> EDIT FAR_SYNC farsync SET PROPERTY 'RedoRoutes' = '(cdb : cdbstby ASYNC)';
Property "RedoRoutes" updated

DGMGRL> edit database cdbstby set property TransportDisconnectedThreshold=0;
Property "transportdisconnectedthreshold" updated

DGMGRL> edit database cdbstby set property transportlagthreshold=0;
Property "transportlagthreshold" updated

DGMGRL> edit database cdb set property TransportDisconnectedThreshold=0;
Property "transportdisconnectedthreshold" updated

DGMGRL> edit database cdb set property transportlagthreshold=0;
Property "transportlagthreshold" updated

DGMGRL> edit far_sync farsync set property TransportDisconnectedThreshold=0;
Property "transportdisconnectedthreshold" updated

DGMGRL> edit far_sync farsync set property transportlagthreshold=0;
Property "transportlagthreshold" updated

DGMGRL> edit database cdb set property ApplyLagThreshold=0;
Property "applylagthreshold" updated

DGMGRL> edit database cdbstby set property ApplyLagThreshold=0;
Property "applylagthreshold" updated

DGMGRL> edit database cdbstby set property logxptmode=sync;
Property "logxptmode" updated

DGMGRL> show configuration;
Configuration - DGCONFIG

  Protection Mode: MaxPerformance
  Databases:
  cdb      - Primary database
  farsync  - Far Sync
  cdbstby  - Physical standby database
  Fast-Start Failover: DISABLED

Configuration Status:
WARNING

DGMGRL> validate database cdb;
  Database Role:    Primary database
  Ready for Switchover:  Yes

DGMGRL> enable far_sync farsync;
Enabled.