Symptoms

When copying an Oracle RDS snapshot, you may encounter the following error message:

The snapshot requires a target option group with the following options: [Timezone]

This can occur when the option group associated with the source RDS snapshot includes the "Timezone" option, but you are not specifying an option group to assign to the new RDS snapshot.

When copying that snapshot, AWS requires that the option group assigned to the copy also include the "Timezone" option.

Alternative Symptoms

Similarly, when copying an Oracle RDS snapshot, you may encounter the following error message:

Option group <name> is missing the following options: [Timezone]

This can occur when the option group to be associated with the target RDS snapshot does not include the "Timezone" option.

Resolution

If you are not specifying an option group when copying the RDS snapshot, you must create and specify an option group:

  1. Create an RDS option group in the AWS region to which the snapshot will be copied.
  2. Add the "Timezone" option to the new RDS option group.
  3. Specify the new option group name when copying the RDS snapshot.

If you are already specifying an option group, you must add the "Timezone" option:

  1. Add the "Timezone" option to the RDS option group in the target AWS region.

Additional Notes

This requirement appears to have started February 22, 2019.

Did this answer your question?