Data Guard Manager

DMON process

DGMGRL

Created the “drc” trace file in the DIAGNOSTIC_DEST location

DGMGRL> connect sys/oracle
DGMGRL> ADD – add a standby database to the broker configuration
DGMGRL> CONNECT – connect the user to the instance
DGMGRL> CREATE – create broker configurations
DGMGRL> DISABLE – disable broker control of a configuration or database
DISABLE CONFIGURATION;
DISABLE DATABASE ‘pc00sby1’;
DGMGRL> EDIT – a configuration, database or instance
DGMGRL> ENABLE – enables you to enable broker control of a configuration or database
DGMGRL> EXIT/QUIT
DGMGRL> FAILOVER – performs a db failover
DGMGRL> HELP
DGMGRL> REINSTATE – changes a disabled db into a viable standby db.
DGMGRL> REMOVE – removes a broker configuration, a standby db profile or knowledge of an instance
REMOVE DATABASE ‘pc00sby1’;
REMOVE CONFIGURATION;
DGMGRL> SHOW
DGMGRL> SHUTDOWN – shutdown the instance
DGMGRL> START – start the Fast-Start Failover Observer
DGMGRL> STARTUP – starts the instance
DGMGRL> STOP – stop the Fast-Start Failover Observer
DGMGRL> SWITCHOVER – performs a switchover

To enable Data Gurad Broker to start/stop instances a service with a specific name must be registered.
The value of GLOBAL_DBNAME must be ‘db_unique_name_DGMGRL.db_domain’.
ALTER SYSTEM SET DG_BROKER_START=TRUE;
Set DG_BROKER_CONFIG_FILEn so that all instances point to the same shared files for that database.
Must use and SPFILE
Broker log files are created in the alert log directory and are named drc.log

DGMGRL>
DGMGRL> CREATE CONFIGURATION ‘DGConfig1’ AS PRIMARY DATABASE IS pc00prmy CONNECT IDENTIFIER IS pc00prmy;
DGMGRL> ADD DATABASE pc00sby1 AS CONNECT IDENTIFIER IS pc00sby1;
( in above lines the db name must be the same as the db_unique_name)
DGMGRL> ENABLE CONFIGURATION;
DGMGRL> SHOW CONFIGURATION
To alter a database property
DGMGRL> EDIT DATABASE pc00sby1 SET PROPERTY L0gXptMode=’SYNC’;
DGMGRL> EDIT DATABASE pc00sby1 SET STATE=’APPLY-OFF’;
DGMGRL> EDIT DATABASE pc00prmy SET STATE=’TRANSPORT-OFF’;
( TRANSPORT-ON, TRANSPORT-OFF, APPLY-ON, APPLY-OFF)

DGConnectIdentifier value is used in the FAL_SERVER and FAL_CLIENT initialisation parameters,
changing this updates LOG_ARCHIVE_DEST_n and FAL_CLIENT, FAL_SERVER
LogXptMode – ASYNC (noaffirm), SYNC (Affirm)
LogShipping – ON, OFF (only used when database is in the TRANSPORT-ON state).