Upgrading an Oracle DB snapshot - Amazon Relational Database Service

Upgrading an Oracle DB snapshot

If you have existing manual DB snapshots, you can upgrade them to a later version of the Oracle database engine.

When Oracle stops providing patches for a version, and Amazon RDS deprecates the version, you can upgrade your snapshots that correspond to the deprecated version. For more information, see Oracle engine version management.

The following snapshot upgrades are currently supported. You can't upgrade a snapshot and downgrade the minor version. For example, you can't upgrade a snapshot from the 11.2.0.4 October 2020 PSU to the 19.0 July 2020 PSU.

Current snapshot version Supported snapshot upgrade

12.1.0.1

12.1.0.2.v8

11.2.0.4

  • 19.0.0.0.ru-2020-07.rur-2020-07.r1

  • 19.0.0.0.ru-2020-10.rur-2020-10.r1

  • 12.2.0.1.ru-2020-10.rur-2020-10.r1

  • 12.2.0.1.ru-2020-07.rur-2020-07.r1

  • 12.1.0.2.v22

  • 12.1.0.2.v21

18.0.0.0

19.0.0.0.ru-2021-04.rur-2021-04.r1

11.2.0.3

11.2.0.4.v11

11.2.0.2

11.2.0.4.v12

Amazon RDS supports upgrading snapshots in all AWS Regions.

Console

To upgrade an Oracle DB snapshot

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the navigation pane, choose Snapshots, and then select the DB snapshot that you want to upgrade.

  3. For Actions, choose Upgrade snapshot. The Upgrade snapshot page appears.

  4. Choose the New engine version to upgrade the snapshot to.

  5. (Optional) For Option group, choose the option group for the upgraded DB snapshot. The same option group considerations apply when upgrading a DB snapshot as when upgrading a DB instance. For more information, see Option group considerations.

  6. Choose Save changes to save your changes.

    During the upgrade process, all snapshot actions are disabled for this DB snapshot. Also, the DB snapshot status changes from available to upgrading, and then changes to active upon completion. If the DB snapshot can't be upgraded because of snapshot corruption issues, the status changes to unavailable. You can't recover the snapshot from this state.

    Note

    If the DB snapshot upgrade fails, the snapshot is rolled back to the original state with the original version.

AWS CLI

To upgrade an Oracle DB snapshot by using the AWS CLI, call the modify-db-snapshot command with the following parameters:

  • --db-snapshot-identifier – The name of the DB snapshot.

  • --engine-version – The version to upgrade the snapshot to.

You might also need to include the following parameter. The same option group considerations apply when upgrading a DB snapshot as when upgrading a DB instance. For more information, see Option group considerations.

  • --option-group-name – The option group for the upgraded DB snapshot.

Example

The following example upgrades a DB snapshot.

For Linux, macOS, or Unix:

aws rds modify-db-snapshot \ --db-snapshot-identifier mydbsnapshot \ --engine-version 19.0.0.0.ru-2020-10.rur-2020-10.r1 \ --option-group-name default:oracle-se2-19

For Windows:

aws rds modify-db-snapshot ^ --db-snapshot-identifier mydbsnapshot ^ --engine-version 19.0.0.0.ru-2020-10.rur-2020-10.r1 ^ --option-group-name default:oracle-se2-19

RDS API

To upgrade an Oracle DB snapshot by using the Amazon RDS API, call the ModifyDBSnapshot operation with the following parameters:

  • DBSnapshotIdentifier – The name of the DB snapshot.

  • EngineVersion – The version to upgrade the snapshot to.

You might also need to include the OptionGroupName parameter. The same option group considerations apply when upgrading a DB snapshot as when upgrading a DB instance. For more information, see Option group considerations.