DG: Useful commands

Useful commands in a DG configuration:


EDIT DATABASE <db> SET PROPERTY TransportDisconnectedThreshold=120;
EDIT DATABASE <db> SET PROPERTY TransportLagThreshold=3600;
EDIT DATABASE <db> SET PROPERTY DGConnectIdentifier = '(DESCRIPTION = (LOAD_BALANCE = ON)(FAILOVER=NO)(ADDRESS = (PROTOCOL = TCP)(HOST=<scan>)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = <service>)))';


Advertisements