View Patch and Maintenance Window Information, Set the Patch Level
Autonomous Database uses predefined maintenance windows to automatically patch your database. You can view maintenance and patch information and see details for Autonomous Database maintenance history. When you provision your database you can select a patch level.
- About Scheduled Maintenance and Patching
All Autonomous Database instances are automatically assigned to a maintenance window and different instances can have different maintenance windows. - View Maintenance Event History
You can view Autonomous Database maintenance event history for details about past maintenance events, such as the title, state, start time, and stop time. - View Patch Details
You can view Autonomous Database patch information, including a list of resolved issues and components. - Set the Patch Level
When you provision or clone an Autonomous Database instance you can select a patch level to apply to upcoming patches. There are two patch level options: Regular and Early. - View Maintenance Status Notifications
TheDB_NOTIFICATIONS
view stores information about maintenance status notifications for your Autonomous Database instance.
About Scheduled Maintenance and Patching
All Autonomous Database instances are automatically assigned to a maintenance window and different instances can have different maintenance windows.
Autonomous Database uses these maintenance windows to patch the entire stack used to run your database, including the database software, database dictionary, operating systems, Exadata storage, firmware, and more.
Patches include bug fixes, security fixes, and new features. Critical security fixes are always applied as soon as they are available. Patches are deployed uniformly across all databases, so you do not need to track one-off patches. After a fix for an issue is implemented, for example an issue seen in one database, the fix is deployed to all Autonomous Database instances.
All patches undergo a rigorous testing and validation process that is part of a continuous integration and development pipeline. Fixes are validated in multiple stages and environments before they are deployed to Early patch level and Always Free databases, followed by Regular patch level databases. This pipeline allows regressions to be caught and fixed before the patch is deployed to all databases. In the unlikely case that a regression is introduced, there are processes to mitigate the problem either by rolling back a subset of the patch or the entire patch itself.
The Autonomous Database Details page shows the Next Maintenance field that includes the date and time for the upcoming maintenance window; the date is updated automatically when the next maintenance window is scheduled. The View History link provides details on past maintenance. The Patch Level field shows the patch level setting for the Autonomous Database instance.
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.
Notes for scheduled maintenance and patching:
-
The Autonomous Database operations team never accesses your data unless you explicitly grant permission through a Service Request for a specified duration.
-
If your database is in the stopped state during the maintenance window, the database changes from the patch are applied when you start your database.
-
You can use Oracle Cloud Infrastructure Events to be notified when maintenance begins and ends. See Information Events on Autonomous Database for more information.
-
If you want to change the assigned maintenance window to a different 2-hour window, file a Service Request at Oracle Cloud Support. If you want a specific time period for your maintenance window, you can request the time period with the same Service Request. If you request a specific time period for your maintenance window, the change can only be made if the time period you request is available for your database.
-
If your database's allocated storage is 384 TB, you can choose a custom 2-hour window by filing a Service Request at Oracle Cloud Support (that is you can file a Service Request to request a specific day for your maintenance window).
View Maintenance Event History
You can view Autonomous Database maintenance event history for details about past maintenance events, such as the title, state, start time, and stop time.
Perform the following prerequisite steps as necessary:
-
Open the Oracle Cloud Infrastructure Console by clicking the next to Oracle Cloud.
- From the Oracle Cloud Infrastructure left navigation menu click Oracle Database and then, depending on your workload click one of: Autonomous Data Warehouse, Autonomous JSON Database, or Autonomous Transaction Processing.
-
On the Autonomous Databases page select an Autonomous Database from the links under the Display name column.
To view maintenance history, do the following:
-
Title: The name of the maintenance event.
-
Maintenance Type: Planned or Unplanned.
-
Resource Type: The type of the resource on which the maintenance event occurs: Database or Infrastructure.
-
State: Succeeded, Failed, or In progress.
-
Start Time: Maintenance start time.
-
End Time: Maintenance end time.
Maintenance event history is available starting with maintenance events after February 2021.
View Patch Details
You can view Autonomous Database patch information, including a list of resolved issues and components.
The DBA_CLOUD_PATCH_INFO
view provides patch
information related to reported bugs (bugs reported by a customer). You can use this
information to determine if a bug you reported is fixed and the patch version where
the fix was applied to your Autonomous Database instance. If there were no customer bugs in a patch,
DBA_CLOUD_PATCH_INFO
does not include any rows for that
patch.
To view patch information for a specific patch, do the following:
To view patch information for all available patches:
SELECT * FROM DBA_CLOUD_PATCH_INFO;
Notes for viewing patch information:
-
The view
DBA_CLOUD_PATCH_INFO
is available to the ADMIN user. -
Patch information and details on resolved issues is available from
ADBS-21.7.1.1
onwards (starting in July 2021). -
The view
DBA_CLOUD_PATCH_INFO
has the following columns:BUG_NUM, BUG_TITLE, COMPONENT_NAME, PATCH_VERSION
See View Maintenance Status Notifications for details about the patches applied during maintenance.
Set the Patch Level
When you provision or clone an Autonomous Database instance you can select a patch level to apply to upcoming patches. There are two patch level options: Regular and Early.
When you select patch level Early, patches are applied for the Autonomous Database instance one week before the Regular scheduled patch. The Next Maintenance field in the Oracle Cloud Infrastructure Console reflects a maintenance window date and time based on the patch level.
The default patch level for provisioning an Autonomous Database instance is Regular. The default patch level for cloning is the patch level specified for the source database. Provisioning or cloning an instance and setting the patch level to Early allows you to use and to test upcoming patches before they are applied to all systems.
When cloning a source database with Early patch level, you can only choose Early patch level for your clone.
To set the patch level, do the following:
To change the patch level, do the following:
-
You cannot change the patch level for an existing Autonomous Database instance. The option to set the patch level is only available when you provision or clone an Autonomous Database instance.
-
Change the patch level by cloning a new instance and selecting a different patch level for the cloned database. Cloning a source database with the patch level Regular to Early is allowed. Cloning a source database with the patch level Early to Regular is not allowed. See Clone an Autonomous Database Instance for more information.
Reporting Patch Issues to Oracle Support
Oracle Support provides the same handling for regular or early patch level Autonomous Databases. If you are using an Autonomous Database instance and the patch level is Early, Oracle Support considers issues you report with high priority and after validating an issue, determines if the patch should be applied or withheld from the upcoming Regular patch.
If you have an issue to report, file a service request at Oracle Cloud Support or contact your support representative.
Notes for patching level:
-
The option to set the patch level is not available in every region. In some regions all Autonomous Database instances are provisioned or cloned at the Regular patch level.
-
Autonomous Data Guard is only available for instances with patch level Regular. When you configure an Autonomous Database instance with patch level Early, you cannot enable Autonomous Data Guard.
-
Always Free Autonomous Database instances do not provide the Early patch level option.
-
When the patch level of a source Autonomous Database instance is Regular, in regions that support the Early patch level you can set the patch level of a clone to Early.
-
When the patch level of a source Autonomous Database instance is Early, you can only choose the Early patch level for your clone.
View Maintenance Status Notifications
The DB_NOTIFICATIONS
view stores
information about maintenance status notifications for your Autonomous Database instance.
To show notification information:
The following provides details about the DESCRIPTION
field values.
-
Maintenance run has ended: Specifies maintenance has completed. The
MAINTENANCE_STATUS
shows the valueCOMPLETED
with the start and end timestamps for the completed maintenance inACTUAL_START_DATE
andACTUAL_END_DATE
. -
Maintenance run is scheduled for the instance: Specifies a new maintenance has been scheduled. The
MAINTENANCE_STATUS
shows the valueSCHEDULED
with the expected start and end timestamps for the scheduled maintenance inEXPECTED_START_DATE
andEXPECTED_END_DATE
. -
Maintenance run has begun: Specifies the maintenance is in progress and provides the start timestamp for the active maintenance. The
MAINTENANCE_STATUS
shows the valueIN_PROGRESS
andACTUAL_START_DATE
stores the start timestamp.
The following table shows the DB_NOTIFICATIONS
columns
and datatypes.
Column | Datatype | Description |
---|---|---|
TYPE |
VARCHAR2(128) |
Specifies the type of the notification. Valid value is: |
TIME |
TIMESTAMP(6) WITH TIME ZONE |
Time when the notification entry was added. |
EXPECTED_START_DATE |
TIMESTAMP(6) WITH TIME ZONE |
Scheduled maintenance start time. |
EXPECTED_END_DATE |
TIMESTAMP(6) WITH TIME ZONE |
Scheduled maintenance end time. |
ACTUAL_START_DATE |
TIMESTAMP(6) WITH TIME ZONE |
Actual maintenance start time. |
ACTUAL_END_DATE |
TIMESTAMP(6) WITH TIME ZONE |
Actual maintenance end time. |
MAINTENANCE_PRODUCT |
VARCHAR2(128) |
Product/component for which maintenance is scheduled/ongoing. |
MAINTENANCE_STATUS |
VARCHAR2(128) |
Current status of the maintenance. |
DESCRIPTION
|
VARCHAR2(128) |
The notification message details. |
PATCH_ID |
VARCHAR2(128) |
Patch version. |