Perform a failover

Console

• In the event of a disaster, if your primary database is inaccessible, follow these steps:

  1. Go to the Autonomous Databasepage.

     Go to Autonomous Database

  2. Click the name of the standby peer for which you want to perform the failover operation.

  3. On the Autonomous Database detailspage, click Failover.

  4. In the Are you sure you want to failover to peer?dialog, do the following:

     1. If your primary database is not automatically detected, select the region of your primary database.
     2. Enter the ID of your primary database.
     3. Click Confirm.

• If your primary database is accessible, follow these steps:

  1. Go to the Autonomous Databasepage.

     Go to Autonomous Database

  2. Click the name of the primary database for which you want to perform the failover operation.

  3. On the Autonomous Database detailspage, select the Disaster recoverytab.

  4. For the peer database to which you want to failover, click more_vert View actions, and then click Failover.

  5. In the Are you sure you want to failover to peer?dialog, enter the ID of your primary database.

  6. Click Confirm.

After the failover is complete, the peer database becomes the "Primary" and its Statusfield shows "Available".

gcloud

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

 gcloud oracle-database autonomous-databases failover PEER_DATABASE_ID 
--project= PROJECT_ID 
--location= PEER_REGION 
--peer-autonomous-database=projects/ PROJECT_ID 
/locations/ PRIMARY_REGION 
/autonomousDatabases/ PRIMARY_DATABASE_ID 
 

Replace the following:

• PEER_DATABASE_ID : the ID of your peer database.
• PROJECT_ID : the ID of your Google Cloud project.
• PEER_REGION : the region of your peer database.
• PRIMARY_REGION : the region of your primary database.
• PRIMARY_DATABASE_ID : the ID of your primary database.

API

To perform a failover operation, run the following curl command:

curl -X POST \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/ PROJECT_ID 
/locations/ PEER_REGION 
/autonomousDatabases/ PEER_DATABASE_ID 
:failover" \
-d \
'{
  "peer_autonomous_database": "projects/ PROJECT_ID 
/locations/ PRIMARY_REGION 
/autonomousDatabases/ PRIMARY_DATABASE_ID 
"
}'

Replace the following:

• PROJECT_ID : the ID of your Google Cloud project which contains your primary database.
• PEER_REGION : the region of your peer database.
• PEER_DATABASE_ID : the ID of your peer database.
• PRIMARY_REGION : the region of your primary database.
• PRIMARY_DATABASE_ID : the ID of your primary database.