Perform a switchover

This page describes how to perform a switchover to a peer Autonomous Database in Google Cloud. You can perform a switchover through both Google Cloud and OCI.

If the Primary Autonomous Database is down, you can perform a switchover from the peer (Standby) database.

Before you begin

Ensure that you have the following roles and permissions required to perform a switchover:

  • roles/autonomousDatabaseAdmin

Perform a Switchover

To switchover to a peer database, do the following:

Console

  1. Go to the Autonomous Databasepage.

    Go to Autonomous Database

  2. Click the name of the primary Autonomous Database on which you want to perform a switchover operation.

  3. On the Autonomous Database detailspage, click the Disaster Recoverytab.

  4. In the Peer databasesection, for the peer database that you want to switchover to, click View actions, and then click Switchover.

  5. In the Confirm switchover to peerdialog, enter the peer database name and click Confirm.

    On the Disaster recoverytab, in the Peer databasesection, the Statusfield shows you the progress of the switchover operation. After the switchover is complete, the peer database becomes the "Primary" and its Statusfield shows "Available". Whereas, the former Primary Autonomous Database becomes the "Standby".

    If you initiated the switchover in the OCI console, you can still see the progress of the switchover in the Google Cloud console.

gcloud

Use the gcloud oracle-database autonomous-databases switchover command to perform a switchover.

 gcloud oracle-database autonomous-databases switchover DATABASE_ID 
--project= PROJECT_ID 
--location= REGION 
--peer-autonomous-database=projects/ PROJECT_ID 
/locations/ REGION 
/autonomousDatabases/ PEER_DATABASE_ID 
 

Replace the following:

  • DATABASE_ID : the ID of your database.
  • PROJECT_ID : the ID of your Google Cloud project.
  • REGION : the region of your peer database.
  • PEER_DATABASE_ID : the ID of your peer database.

What's next

Create a Mobile Website
View Site in Mobile | Classic
Share by: