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.