Events for Autonomous Database on Dedicated Exadata Infrastructure

APPLIES TO: Oracle Public Cloud only

The Oracle Database resources emit events, which are structured messages that indicate changes in resources. This article lists the operations that generate events for Autonomous Database on Oracle Cloud.

Tip:

Refer to Oracle Exadata Cloud@Customer Events for listings of the operations that generate events for Autonomous Database on Exadata Cloud@Customer.

Autonomous Database generates events for more than forty different operations, providing you fine-grained choices for resource tracking. Following are the different event types that Autonomous Database infrastructure resources emit:

• Cloud Exadata Infrastructure Event Types

• Cloud Autonomous VM Cluster Event Types

• Autonomous Container Database Event Types

• Autonomous Database Event Types

• Autonomous Data Guard Event Types

Cloud Exadata Infrastructure Event Types

Review the list of event types that Exadata Infrastructure instances emit.

Cloud Exadata Infrastructure Event Types

Friendly Name	Event Type
Cloud Exadata Infrastructure - Create Begin	com.oraclecloud.databaseservice.createcloudexadatainfrastructure.begin
Cloud Exadata Infrastructure - Create End	com.oraclecloud.databaseservice.createcloudexadatainfrastructure.end
Cloud Exadata Infrastructure - Change Compartment Begin	com.oraclecloud.databaseservice.changecloudexadatainfrastructurecompartment.begin
Cloud Exadata Infrastructure - Change Compartment End	com.oraclecloud.databaseservice.changecloudexadatainfrastructurecompartment.end
Cloud Exadata Infrastructure - Critical See Cloud Exadata Infrastructure Critical and Information Event Types for details.	com.oraclecloud.databaseservice.cloudexadatainfrastructure.critical
Cloud Exadata Infrastructure - Delete Begin	com.oraclecloud.databaseservice.deletecloudexadatainfrastructure.begin
Cloud Exadata Infrastructure - Delete End	com.oraclecloud.databaseservice.deletecloudexadatainfrastructure.end
Cloud Exadata Infrastructure – Information See Cloud Exadata Infrastructure Critical and Information Event Types for details.	com.oraclecloud.databaseservice.cloudexadatainfrastructure.information
Cloud Exadata Infrastructure – Maintenance Begin	com.oraclecloud.databaseservice.cloudexadatainfrastructuremaintenance.begin
Cloud Exadata Infrastructure – Maintenance End	com.oraclecloud.databaseservice.cloudexadatainfrastructuremaintenance.end
Cloud Exadata Infrastructure – Maintenance Reminder	com.oraclecloud.databaseservice.cloudexadatainfrastructuremaintenancereminder
Cloud Exadata Infrastructure – Maintenance Scheduled	com.oraclecloud.databaseservice.cloudexadatainfrastructuremaintenancescheduled
Cloud Exadata Infrastructure - Update Begin	com.oraclecloud.databaseservice.updatecloudexadatainfrastructure.begin
Cloud Exadata Infrastructure - Update End	com.oraclecloud.databaseservice.updatecloudexadatainfrastructure.end

Example - Cloud Exadata Infrastructure Event

This is a reference event for a Cloud Exadata Infrastructure resource:

{
  "cloudEventsVersion": "0.1",
  "eventId": "<unique_ID>",
  "eventType": "com.oraclecloud.databaseservice.cloudexadatainfrastructuremaintenance.end",
  "source": "DatabaseService",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-06-27T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1.<unique_ID>"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1.<unique_ID>",
    "compartmentName": "example_name",
    "resourceName": "my_exadata_infrastructure",
    "resourceId": "ocid1.dbsystem.oc1.eu-frankfurt-1.<unique_ID>", ,
    "availabilityDomain": "tXPJ:EU-FRANKFURT-1-AD-3",
    "freeFormTags": {
      "Department": "Finance"
    },
    "definedTags": {
      "Operations": {
        "CostCenter": "42"
      }
    },
    "additionalDetails" : {
"subnetId" : "ocid1.subnet.oc1.eu-frankfurt-1.<unique_ID>",
"lifecycleState" : "MAINTENANCE_IN_PROGRESS",
"sshPublicKeys" : "...",
"cpuCoreCount" : 32,
"version" : "19.2.8.0.0.191119",
"nsgIds" : "null",
"backupSubnetId" : "ocid1.subnet.oc1.eu-frankfurt-1.<unique_ID>",
"licenseType" : "BRING_YOUR_OWN_LICENSE",
"dataStoragePercentage" : 80,
"patchHistoryEntries" : "null",
"lifecycleMessage" : "The underlying infrastructure of this system (cell storage) is being updated and this will not impact database availability.",
"exadataIormConfig" : "ExadataIormConfigCache(lifecycleState=DISABLED, lifeCycleDetails=null, objective=Auto, dbPlans=[DbIormConfigCache(dbName=default, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database1>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database2>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database3>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database4>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database5>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database6>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database7>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database8>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database9>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database10>, share=null, flashCacheLimit=null), DbIormConfigCache(dbName=<my_database11>, share=null, flashCacheLimit=null)], undoData=null)"
}
},
"eventID" : "<unique_ID>",
"extensions" : {
"compartmentId" : "ocid1.compartment.oc1.<unique_ID>"
}
}

