Extract Data Guard Commands on Oracle 12.2
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 VARCHAR2 (4000); p INTEGER; z XMLTYPE; y CLOB; v_xml XMLTY