Oracle DBA Place

Hi, In an earlier version of Data Guard, when the broker had problems, one of the automatic answers I got from support was to recreate the broker configuration. In other words: Drop the configuration.  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. I had a number of ways I tried to be efficient: I could write down all broker commands - to be able to run them again next time. For versions 11.2.0.4 and 12.1.0.2, I found a way to query the broker and re-create a current configuration creation script ( Extract Data Guard Commands ). I also had some issues trying to Drop/remove Far-Sync Configurations from broker 12.1 . On version 12.2.0.1, I found out that the broker metadata was changed, so I had to update my previo...

Hi, These days I am starting to work on Oracle 12.2, leaving behind the old versions. Since my main domain is Oracle Data Guard,  I posted a blog about Oracle 12c Release 2 New Features for Active Data Guard , one of a big new feature I missed is that the internal Data Guard broker configuration was changed dramatically on 12.2. Last week, I tried to " Extract Data Guard Commands ", and realized it is not working as before :( So I sat down and adjusted it to work on 12.2, this time I enhanced the output with some more important information. Run the following script as sysdba displayconfig122.sql: PROMPT disable FAST_START FAILOVER; PROMPT disable configuration; PROMPT remove configuration; DECLARE    rid                      INTEGER;    indoc                    VARCHAR2 (4000);    outdoc             ...