20 Maintenance Windows, Time Zone Data Updates, Work Requests, and Managing Events and Notifications

Oracle Cloud Infrastructure Events enable you to create automation based on state changes for resources. Oracle Cloud Infrastructure work requests allow you to monitor long-running operations such as cloning or backing up an Autonomous Data Warehouse database. The Oracle Cloud Infrastructure Console provides information on Autonomous Database maintenance windows. Also describes information about time zone data file updates.

About Events and Notifications

An event could be a resource lifecycle state change or a system event impacting a resource. For example, an event can be emitted when a backup or restore operation begins or ends. You can use events to manage actions, including notifications and other actions.

See Overview of Events for more information.

About Work Requests

Autonomous Databases support Oracle Cloud Infrastructure Work Requests. A work request is an activity log that enables you to track each step in an operation's progress. Each work request has an Oracle Cloud Identifier (OCID) that allows you to interact with it programmatically.

Autonomous Database work requests are created for the following operations:
  • Creating or terminating an Autonomous Database instance
  • Starting or stopping an Autonomous Database instance
  • Restoring an Autonomous Database instance
  • Cloning an Autonomous Database instance
  • Creating or deleting manual backups.
  • Scaling database storage or CPU
  • Updating the database license type
  • Updating a database's network access control list (ACL)

Under Resources on the Oracle Cloud Infrastructure console click Work Requests to see recent work requests.

Click the link under Operation to see more details for a work request.

Description of adwc_work_request_details.png follows
Description of the illustration adwc_work_request_details.png

See Work Requests Integration for more information.

About Autonomous Database Maintenance Windows

Autonomous Database uses predefined maintenance windows to automatically patch your database.

All Autonomous Database instances are automatically assigned to a maintenance window and different instances can have different maintenance windows. On the Autonomous Database details page, the Next Maintenance field shows the date and time for the upcoming maintenance window; this field is updated automatically when the next maintenance window is scheduled.


Your database remains available during the maintenance window. Your existing database connections may get disconnected briefly; however, you can immediately reconnect and continue using your database.
Description of adwc_console_maint.png follows
Description of the illustration adwc_console_maint.png

Manage Time Zone File Version on Autonomous Database

For time zone support, Oracle Database uses time zone files that store the list of all time zones. The time zone files for Autonomous Database are periodically updated to reflect the latest time zone specific changes.

Autonomous Database automatically picks up updated time zone files depending on the state of the instance:

  • Stopped: At the next start operation the update is automatically applied.

  • Available: After a restart the update is automatically applied.

When a load or import operation results in the following timezone related error, restart your instance and try again:

ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version n+1 
into a target database with TSTZ version n.

The restart operation upgrades the time zone file to the latest version available for your database. The columns in your database with the datatype TIMESTAMP WITH TIME ZONE are converted to the new time zone version during the restart. See TIMESTAMP WITH TIME ZONE Data Type for more information.