Data Guard 26ai – #12: ORDS support for Data Guard

This post is part of a blog series.

Beyond SQLcl, DGMGRL, and the PL/SQL API, another key tool for managing Data Guard is Oracle REST Data Services (ORDS).

If your primary databases are set up with ORDS and accessible via REST (HTTPS), you can use REST calls to manage the Data Guard broker configuration. You can create configurations, add standby databases, modify properties, and more, all through standard REST requests.

some examples of REST calls to create a configuration and add a standby database

Introduced in database version 21c and available with ORDS 21.4, this feature lets you easily automate Data Guard management within CI/CD pipelines or any tool that supports REST calls. ORDS also adds flexibility: by exposing only an HTTPS endpoint, you can manage Data Guard without opening SQL*Net ports, which may be preferable for security in some environments.

The REST API documentation for Data Guard is available here: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/25.4/orrst/api-data-guard.html

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.