Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Preferences
Contact Us
Feedback
AWS Documentation
Create an AWS Account

Modifying the RDS for Oracle replica mode

PDF
RSS
Focus mode
Modifying the RDS for Oracle replica mode - Amazon Relational Database Service

To change the replica mode of an existing replica, use the console, AWS CLI, or RDS API. When you change to mounted mode, the replica disconnects all active connections. When you change to read-only mode, Amazon RDS initializes Active Data Guard.

The change operation can take a few minutes. During the operation, the DB instance status changes to modifying. For more information about status changes, see Viewing Amazon RDS DB instance status.

To change the replica mode of an Oracle replica from mounted to read-only

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

  3. Choose the mounted replica database.

  4. Choose Modify.

  5. For Replica mode, choose Read-only.

  6. Choose the other settings that you want to change.

  7. Choose Continue.

  8. For Scheduling of modifications, choose Apply immediately.

  9. Choose Modify DB instance.

Console

To change the replica mode of an Oracle replica from mounted to read-only

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

  3. Choose the mounted replica database.

  4. Choose Modify.

  5. For Replica mode, choose Read-only.

  6. Choose the other settings that you want to change.

  7. Choose Continue.

  8. For Scheduling of modifications, choose Apply immediately.

  9. Choose Modify DB instance.

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

Example

For Linux, macOS, or Unix:

aws rds modify-db-instance \
    --db-instance-identifier myreadreplica \
    --replica-mode mode

For Windows:

aws rds modify-db-instance ^
    --db-instance-identifier myreadreplica ^
    --replica-mode mode

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

Example

For Linux, macOS, or Unix:

aws rds modify-db-instance \
    --db-instance-identifier myreadreplica \
    --replica-mode mode

For Windows:

aws rds modify-db-instance ^
    --db-instance-identifier myreadreplica ^
    --replica-mode mode

To change a read-only replica to mounted mode, set ReplicaMode=mounted in ModifyDBInstance. To change a mounted replica to read-only mode, set ReplicaMode=read-only.

To change a read-only replica to mounted mode, set ReplicaMode=mounted in ModifyDBInstance. To change a mounted replica to read-only mode, set ReplicaMode=read-only.

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.