Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

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 except the following:

  • EU (Frankfurt)

  • China (Beijing)

  • AWS GovCloud (US)

AWS Management 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. Choose Snapshot Actions, and then 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.

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:

Copy
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:

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

API

To upgrade an Oracle DB snapshot by using the Amazon RDS API, call the ModifyDBSnapshot action 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.

Copy
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