Cloud Exadata Infrastructure Critical and Information Event Types

Cloud Exadata Infrastructure resources emit "critical" and "information" event types. These event types allow you to receive notifications when your infrastructure resource needs urgent attention ("critical" events) or notifications for events that are not critical but which you may want to monitor ("information" events). The eventType values for these events are the following:

Friendly Name	Event Type
Cloud Exadata Infrastructure - Critical	com.oraclecloud.databaseservice.exadatainfrastructure.critical
Cloud Exadata Infrastructure - Information	com.oraclecloud.databaseservice.exadatainfrastructure.information

These events use the additionalDetails section of the event message to provide specific details about what is happening within the infrastructure resource emitting the event. In the additionalDetails section, the eventName field provides the name of the critical or information event. (Note that some fields in the example that follows have been omitted for brevity.)

{
  "eventType" : "com.oraclecloud.databaseservice.exadatainfrastructure.critical",
  ....
  "data" : {
   ....
     "additionalDetails" : {
      ....
      "description" : "SQL statement terminated by Oracle Database Resource Manager due to excessive consumption of CPU and/or I/O. The execution plan associated with the terminated SQL stmt is quarantined. Please find the sql identifier in sqlId field of this JSON payload. This feature protects an Oracle database from performance degradation. Please review the SQL statement. You can see the statement using the following commands: \"set serveroutput off\", \"select sql_id, sql_text from v$sqltext where sql_id =<sqlId>\", \"set serveroutput on\"",
      "component" : "storage",
      "infrastructureType" : "exadata",
      "eventName" : "CloudExadataInfrastructure.SqlQuarantine",
      "quarantineMode" : "\"FULL Quarantine\""
       ....
    }
  },
  "eventID" : "<unique_ID>",
  ....
  }
}

For full-length example critical and information events, see Example: Critical Event for Cloud Exadata Infrastructure Resource and Example: Information Event for Cloud Exadata Infrastructure Resource.

In the tables below, you can read about the conditions and operations that trigger "critical" and "information" events. Each condition or operation is identified by a unique eventName value.

Critical Events for Cloud Exadata Infrastructure

Critical Event - EventName

Description

CloudExadataInfrastructure.SqlQuarantine

SQL statement is terminated by Oracle Database Resource Manager due to excessive consumption of CPU and/or I/O. The execution plan associated with the terminated SQL statement is quarantined. Please find the sql identifier in sqlId field of this JSON payload. This feature protects an Oracle database from performance degradation. Please review the SQL statement. You can see the statement using the following commands: \"set serveroutput off\" \"select sql_id, sql_text from v$sqltext where sql_id =<sqlId>\" \"set serveroutput on\"

Informational Events for Cloud Exadata Infrastructure

Information Event - EventName	Description
CloudExadataInfrastructure.FlashDiskFailure	Flash Disk Failure has been detected. This is being investigated by Oracle Exadata team and the disk will be replaced if needed. No action needed from the customer.

Example: Critical Event for Cloud Exadata Infrastructure Resource

In the following example of a "critical" event, you can see within the additionalDetails section of the event message that this particular message concerns an SQL statement that was terminated by Oracle Database Resource Manager because it was consuming excessive CPU or I/O resources. The eventName and description fields within the additionalDetails section provide information regarding the critical situation:

