Feroz DBA'S Blog

Target database : primdb Duplicate database: dupdb   Step-1: Configure password file for duplicate database export ORACLE_SID=dupdb export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1 cd $ORACLE_HOME/dbs orapwd file=orapwdupdb password = xxxxx Note: Make sure password should be same a primdb (target database) Step-2: Configure listener and TNS file for duplicate database PRIMDB =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle12c.localdomain)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = primdb)     )   ) DUPDB =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = oracle12c.localdomain)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = dupdb)     )   ) Step-3: Create pfile for duplicate database [oracle@oracle12c dbs]$ cat initdupdb.ora d...

There are 5 steps to configure the DG broker: Configure Listener file on both Primary and Standby database, Add the below lines in the listener file. Reload the listener on both primary and standby Enable dg broker related parameters on both primary and standby database Configure DGMGRL Enable the configuration Step-1: Configure Listener file on both Primary and Standby database, Add the below lines in the listener file. SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (GLOBAL_DBNAME = primdb)       (ORACLE_HOME= /u01/app/oracle/product/12.2.0/dbhome_1)           (SID_NAME = primdb)     ) (SID_DESC =       (GLOBAL_DBNAME = stndb)       (ORACLE_HOME= /u01/app/oracle/product/12.2.0/dbhome_1)           (SID_NAME = stndb)     ) (SID_DESC =       (GLOBAL_DBNAME = primdb_DGMGRL)       (ORACLE_HOME=...