Data Guard 26ai – #14: JSON output for DGMGRL

This post is part of a blog series.

Oracle Data Guard 26ai adds JSON output support to DGMGRL.
Previously, you needed Linux tools like sed, awk, or grep to extract information from DGMGRL command-line output.
Now, you can display DGMGRL results as JSON, making them easy to parse with standard libraries or tools such as jq.
While you can programmatically interact with the broker using PL/SQL or REST, JSON output modernizes existing scripts and simplifies automation.

One example shows JSON output for the command SHOW DATABASE. The other shows using jq to parse the output of SHOW CONFIGURATION.
Enable JSON output by running DGMGRL in batch mode with the -json argument, or toggle it on and off in interactive mode with set json on and set json off.

The following two tabs change content below.

Ludovico

Principal Product Manager at Oracle
Ludovico is a member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle. He focuses on Oracle Data Guard, Flashback technologies, and Cloud MAA.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.