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

Initiating the Oracle Data Guard switchover

PDF
RSS
Focus mode
Initiating the Oracle Data Guard switchover - Amazon Relational Database Service

You can switch over an RDS for Oracle read replica to the primary role, and the former primary DB instance to a replica role.

To switch over an Oracle read replica to the primary DB role

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the Amazon RDS console, choose Databases.

    The Databases pane appears. Each read replica shows Replica in the Role column.

  3. Choose the read replica that you want to switch over to the primary role.

  4. For Actions, choose Switch over replica.

  5. Choose I acknowledge. Then choose Switch over replica.

  6. On the Databases page, monitor the progress of the switchover.

    Monitor the progress of the Oracle Data Guard switchover.

    When the switchover completes, the role of the switchover target changes from Replica to Source.

    The source and replica databases change roles.

Console

To switch over an Oracle read replica to the primary DB role

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the Amazon RDS console, choose Databases.

    The Databases pane appears. Each read replica shows Replica in the Role column.

  3. Choose the read replica that you want to switch over to the primary role.

  4. For Actions, choose Switch over replica.

  5. Choose I acknowledge. Then choose Switch over replica.

  6. On the Databases page, monitor the progress of the switchover.

    Monitor the progress of the Oracle Data Guard switchover.

    When the switchover completes, the role of the switchover target changes from Replica to Source.

    The source and replica databases change roles.

To switch over an Oracle replica to the primary DB role, use the AWS CLI switchover-read-replica command. The following examples make the Oracle replica named replica-to-be-made-primary into the new primary database.

Example

For Linux, macOS, or Unix:

aws rds switchover-read-replica \
    --db-instance-identifier replica-to-be-made-primary

For Windows:

aws rds switchover-read-replica ^
    --db-instance-identifier replica-to-be-made-primary

To switch over an Oracle replica to the primary DB role, use the AWS CLI switchover-read-replica command. The following examples make the Oracle replica named replica-to-be-made-primary into the new primary database.

Example

For Linux, macOS, or Unix:

aws rds switchover-read-replica \
    --db-instance-identifier replica-to-be-made-primary

For Windows:

aws rds switchover-read-replica ^
    --db-instance-identifier replica-to-be-made-primary

To switch over an Oracle replica to the primary DB role, call the Amazon RDS API SwitchoverReadReplica operation with the required parameter DBInstanceIdentifier. This parameter specifies the name of the Oracle replica that you want to assume the primary DB role.

To switch over an Oracle replica to the primary DB role, call the Amazon RDS API SwitchoverReadReplica operation with the required parameter DBInstanceIdentifier. This parameter specifies the name of the Oracle replica that you want to assume the primary DB role.

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