{
  "eventType" : "com.oraclecloud.databaseservice.exadatainfrastructure.critical",
  "cloudEventsVersion" : "0.1",
  "eventTypeVersion" : "2.0",
  "source" : "Exadata Storage",
  "eventTime" : "2021-07-30T04:53:18Z",
  "contentType" : "application/json",
  "data" : {
    "compartmentId" : "ocid1.tenancy.oc1.<unique_ID>",
    "compartmentName" : "example_name",
    "resourceName" : "my_exadata_resource",
    "resourceId" : "ocid1.dbsystem.oc1.phx.<unique_ID>",
    "availabilityDomain" : "phx-ad-2",
     "additionalDetails" : {
      "serviceType" : "exacs",
      "sqlID" : "gnwfm1jgqcfuu",
      "systemId" : "ocid1.dbsystem.oc1.eu-frankfurt-1.<unique_ID>",
      "creationTime" : "2021-05-14T13:29:28+00:00",
      "dbUniqueID" : "1558836122",
      "quarantineType" : "SQLID",
      "dbUniqueName" : "AB0503_FRA1S6",
      "description" : "SQL statement terminated by Oracle Database Resource Manager due to excessive consumption of CPU and/or I/O. The execution plan associated with the terminated SQL stmt is quarantined. Please find the sql identifier in sqlId field of this JSON payload. This feature protects an Oracle database from performance degradation. Please review the SQL statement. You can see the statement using the following commands: \"set serveroutput off\", \"select sql_id, sql_text from v$sqltext where sql_id =<sqlId>\", \"set serveroutput on\"",
      "quarantineReason" : "Manual",
      "asmClusterName" : "None",
      "component" : "storage",
      "infrastructureType" : "exadata",
      "name" : "143",
      "eventName" : "CloudExadataInfrastructure.SqlQuarantine",
      "comment" : "None",
      "quarantineMode" : "\"FULL Quarantine\"",
      "rpmVersion" : "OSS_20.1.8.0.0_LINUX.X64_210317",
      "cellsrvChecksum" : "14f73eb107dc1be0bde757267e931991",
      "quarantinePlan" : "SYSTEM"
    }
  },
  "eventID" : "<unique_ID>",
  "extensions" : {
    "compartmentId" : "ocid1.tenancy.oc1.<unique_ID>"
  }
}

Example: Information Event for Cloud Exadata Infrastructure Resource

In the following example of an "information" event, you can see within the additionalDetails section of the event message that this particular message concerns a flash disk failure that is being investigated by the Oracle Exadata operations team. The eventName and description fields within the additionalDetails section provide information regarding the event:

{
  "eventType" : "com.oraclecloud.databaseservice.exadatainfrastructure.information",
  "cloudEventsVersion" : "0.1",
  "eventTypeVersion" : "2.0",
  "source" : "Exadata Storage",
  "eventTime" : "2021-12-17T19:14:42Z",
  "contentType" : "application/json",
  "data" : {
    "compartmentId" : "ocid1.tenancy.oc1..aaaaaaaao3lj36x6lwxyvc4wausjouca7pwyjfwb5ebsq5emrpqlql2gj5iq",
    "compartmentName" : "intexadatateam",
    "resourceId" : "ocid1.dbsystem.oc1.phx.abyhqljt5y3taezn7ug445fzwlngjfszbedxlcbctw45ykkaxyzc5isxoula",
    "availabilityDomain" : "phx-ad-2",
    "additionalDetails" : {
      "serviceType" : "exacs",
      "component" : "storage",
      "systemId" : "ocid1.dbsystem.oc1.phx.abyhqljt5y3taezn7ug445fzwlngjfszbedxlcbctw45ykkaxyzc5isxoula",
      "infrastructureType" : "exadata",
      "description" : "Flash Disk Failure has been detected. This is being investigated by Oracle Exadata team and the disk will be replaced if needed. No action needed from the customer.",
      "eventName" : "CloudExadataInfrastructure.FlashDiskFailure",
      "FLASH_1_1" : "S2T7NA0HC01251  failed",
      "otto-ingestion-time" : "2021-12-17T19:14:43.205Z",
      "otto-send-EventService-time" : "2021-12-17T19:14:44.198Z"
    }
  },
  "eventID" : "30130ab4-42fa-4285-93a7-47e49522c698",
  "extensions" : {
    "compartmentId" : "ocid1.tenancy.oc1..aaaaaaaao3lj36x6lwxyvc4wausjouca7pwyjfwb5ebsq5emrpqlql2gj5iq"
  }
}

Cloud Autonomous Exadata VM Cluster Event Types

Review the list of event types that cloud Autonomous Exadata VM Clusters emit.

Friendly Name	Event Type
Autonomous Cloud VM Cluster - Change Compartment Begin	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.changecompartment.begin
Autonomous Cloud VM Cluster - Change Compartment End	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.changecompartment.end
Autonomous Cloud VM Cluster - Create Begin	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.create.begin
Autonomous Cloud VM Cluster - Create End	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.create.end
Autonomous Cloud VM Cluster - Critical See Cloud Autonomous Exadata VM Cluster Critical, Warning, and Information Event Types for details.	com.oraclecloud.databaseservice.autonomous.cloudautonomousvmcluster.critical
Autonomous Cloud VM Cluster - Information See Cloud Autonomous Exadata VM Cluster Critical, Warning, and Information Event Types for details.	com.oraclecloud.databaseservice.autonomous.cloudautonomousvmcluster.information
Autonomous Cloud VM Cluster - Maintenance Begin	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.maintenance.begin
Autonomous Cloud VM Cluster - Maintenance End	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.maintenance.end
Autonomous Cloud VM Cluster - Maintenance Reminder	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.maintenance.reminder
Autonomous Cloud VM Cluster - Maintenance Scheduled	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.maintenance.scheduled
Autonomous Cloud VM Cluster - Terminate Begin	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.terminate.begin
Autonomous Cloud VM Cluster - Terminate End	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.terminate.end
Autonomous Cloud VM Cluster - Update Begin	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.update.begin
Autonomous Cloud VM Cluster - Update End	com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.update.end
Autonomous Cloud VM Cluster - Warning See Cloud Autonomous Exadata VM Cluster Critical, Warning, and Information Event Types for details.	com.oraclecloud.databaseservice.autonomous.cloudautonomousvmcluster.warning

