CLOUDARCHITECT: DataguardManagetSetup

DataguardManagetSetup

Steps to create broker configuration are:

1. Set the parameter dg_broker_config_file1 and dg_broker_config_file2 on all instances of primary and standby.

Default location of broker configuration file is $ORACLE_HOME/dbs or $ORACLE_HOME/database.

In case if you want broker configuration files in non default location, set these parameters.

In case of RAC database, set broker configuration file location to shared location and same value on all the instances.

ALTER SYSTEM SET dg_broker_config_file1 = '\U01\oradata\dr1mfg.dat' scope=both sid='*';

ALTER SYSTEM SET dg_broker_config_file2 = '\U01\oradata\dr2mfg.dat' scope=both sid='*';

OR in case of ASM file system use:

ALTER SYSTEM SET dg_broker_config_file1 = '+DATA/mfg/dr1mfg.dat' scope=both sid='*';

ALTER SYSTEM SET dg_broker_config_file2 = '+DATA/mfg/dr2mfg.dat' scope=both sid='*';

If you want the broker configuration files in default location, then you can ignore this step.

2. Enable broker on both primary and standby:

SQL>ALTER SYSTEM SET DG_BROKER_START=TRUE scope=both sid='*';

3. Connect to DGMGRL on primary: (from instance one in case of RAC)

$dgmgrl

DGMGRL for Linux: Version 10.2.0.3.0 - Production

Welcome to DGMGRL, type "help" for information.

DGMGRL> CONNECT sys/<password>;

Connected.

4. Create configuration on primary:

DGMGRL> CREATE CONFIGURATION 'PRODCONF' AS PRIMARY DATABASE IS 'PROD10G' CONNECT IDENTIFIER IS PROD10G;

Configuration "PRODCONF" created with primary database "PROD10G"

5. Add standby in the configuration:

DGMGRL> ADD DATABASE 'STDBY10G' AS CONNECT IDENTIFIER IS STDBY10G MAINTAINED AS PHYSICAL;

Database "STDBY10G" added

6. Enable Configuration:

DGMGRL> ENABLE CONFIGURATION;

Enabled.

Use the SHOW command to verify that the configuration and its databases were successfully enabled and brought online:

DGMGRL> SHOW CONFIGURATION;

DGMGRL> remove database abc;

DGMGRL> disable CONFIGURATION;

DGMGRL> help;

DGMGRL> switchover to <STANDBYDB>

DGMGRL> SHOW CONFIGURATION;

DGMGRL> DISABLE FAST_START FAILOVER

DGMGRL> edit configuration set protection mode as maxperformance;.

DGMGRL> edit database abc set state='TRANSPORT-OFF';

EDIT DATABASE dks SET PROPERTY ActualApplyInstance = abc;

EDIT DATABASE dkp SET PROPERTY ClusterName = ac-cluster

edit database <standby> set property StaticConnectIdentifier='<Static Address>';