Posted On: Jul 30, 2021

Starting today Amazon Relational Database Service (Amazon RDS) for Oracle  supports the auto upgrade of Oracle time zone files. The Oracle time zone file auto upgrade feature provides an automated way to upgrade the DST timezone file version in the database instance. Customers observing timezones with TIMESTAMP WITH TIME ZONE data types in their databases previously had to provision a new database instance and migrate their data manually. These customers can now benefit from this feature by automating the upgrade of their current time zone file version to the latest available version in the database instance.

To enable the Oracle time zone file auto upgrade feature, customers can use the console, AWS Command Line Interface (AWS CLI) or AWS SDK. In the console, add the TIMEZONE_FILE_AUTOUPGRADE option to the option group and apply to a new or an existing database instance. In the AWS CLI, use the add-option-to-option-group command to add the TIMEZONE_FILE_AUTOUPGRADE option.

Amazon RDS makes it easy to set up, operate, and scale a relational database on AWS. For more information on the time zone file auto upgrade option, see the documentation. See Amazon RDS for Oracle Pricing for up-to-date pricing of instances, storage, data transfer and regional availability.