Example - Cloud Autonomous Exadata VM Cluster Event

{
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.autonomous.autonomouscloudvmcluster.update.begin",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2020-06-02T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_id"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_id",
    "compartmentName": "example_name",
    "resourceName": "my_container_database",
    "resourceId": "ocid1.autonomousexainfrastructure-..unique_id",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "lifecycleState": "ACTIVE",
      "timeCreated": "2019-06-27T21:15:59.000Z",
      "timeUpdated": "2019-06-27T21:16:04.389Z",
      "dbName": "exampleDbName"
    }
  }
}

Cloud Autonomous Exadata VM Cluster Critical, Warning, and Information Event Types

Cloud Autonomous Exadata VM Clusters emit critical, warning, and information event types. These event types allow you to receive notifications:

• When your Autonomous Exadata VM Cluster needs urgent attention (critical events)
• For an event that is not critical but needs your attention to prevent it from turning critical (warning events)
• For an event that is good to be notified for your information (information events)

The eventType values for each of these events are listed below:

Friendly Name	Event Type
Autonomous Cloud VM Cluster - Critical	com.oraclecloud.databaseservice.autonomous.cloudautonomousvmcluster.critical
Autonomous Cloud VM Cluster - Warning	com.oraclecloud.databaseservice.autonomous.cloudautonomousvmcluster.warning
Autonomous Cloud VM Cluster - Information	com.oraclecloud.databaseservice.autonomous.cloudautonomousvmcluster.information

These events use the additionalDetails section of the event message to provide specific details about what is happening within the Autonomous Exadata VM Cluster resource emitting the event. In the additionalDetails section, the eventName field provides the name of the critical, warning, or information event.

In the tables below, you can read about the conditions and operations that trigger critical, warning, and information events. Each condition or operation is identified by a unique eventName value.

Critical Events for Cloud Autonomous Exadata VM Cluster

Event	Description
sslcertificate.expired	This event is generated when the SSL Certificate expires. All the Autonomous Database wallets related to this Autonomous Exadata VM Cluster will expire.
autonomous.operations.issue.detected.critical	Autonomous Dedicated Operations has detected a critical issue with your Autonomous Exadata VM Cluster and is working on it. No action is required on your part.
autonomous.operations.issue.resolved.critical	Autonomous Dedicated Operations has resolved a critical issue with your Autonomous Exadata VM Cluster. No further action is required.
sslcertificate.rotated	This event is generated when the SSL certificate is rotated either manually (using the Oracle Cloud Infrastructure console or API) or automatically on its expiry.

Warning Events for Cloud Autonomous Exadata VM Cluster

Event	Description
sslcertificateexpiry.reminder	This event is generated when an Autonomous Exadata VM Cluster determines that a wallet is due to expire in less than six (6) weeks. This event is reported at most once per week. This event is triggered when there is a connection that uses the wallet that is due to expire.
sslcertificaterotation.reminder	This event is generated when an SSL certificate is older than 365 days and recommends the customer to rotate the certificate. After an SSL certificate crosses 365 days, this reminder is once per week until it is rotated.
autonomous.operations.issue.detected.warning	Autonomous Dedicated Operations has detected an issue with your Autonomous Exadata VM Cluster and is working on it. No action is required on your part.
autonomous.operations.issue.resolved.warning	Autonomous Dedicated Operations has resolved an issue with your Autonomous Exadata VM Cluster. No further action is required.

Information Events for Cloud Autonomous Exadata VM Cluster

Event	Description
autonomous.operations.issue.detected.information	Autonomous Dedicated Operations has detected an issue with your Autonomous Exadata VM Cluster and is working on it. No action is required on your part.
autonomous.operations.issue.resolved.information	Autonomous Dedicated Operations has resolved an issue with your Autonomous Exadata VM Cluster. No further action is required.

Autonomous Container Database Event Types

Review the list of event types that Autonomous Container Databases emit.

