Creating an RDS for Oracle replica in mounted mode - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Creating an RDS for Oracle replica in mounted mode

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

To create a mounted replica from a source Oracle DB instance

  1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/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 Amazon 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 to mounted in the Amazon 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.