Posted On: Sep 3, 2021

Starting today Amazon Relational Database Service (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 greatly 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, CLI, or 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 CLI, use the add-option-to-option-group command to add the TIMEZONE_FILE_AUTOUPGRADE option.

Amazon RDS for Oracle makes it easy to set up, operate, and scale Oracle Database deployments in the cloud. For more information on the time zone file auto upgrade option, see the documentation. See Amazon RDS for Oracle Database Pricing for regional availability.