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. To learn about upgrading snapshots in preparation for the automatic upgrade of 11.2, see Migrating from SE2 to EE Using Snapshots.

The following snapshot upgrades are currently supported.

Current Snapshot Version Supported Snapshot Upgrade

12.1.0.1

12.1.0.2.v8

11.2.0.4

12.1.0.2, 12.2.0.1, 18c, and 19c, but only if the minor version is not a downgrade

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 Modify Snapshot. The Modify DB Snapshot page appears.

  4. For DB engine version, choose the 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 Modify Snapshot to save your changes.

    Alternatively, choose Cancel to cancel your changes.

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 <11.2.0.4.v12> \ --option-group-name <default:oracle-se1-11-2>

For Windows:

aws rds modify-db-snapshot ^ --db-snapshot-identifier <mydbsnapshot> ^ --engine-version <11.2.0.4.v12> ^ --option-group-name <default:oracle-se1-11-2>

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 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.

  • OptionGroupName – The option group for the upgraded DB snapshot.

Example

The following example upgrades a DB snapshot.

https://rds.amazonaws.com/ ?Action=ModifyDBSnapshot &DBSnapshotIdentifier=mydbsnapshot &EngineVersion=11.2.0.4.v12 &OptionGroupName=default:oracle-se1-11-2 &SignatureMethod=HmacSHA256 &SignatureVersion=4 &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20131016/us-west-1/rds/aws4_request &X-Amz-Date=20131016T233051Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=087a8eb41cb1ab5f99e81575f23e73757ffc6a1e42d7d2b30b9cc0be988cff97