Friendly Name	Event Type
Autonomous Container Database - Change Compartment	com.oraclecloud.databaseservice.changeautonomouscontainerdatabasecompartment.begin
Autonomous Container Database - Create Backup Begin	com.oraclecloud.databaseservice.autonomous.container.database.backup.begin
Autonomous Container Database - Create Backup End	com.oraclecloud.databaseservice.autonomous.container.database.backup.end
Autonomous Container Database - Create Begin	com.oraclecloud.databaseservice.autonomous.container.database.instance.create.begin
Autonomous Container Database - Create End	com.oraclecloud.databaseservice.autonomous.container.database.instance.create.end
Autonomous Container Database - Critical See Autonomous Container Database Critical, Warning, and Information Event Types	com.oraclecloud.databaseservice.autonomous.container.database.critical
Autonomous Container Database - Information See Autonomous Container Database Critical, Warning, and Information Event Types	com.oraclecloud.databaseservice.autonomous.container.database.information
Autonomous Container Database - Maintenance Begin	com.oraclecloud.databaseservice.autonomous.container.database.maintenance.begin
Autonomous Container Database - Maintenance End	com.oraclecloud.databaseservice.autonomous.container.database.maintenance.end
Autonomous Container Database - Maintenance Reminder	com.oraclecloud.databaseservice.autonomous.container.database.maintenance.reminder
Autonomous Container Database - Maintenance Scheduled	com.oraclecloud.databaseservice.autonomous.container.database.maintenance.scheduled
Autonomous Container Database - Restart Begin	com.oraclecloud.databaseservice.restartautonomouscontainerdatabase.begin
Autonomous Container Database - Restart End	com.oraclecloud.databaseservice.restartautonomouscontainerdatabase.end
Autonomous Container Database - Restore Begin	com.oraclecloud.databaseservice.autonomous.container.database.restore.begin
Autonomous Container Database - Restore End	com.oraclecloud.databaseservice.autonomous.container.database.restore.end
Autonomous Container Database - Rotate Encryption Key Begin	com.oraclecloud.databaseservice.rotateautonomouscontainerdatabaseencryptionkey.begin
Autonomous Container Database - Rotate Encryption Key End	com.oraclecloud.databaseservice.rotateautonomouscontainerdatabaseencryptionkey.end
Autonomous Container Database - Terminate Begin	com.oraclecloud.databaseservice.terminateautonomouscontainerdatabase.begin
Autonomous Container Database - Terminate End	com.oraclecloud.databaseservice.terminateautonomouscontainerdatabase.end
Autonomous Container Database - Update Begin	com.oraclecloud.databaseservice.autonomous.container.database.instance.update.begin
Autonomous Container Database - Update End	com.oraclecloud.databaseservice.autonomous.container.database.instance.update.end
Autonomous Container Database - Warning See Autonomous Container Database Critical, Warning, and Information Event Types	com.oraclecloud.databaseservice.autonomous.container.database.warning

Example - Autonomous Container Database Event

{
  "cloudEventsVersion": "0.1",
  "eventID": "<unique_ID>",
  "eventType": "com.oraclecloud.databaseservice.autonomous.container.database.backup.begin",
  "source": "databaseservice",
  "eventTypeVersion": "2.0",
  "eventTime": "2019-06-27T21:16:04Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>",
    "compartmentName": "example_name",
    "resourceName": "my_container_database",
    "resourceId": "<unique_ID>",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "cpuCoreCount": null,
      "lifecycleState": "ACTIVE",
      "dataStorageSizeInTBs": null,
      "timeCreated": "2019-06-27T21:15:59.000Z",
      "timeUpdated": "2019-06-27T21:16:04.389Z",
      "dbUniqueName": "dwrrdtsr_phx289",
      "dbHomeId": "ocid1.autonomoushome.oc1.phx.<unique_ID>",
      "dbName": "dwrrdtsr"
      "autonomousContainerDatabaseId": "ocid1.autonomouscontainerdatabase.oc1.phx.<unique_ID>"
    }
  }
}

Autonomous Container Database Critical, Warning, and Information Event Types

Autonomous Container Databases emit critical, warning, and information event types. These event types allow you to receive notifications:

• When your Autonomous Container Database needs urgent attention (critical events)
• For an event that is not critical but needs your attention to prevent it from turning critical (warning events)
• For an event that is good to be notified for your information (information events)

The eventType values for each of these events are listed below:

Friendly Name	Event Type
Autonomous Container Database - Critical	com.oraclecloud.databaseservice.autonomous.container.database.critical
Autonomous Container Database - Warning	com.oraclecloud.databaseservice.autonomous.container.database.warning
Autonomous Container Database - Information	com.oraclecloud.databaseservice.autonomous.container.database.information

These events use the additionalDetails section of the event message to provide specific details about what is happening within the Autonomous Container Database resource emitting the event. In the additionalDetails section, the eventName field provides the name of the critical, warning, or information event.

