Create a peer database

Console

1. Go to the Autonomous Databasepage.

   Go to Autonomous Database

2. Click the name of the Autonomous Database for which you want to create a peer database.

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

4. In the Peer databasesection, click Create.

5. On the Add peer databasepage, do the following:

   1. Select a region. The regions in which you already have peer databases don't appear in the list.

      If you already have peer databases in all regions and no additional region appears in the list, then you can't create any more peer databases.

   2. (Optional) Select the Enable cross-region backup replication to disaster recovery peercheckbox. This option enables backup replication to your peer database for up to seven days or for the selected backup retention period (if less than seven days).

   3. From the Network projectlist, select the project that contains your ODB Network.

   4. Select the ODB Network.

   5. Select a Client subnet.

   6. In the Advanced settingssection, you can optionally modify the following settings:

      • Private IP address
      • Hostname prefix

   7. Click Save.

      On the Disaster recoverytab, in the Peer databasesection, the Statusfield shows you the progress of the create operation. The peer database is ready to use when the Statusfield shows "Standby".

gcloud

Use the gcloud oracle-database autonomous-databases create command to create a peer database.

 gcloud oracle-database autonomous-databases create PEER_DATABASE_ID 
\
     --project= PROJECT_ID 
\
     --location= REGION 
\
     --odb-subnet=projects/ ODB_NETWORK_PROJECT_ID 
/locations/ REGION 
/odbNetworks/ ODB_NETWORK_ID 
/odbSubnets/ ODB_SUBNET_ID 
\
     --source-config-automatic-backups-replication-enabled= ENABLE_BACKUP_REPLICATION 
\
     --source-config-autonomous-database=projects/ PROJECT_ID 
/locations/ REGION 
/autonomousDatabases/ PRIMARY_DATABASE_ID 
 

Replace the following:

• PEER_DATABASE_ID : a unique identifier for your peer database.
• PROJECT_ID : the ID of your Google Cloud project.
• REGION : the region in which you want to create your peer database.
• For odb-subnet property, replace the following:
  • ODB_NETWORK_PROJECT_ID : the ID of your Google Cloud project which contains your ODB Network. If you're using a Shared VPC, then this is the ID of your host project.
  • REGION : the region of your ODB Network.
  • ODB_NETWORK_ID : the ID of your ODB Network.
  • ODB_SUBNET_ID : the ID of your ODB Subnet.
• ENABLE_BACKUP_REPLICATION : (Optional) enables backup replication to your peer database for up to seven days or for the selected backup retention period (if less than seven days). The default value is false .
• For source-config-autonomous-database parameter, replace the following:
  • PROJECT_ID : the ID of your Google Cloud project which contains your primary database.
  • REGION : the region of the primary database.
  • PRIMARY_DATABASE_ID : the ID of the primary database.

API

To create a peer database, 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/ REGION 
/autonomousDatabases/ PEER_DATABASE_ID 
"
-d \
'{
  "name": "projects/ PROJECT_ID 
/locations/ REGION 
/autonomousDatabases/ PRIMARY_DATABASE_ID 
",
  "odb_subnet": "projects/ ODB_NETWORK_PROJECT_ID 
/locations/ REGION 
/odbNetworks/ ODB_NETWORK_ID 
/odbSubnets/ ODB_SUBNET_ID 
",
  "source_config": {
    "autonomous_database": "projects/ PROJECT_ID 
/locations/ REGION 
/autonomousDatabases/ PRIMARY_DATABASE_ID 
",
    "automatic_backups_replication_enabled": ENABLE_BACKUP_REPLICATION 
}
}'

Replace the following:

• PROJECT_ID : the ID of your Google Cloud project in which to create the peer database.
• REGION : the region in which to create the peer database.
• PEER_DATABASE_ID : a unique identifier for your peer database.
• For name parameter, replace the following:
  • PROJECT_ID : the ID of your Google Cloud project which contains your primary database.
  • REGION : the region of the primary database.
  • PRIMARY_DATABASE_ID : the ID of the primary database.
• For odbSubnet property, replace the following:
  • ODB_NETWORK_PROJECT_ID : the ID of your Google Cloud project which contains your ODB Network. If you're using a Shared VPC, then this is the ID of your host project.
  • REGION : the region of your ODB Network.
  • ODB_NETWORK_ID : the ID of your ODB Network.
  • ODB_SUBNET_ID : the ID of your ODB Subnet.
• For source_config parameter, replace the following:
  • PROJECT_ID : the ID of your Google Cloud project which contains your primary database.
  • REGION : the region of the primary database.
  • PRIMARY_DATABASE_ID : the ID of the primary database.
• ENABLE_BACKUP_REPLICATION : enables backup replication to your peer database for up to seven days or for the selected backup retention period (if less than seven days). The default value is false .