Creating an RDS for Oracle replica in mounted mode (original) (raw)

By default, Oracle replicas are read-only. To create a replica in mounted mode, use the console, the AWS CLI, or the RDS API.

To create a mounted replica from a source Oracle DB instance
  1. Sign in to the AWS Management Console and open the Amazon RDS console athttps://console.aws.amazon.com/rds/.
  2. In the navigation pane, choose Databases.
  3. Choose the Oracle DB instance that you want to use as the source for a mounted replica.
  4. For Actions, choose Create replica.
  5. For Replica mode, choose Mounted.
  6. Choose the settings that you want to use. For DB instance identifier, enter a name for the read replica. Adjust other settings as needed.
  7. For Regions, choose the Region where the mounted replica will be launched.
  8. Choose your instance size and storage type. We recommend that you use the same DB instance class and storage type as the source DB instance for the read replica.
  9. For Multi-AZ deployment, choose Create a standby instance to create a standby of your replica in another Availability Zone for failover support for the mounted replica. Creating your mounted replica as a Multi-AZ DB instance is independent of whether the source database is a Multi-AZ DB instance.
  10. Choose the other settings that you want to use.
  11. Choose Create replica.

In the Databases page, the mounted replica has the role Replica.

To create an Oracle replica in mounted mode, set --replica-mode to mounted in the AWS CLI command create-db-instance-read-replica.

Example

For Linux, macOS, or Unix:

aws rds create-db-instance-read-replica \
    --db-instance-identifier myreadreplica \
    --source-db-instance-identifier mydbinstance \
    --replica-mode mounted

For Windows:

aws rds create-db-instance-read-replica ^
    --db-instance-identifier myreadreplica ^
    --source-db-instance-identifier mydbinstance ^
    --replica-mode mounted

To change a read-only replica to a mounted state, set --replica-mode tomounted in the AWS CLI command modify-db-instance. To place a mounted replica in read-only mode, set--replica-mode to open-read-only.

To create an Oracle replica in mounted mode, specify ReplicaMode=mounted in the RDS API operation CreateDBInstanceReadReplica.

Preparing to create an Oracle replica

Modifying the replica mode

Did this page help you? - Yes

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Did this page help you? - No

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.