autonomous_database_dataguard_associations

Creates, updates, deletes, gets or lists an autonomous_database_dataguard_associations resource.

Overview

Name	autonomous_database_dataguard_associations
Type	Resource
Id	oci.database.autonomous_database_dataguard_associations

Fields

The following fields are returned by SELECT queries:

get

The Autonomous Data Guard-enabled database associated with the specified Autonomous Data Guard association OCID.

Name	Datatype	Description
id	string	The OCID of the Autonomous Dataguard created for Autonomous Container Database where given Autonomous AI Database resides in.
applyLag	string	The lag time between updates to the primary database and application of the redo data on the standby database, as computed by the reporting database. Example: 9 seconds
applyRate	string	The rate at which redo logs are synced between the associated databases. Example: 180 Mb per second
autonomousDatabaseId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous AI Database that has a relationship with the peer Autonomous AI Database.
isAutomaticFailoverEnabled	boolean	Indicates whether Automatic Failover is enabled for Autonomous Container Database Dataguard Association
lifecycleDetails	string	Additional information about the current lifecycleState, if available.
lifecycleState	string	The current state of Autonomous Data Guard. (PROVISIONING, AVAILABLE, ROLE_CHANGE_IN_PROGRESS, TERMINATING, TERMINATED, FAILED, UNAVAILABLE, UPDATING)
peerAutonomousDatabaseId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the peer Autonomous AI Database.
peerAutonomousDatabaseLifeCycleState	string	The current state of the Autonomous AI Database. (PROVISIONING, AVAILABLE, STOPPING, STOPPED, STARTING, TERMINATING, TERMINATED, UNAVAILABLE, RESTORE_IN_PROGRESS, RESTORE_FAILED, BACKUP_IN_PROGRESS, SCALE_IN_PROGRESS, AVAILABLE_NEEDS_ATTENTION, UPDATING, MAINTENANCE_IN_PROGRESS, RESTARTING, RECREATING, ROLE_CHANGE_IN_PROGRESS, UPGRADING, INACCESSIBLE, STANDBY, TRANSPORTING)
peerRole	string	The Data Guard role of the Autonomous Container Database or Autonomous AI Database, if Autonomous Data Guard is enabled. (PRIMARY, STANDBY, DISABLED_STANDBY, BACKUP_COPY, SNAPSHOT_STANDBY)
protectionMode	string	The protection mode of this Autonomous Data Guard association. For more information, see [Oracle Data Guard Protection Modes](http:​//docs.oracle.com/database/122/SBYDB/oracle-data-guard-protection-modes.htm#SBYDB02000) in the Oracle Data Guard documentation. (MAXIMUM_AVAILABILITY, MAXIMUM_PERFORMANCE)
role	string	The Data Guard role of the Autonomous Container Database or Autonomous AI Database, if Autonomous Data Guard is enabled. (PRIMARY, STANDBY, DISABLED_STANDBY, BACKUP_COPY, SNAPSHOT_STANDBY)
timeCreated	string (date-time)	The date and time the Data Guard association was created.
timeLastRoleChanged	string (date-time)	The date and time when the last role change action happened.
timeLastSynced	string (date-time)	The date and time of the last update to the apply lag, apply rate, and transport lag values.
transportLag	string	The approximate number of seconds of redo data not yet available on the standby Autonomous Container Database, as computed by the reporting database. Example: 7 seconds

list

The properties that define dataguard association between two different Autonomous AI Databases.<br />Note that Autonomous AI Databases inherit DataGuard association from parent Autonomous Container Database.<br />No actions can be taken on AutonomousDatabaseDataguardAssociation, usage is strictly informational.<br />

Name	Datatype	Description
id	string	The OCID of the Autonomous Dataguard created for Autonomous Container Database where given Autonomous AI Database resides in.
applyLag	string	The lag time between updates to the primary database and application of the redo data on the standby database, as computed by the reporting database. Example: 9 seconds
applyRate	string	The rate at which redo logs are synced between the associated databases. Example: 180 Mb per second
autonomousDatabaseId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous AI Database that has a relationship with the peer Autonomous AI Database.
isAutomaticFailoverEnabled	boolean	Indicates whether Automatic Failover is enabled for Autonomous Container Database Dataguard Association
lifecycleDetails	string	Additional information about the current lifecycleState, if available.
lifecycleState	string	The current state of Autonomous Data Guard. (PROVISIONING, AVAILABLE, ROLE_CHANGE_IN_PROGRESS, TERMINATING, TERMINATED, FAILED, UNAVAILABLE, UPDATING)
peerAutonomousDatabaseId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the peer Autonomous AI Database.
peerAutonomousDatabaseLifeCycleState	string	The current state of the Autonomous AI Database. (PROVISIONING, AVAILABLE, STOPPING, STOPPED, STARTING, TERMINATING, TERMINATED, UNAVAILABLE, RESTORE_IN_PROGRESS, RESTORE_FAILED, BACKUP_IN_PROGRESS, SCALE_IN_PROGRESS, AVAILABLE_NEEDS_ATTENTION, UPDATING, MAINTENANCE_IN_PROGRESS, RESTARTING, RECREATING, ROLE_CHANGE_IN_PROGRESS, UPGRADING, INACCESSIBLE, STANDBY, TRANSPORTING)
peerRole	string	The Data Guard role of the Autonomous Container Database or Autonomous AI Database, if Autonomous Data Guard is enabled. (PRIMARY, STANDBY, DISABLED_STANDBY, BACKUP_COPY, SNAPSHOT_STANDBY)
protectionMode	string	The protection mode of this Autonomous Data Guard association. For more information, see [Oracle Data Guard Protection Modes](http:​//docs.oracle.com/database/122/SBYDB/oracle-data-guard-protection-modes.htm#SBYDB02000) in the Oracle Data Guard documentation. (MAXIMUM_AVAILABILITY, MAXIMUM_PERFORMANCE)
role	string	The Data Guard role of the Autonomous Container Database or Autonomous AI Database, if Autonomous Data Guard is enabled. (PRIMARY, STANDBY, DISABLED_STANDBY, BACKUP_COPY, SNAPSHOT_STANDBY)
timeCreated	string (date-time)	The date and time the Data Guard association was created.
timeLastRoleChanged	string (date-time)	The date and time when the last role change action happened.
timeLastSynced	string (date-time)	The date and time of the last update to the apply lag, apply rate, and transport lag values.
transportLag	string	The approximate number of seconds of redo data not yet available on the standby Autonomous Container Database, as computed by the reporting database. Example: 7 seconds

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	autonomousDatabaseId, autonomousDatabaseDataguardAssociationId, region	opc-request-id	Deprecated. Use the [GetAutonomousContainerDatabase](#/en/database/latest/AutonomousContainerDatabase/GetAutonomousContainerDatabase) operation to gets an Autonomous Data Guard-enabled database associated with the specified Autonomous AI Database.<br />
list	select	autonomousDatabaseId, region	limit, page	Deprecated. Use the [GetAutonomousContainerDatabase](#/en/database/latest/AutonomousContainerDatabase/GetAutonomousContainerDatabase) operation to get a list of the Autonomous Data Guard-enabled databases associated with the specified Autonomous AI Database.<br />

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
autonomousDatabaseDataguardAssociationId	string	The Autonomous Container Database-Autonomous Data Guard association [OCID](/Content/General/Concepts/identifiers.htm).
autonomousDatabaseId	string	The database [OCID](/Content/General/Concepts/identifiers.htm).
region	string	OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
limit	integer	The maximum number of items to return per page.
opc-request-id	string	Unique identifier for the request.
page	string	The pagination token to continue listing from.

SELECT examples

get

Deprecated. Use the [GetAutonomousContainerDatabase](#/en/database/latest/AutonomousContainerDatabase/GetAutonomousContainerDatabase) operation to gets an Autonomous Data Guard-enabled database associated with the specified Autonomous AI Database.<br />

SELECT
id,
applyLag,
applyRate,
autonomousDatabaseId,
isAutomaticFailoverEnabled,
lifecycleDetails,
lifecycleState,
peerAutonomousDatabaseId,
peerAutonomousDatabaseLifeCycleState,
peerRole,
protectionMode,
role,
timeCreated,
timeLastRoleChanged,
timeLastSynced,
transportLag
FROM oci.database.autonomous_database_dataguard_associations
WHERE autonomousDatabaseId = '{{ autonomousDatabaseId }}' -- required
AND autonomousDatabaseDataguardAssociationId = '{{ autonomousDatabaseDataguardAssociationId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

list

Deprecated. Use the [GetAutonomousContainerDatabase](#/en/database/latest/AutonomousContainerDatabase/GetAutonomousContainerDatabase) operation to get a list of the Autonomous Data Guard-enabled databases associated with the specified Autonomous AI Database.<br />

SELECT
id,
applyLag,
applyRate,
autonomousDatabaseId,
isAutomaticFailoverEnabled,
lifecycleDetails,
lifecycleState,
peerAutonomousDatabaseId,
peerAutonomousDatabaseLifeCycleState,
peerRole,
protectionMode,
role,
timeCreated,
timeLastRoleChanged,
timeLastSynced,
transportLag
FROM oci.database.autonomous_database_dataguard_associations
WHERE autonomousDatabaseId = '{{ autonomousDatabaseId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;