Amazon Relational Database Service
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

Upgrading an Oracle DB Snapshot

If you have existing manual DB snapshots, you might want to upgrade a snapshot to a later version of the Oracle database engine.

When Oracle stops providing patches for a version, and therefore 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.

Current Snapshot Version Supported Snapshot Upgrade

12.1.0.1

12.1.0.2.v8

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, OS X, 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

Related Topics