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.