In the tables below, you can read about the conditions and operations that trigger critical, warning, and information events. Each condition or operation is identified by a unique eventName value.

Critical Events for Autonomous Container Database

Event	Description
autonomous.operations.issue.detected.critical	Autonomous Dedicated Operations has detected a critical issue with your Autonomous Container Database and is working on it. No action is required on your part.
autonomous.operations.issue.resolved.critical	Autonomous Dedicated Operations has resolved a critical issue with your Autonomous Container Database. No further action is required.
backup.destination.error	Autonomous Dedicated Operations has detected one of the following critical issues with your backup destination: Your Network File Storage server is out of space. Incorrect permissions are set on your Network File Storage server. Your Zero Data Loss Recovery Appliance server is out of space.

Warning Events for Autonomous Container Database

Event	Description
autonomous.operations.issue.detected.warning	Autonomous Dedicated Operations has detected an issue with your Autonomous Container Database and is working on it. No action is required on your part.
autonomous.operations.issue.resolved.warning	Autonomous Dedicated Operations has resolved an issue with your Autonomous Container Database. No further action is required.
backup.destination.nfs.limit.breach	Generated when Network File Storage backups consume at least 80% of space in the backup destination.

Information Events for Autonomous Container Database

Event	Description
autonomous.operations.issue.detected.information	Autonomous Dedicated Operations has detected an issue with your Autonomous Container Database and is working on it. No action is required on your part.
autonomous.operations.issue.resolved.information	Autonomous Dedicated Operations has resolved an issue with your Autonomous Container Database. No further action is required.
backup.validation.complete	Your Autonomous Container Database's backup validation is complete.
backup.destination.available	Your Autonomous Container Database's backup destination is back to a healthy state.

Autonomous Database Event Types

Review the list of event types that Autonomous Databases emit.

Autonomous Database Event Types

Friendly Name	Event Type
Autonomous Database - Automatic Backup Begin	com.oraclecloud.databaseservice.automaticbackupautonomousdatabase.begin
Autonomous Database - Automatic Backup End	com.oraclecloud.databaseservice.automaticbackupautonomousdatabase.end
Autonomous Database - Backup Update – Begin	com.oraclecloud.databaseservice.autonomous.database.backup.updateautonomousdatabasebackup.begin
Autonomous Database - Backup Update – End	com.oraclecloud.databaseservice.autonomous.database.backup.updateautonomousdatabasebackup.end
Autonomous Database - Change Compartment Begin	com.oraclecloud.databaseservice.changeautonomousdatabasecompartment.begin
Autonomous Database - Change Compartment End	com.oraclecloud.databaseservice.changeautonomousdatabasecompartment.end
Autonomous Database - Change Database Name Begin	com.oraclecloud.databaseservice.changeautonomousdatabasename.begin
Autonomous Database - Change Database Name End	com.oraclecloud.databaseservice.changeautonomousdatabasename.end
Autonomous Database - Create Backup Begin	com.oraclecloud.databaseservice.autonomous.database.backup.begin
Autonomous Database - Create Backup End	com.oraclecloud.databaseservice.autonomous.database.backup.end
Autonomous Database - Create Begin	com.oraclecloud.databaseservice.autonomous.database.instance.create.begin
Autonomous Database - Create End	com.oraclecloud.databaseservice.autonomous.database.instance.create.end
Autonomous Database - Critical See Autonomous Database Critical, Warning, and Information Event Types for details.	com.oraclecloud.databaseservice.autonomous.database.critical
Autonomous Database - Information See Autonomous Database Critical, Warning, and Information Event Types for details.	com.oraclecloud.databaseservice.autonomous.database.information
Autonomous Database - Deregister Autonomous Database with Data Safe Begin	com.oraclecloud.databaseservice.deregisterautonomousdatabasedatasafe.begin
Autonomous Database - Deregister Autonomous Database with Data Safe End	com.oraclecloud.databaseservice.deregisterautonomousdatabasedatasafe.end
Autonomous Database - Generate Wallet	com.oraclecloud.databaseservice.generateautonomousdatabasewallet
Autonomous Database - Long-term Backup Will Expire In 24 Hours	com.oraclecloud.databaseservice.autonomous.database.backup.longtermbackupexpiresinaday.reminder
Autonomous Database - Long-term Backup Will Expire In 30 Days	com.oraclecloud.databaseservice.autonomous.database.backup.longtermbackupexpiresinamonth.reminder
Autonomous Database - Long-term Backup Will Expire In 90 Days	com.oraclecloud.databaseservice.autonomous.database.backup.longtermbackupexpiresinthreemonths.reminder
Autonomous Database - Register Autonomous Database with Data Safe Begin	com.oraclecloud.databaseservice.registerautonomousdatabasedatasafe.begin
Autonomous Database - Register Autonomous Database with Data Safe End	com.oraclecloud.databaseservice.registerautonomousdatabasedatasafe.end
Autonomous Database - Restart Begin	com.oraclecloud.databaseservice.restartautonomousdatabase.begin
Autonomous Database - Restart End	com.oraclecloud.databaseservice.restartautonomousdatabase.end
Autonomous Database - Restore Begin	com.oraclecloud.databaseservice.autonomous.database.restore.begin
Autonomous Database - Restore End	com.oraclecloud.databaseservice.autonomous.database.restore.end
Autonomous Database - Rotate Encryption Key Begin	com.oraclecloud.databaseservice.rotateautonomousdatabaseencryptionkey.begin
Autonomous Database - Rotate Encryption Key End	com.oraclecloud.databaseservice.rotateautonomousdatabaseencryptionkey.end
Autonomous Database - Start Begin	com.oraclecloud.databaseservice.startautonomousdatabase.begin
Autonomous Database - Start End	com.oraclecloud.databaseservice.startautonomousdatabase.end
Autonomous Database - Stop Begin	com.oraclecloud.databaseservice.stopautonomousdatabase.begin
Autonomous Database - Stop End	com.oraclecloud.databaseservice.stopautonomousdatabase.end
Autonomous Database - Terminate Begin	com.oraclecloud.databaseservice.deleteautonomousdatabase.begin
Autonomous Database - Terminate End	com.oraclecloud.databaseservice.deleteautonomousdatabase.end
Autonomous Database - Update Begin	com.oraclecloud.databaseservice.updateautonomousdatabase.begin
Autonomous Database - Update End	com.oraclecloud.databaseservice.updateautonomousdatabase.end
Autonomous Database - Warning See Autonomous Database Critical, Warning, and Information Event Types for details.	com.oraclecloud.databaseservice.autonomous.database.warning

