Data Guard Broker 19c

At earlier version of Data Guard when the broker had some problems, one of the automatic answers I got from the support was: to recreate the broker configuration.
In other words:
  1. Drop the configuration.
  2.  Create the configuration.
If your broker is simple, this is not a huge request. Actually, you could follow "Step By Step How to Recreate Data Guard Broker Configuration (Doc ID 808783.1)"
But in my case, using Active Data Guard with Far Sync, with many fine-tuned configurations, it was not so convenient. So I had to find out some other ways trying to be more efficient:
  1. Write down all broker commands, to be able to run them again next time.
  2. For versions and I found a way to query the broker and re-create a current configuration creation script (Extract Data Guard Commands  ).
  3. I also had some issues trying to Drop/remove Far-Sync Configurations from broker 12.1
  4. On version I found out that the broker metadata was changed, so I had to update my previous script Extract Data Guard Commands on Oracle 12.2
  5. Finally on Oracle 19c there will be new commands to export and import a broker configuration 😊
dgmgrl> export configuration to ‘meta.xml’
dgmgrl> import configuration from ‘meta.xml’
Here is a full listing, was shown in Oracle Open World 2018, of new features promised to be in Oracle 19c


Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

List RMAN backups size

AWR Generating & Setting