Export/Import Oracle Dataguard / Dg Broker Configuration

 

Most   of time  we  feel   need  to re-create  Dataguard Configuration  however we are scared  to loose   current   configuration . 

From 18c we have option to  backup and  Import  dataguard configuration  making life easy  

To Export 

DGMGRL>export configuration to 'dgbrokerconfigurationexport.txt';

or

DGMGRL>export configuration to '/<location>/dgbrokerconfigurationexport.txt';

If 'TO' clause is not used then the configuration is exported to filename 'SID_dmon_processID-of-DMON_brkmeta_serial-number.trc. ' in the tracedump.

Example : prod_dmon_1000_brkmeta_2.trc , if prod is the SID and pmon process id is 1000

To Import : 

DGMGRL>import configuration from 'dgbrokerconfigurationexport.txt';

or

DGMGRL>import configuration from '/<location/dgbrokerconfigurationexport.txt';

Reference : 

How to Export/Import DG Broker Configuration (Doc ID 2951452.1)