Example - Autonomous Database Event

This is a reference event for an Autonomous Database:

{
  "cloudEventsVersion": "0.1",
  "eventID": "<unique_ID>",
  "eventType": "com.oraclecloud.databaseservice.autonomous.database.backup.begin",
  "source": "databaseservice",
  "eventTypeVersion": "2.0",
  "eventTime": "2019-07-10T14:06:23Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>",
    "compartmentName": "example_name",
    "resourceName": "my_database",
    "resourceId": "ocid1.autonomousdatabase.oc1.phx.<unique_ID>",
    "availabilityDomain": "SoSC:PHX-AD-3",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "cpuCoreCount": 1,
      "lifecycleState": "PROVISIONING",
      "dataStorageSizeInTBs": 1,
      "timeCreated": "2019-07-10T14:06:10.905Z",
      "timeUpdated": "2019-07-10T14:06:10.905Z",
      "serviceConsoleUrl": null,
      "licenseType": null,
      "workloadType": "<Data Warehouse | Transaction Processing>",
      "autonomousDatabaseType": "<Dedicated Infrastructure | Shared Infrastructure>"
    }
  }
 }

Autonomous Database Critical, Warning, and Information Event Types

Autonomous Databases emit critical, warning, and information event types. These event types allow you to receive notifications:

• When your database needs urgent attention (critical events)
• When an event is not critical but needs your attention to prevent it from turning critical (warning events)
• For an event that is good to be notified for your information (information events)

The critical, warning, and information event types use an additionalDetails section of the event message to provide specific details about what is happening within the Autonomous Database emitting the event. The eventType values for each of these events are listed below:

Friendly Name	Event Type
Autonomous Database - Critical	com.oraclecloud.databaseservice.autonomous.database.critical
Autonomous Database - Warning	com.oraclecloud.databaseservice.autonomous.database.warning
Autonomous Database - Information	com.oraclecloud.databaseservice.autonomous.database.information

In the following example of a critical event, you can see within the additionalDetails section of the event message that this particular message concerns an "ADMIN password expired" condition that has just ended. The eventName and description fields provide information regarding the critical situation within the "adwfinance" database:

{
  "eventType": "com.oraclecloud.databaseservice.autonomous.database.critical",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "databaseservice",
  "eventTime": "2021-12-31T12:00:38Z",
  "contentType": "application/json",
  "data": {
    "compartmentId": "<compartment id>",
    "compartmentName": "DevOpsTest",
    "resourceName": "NONDGATP",
    "resourceId": "<resource id>",
    "availabilityDomain": "EfNw:PHX-AD-1",
    "additionalDetails": {
      "systemId": "<cloud autonomous VM cluster OCID>",
      "databaseName": "adwfinance",
      "infrastructureType": "exadata",
      "description": "ADMIN user password has expired and must be reset",
      "eventName": "adminpassword.expired",
      "autonomousDatabaseType": "Dedicated Infrastructure",
      "workloadType": "Transaction Processing"
    }
  },
  "eventID": "26257ab6-5872-42d0-b5b5-cc8b2b82f0f1",
  "extensions": {
    "compartmentId": "<compartment ocid>"
  }
}

In the tables below, you can read about the conditions and operations that trigger critical, warning, and information events. Each condition or operation is identified by a unique eventName value.

Critical Events for Autonomous Database

Event	Description
adminpassword.expired	If the ADMIN password expires and is no longer usable, Autonomous Database reports an event that specifies that the ADMIN user password has expired and must be reset.
autonomous.operations.issue.detected.critical	Autonomous Dedicated Operations has detected a critical issue with your Autonomous Database and is working on it. No action is required on your part.
autonomous.operations.issue.resolved.critical	Autonomous Dedicated Operations has resolved a critical issue with your Autonomous Database. No further action is required.
wallet.expired	Your Autonomous Database wallet has expired.
wallet.rotated	Your Autonomous Database wallet has been rotated and must be downloaded.

Warning Events for Autonomous Database

Event	Description
adminpasswordexpiry.warning	Generated when Autonomous Database determines that the ADMIN password will expire within 4 weeks. You receive a warning indicating the date when the ADMIN password can no longer be used. If the password is not reset, the event is reported at most once per week. In last week daily event is sent.
autonomous.operations.issue.detected.warning	Autonomous Dedicated Operations has detected an issue with your Autonomous Database and is working on it. No action is required on your part.
autonomous.operations.issue.resolved.warning	Autonomous Dedicated Operations has resolved an issue with your Autonomous Database. No further action is required.
storagequotalimit.warning	Generated when the storage quota usage exceeds 90%.
walletexpiry.warning	Generated when Autonomous Database determines that a wallet is due to expire in less than six (6) weeks. If the wallet is not refreshed, the event is reported at most once per week. In last week daily event is sent.

Information Events for Autonomous Database

Event	Description
autonomous.operations.issue.detected.information	Autonomous Dedicated Operations has detected an issue with your Autonomous Database and is working on it. No action is required on your part.
autonomous.operations.issue.resolved.information	Autonomous Dedicated Operations has resolved an issue with your Autonomous Database. No further action is required.

Autonomous Data Guard Event Types

Review the list of event types that Autonomous Data Guard associations emit for dedicated Exadata infrastructure.

Friendly Name	Event Type
Autonomous Data Guard Association - Create Begin	com.oraclecloud.databaseservice.createautonomousdataguardassociation.begin
Autonomous Data Guard Association - Create End	com.oraclecloud.databaseservice.createautonomousdataguardassociation.end
Autonomous Data Guard Association - Critical See Autonomous Data Guard Association Critical Event Types.	com.oraclecloud.databaseservice.autonomous.container.database.dataguardassociation.critical
Autonomous Data Guard Association - Failover Begin	com.oraclecloud.databaseservice.failoverautonomousdataguardassociation.begin
Autonomous Data Guard Association - Failover End	com.oraclecloud.databaseservice.failoverautonomousdataguardassociation.end
Autonomous Data Guard Association - Reinstate Begin	com.oraclecloud.databaseservice.reinstateautonomousdataguardassociation.begin
Autonomous Data Guard Association - Reinstate End	com.oraclecloud.databaseservice.reinstateautonomousdataguardassociation.end
Autonomous Data Guard Association - Switchover Begin	com.oraclecloud.databaseservice.switchoverautonomousdataguardassociation.begin
Autonomous Data Guard Association - Switchover End	com.oraclecloud.databaseservice.switchoverautonomousdataguardassociation.end

Autonomous Data Guard Association Critical Event Types

Autonomous Data Guard associations emit critical event types. These event types allow you to receive notifications when your Autonomous Data Guard association needs urgent attention.

The eventType value for these events is com.oraclecloud.databaseservice.autonomous.container.database.dataguardassociation.critical

These events use the additionalDetails section of the event message to provide specific details about what is happening with the Autonomous Data Guard association emitting the event. In the additionalDetails section, the eventName field provides the name of the critical event.

In the table below, you can read about the conditions and operations that trigger critical events. Each condition or operation is identified by a unique eventName value.

Critical Events for Autonomous Data Guard Associations

Event	Description
rolechange.primary	Generated when an Autonomous Database changes its role from standby to primary. This role change could result from manual failover, switchover, or automatic failover.
rolechange.standby	Generated when an Autonomous Database changes its role from primary to standby. This role change could result from manual failover, switchover, or automatic failover.

---

Title and Copyright Information

Events for Autonomous Database on Dedicated Exadata Infrastructure

Copyright © 2022, 2023, Oracle and/or its affiliates. 

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.