This page describes how to create a peer database for your Autonomous AI Database
in Google Cloud.
For disaster recovery planning, Oracle Database@Google Cloud lets you create the following
types of peer databases for your Autonomous AI Databases:
- Cross-region peers: standby databases in different regions. For more information, see
[Protect Autonomous Databases with cross-region disaster recovery](https://docs.cloud.google.com/oracle/database/docs/cross-region-dr-with-data-guard.md.txt).
To learn how to set up cross-region peers, see [Create a peer database](https://docs.cloud.google.com/oracle/database/docs/create-peer-database.md.txt#create-peer-database).
- Local peers: standby databases in the same region as that of your
Autonomous AI Database.
When you create an Autonomous AI Database, a local peer is automatically created.
By default, its disaster recovery type is backup-based. You can
change the disaster recovery type to [Autonomous Data Guard](https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/autonomous-data-guard-about.html#GUID-C483A35B-75F7-4368-BD36-B14E15FD36A7). For more information, see
[Manage disaster recovery type for local peers](https://docs.cloud.google.com/oracle/database/docs/manage-dr-type.md.txt).
## Before you begin
- In the OCI console, ensure that you are subscribed to the region in which you want to create the peer database.
- Ensure that you have the following Identity and Access Management (IAM) roles and
permissions required to create a peer database:
- `roles/autonomousDatabaseAdmin`
- [Create an ODB Network](https://docs.cloud.google.com/oracle/database/docs/create-odb-network.md.txt).
## Create a peer database
To create a peer database, do the following:
### Console
1. Go to the **Autonomous AI Database** page.
[Go to Autonomous AI Database](https://console.cloud.google.com/oracle/autonomous-databases/)
2. Click the name of the Autonomous AI Database for which you want to create a peer
database.
3. On the **Autonomous AI Database details** page, click the
**Disaster Recovery** tab.
4. In the **Peer database** section, click **Create**.
5. On the **Add peer database** page, 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 peer**
checkbox. 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).
> [!NOTE]
> **Note:** Replicated backups incur additional storage costs.
3. From the **Network project** list, select the project that contains
your ODB Network.
4. Select the **ODB Network**.
5. Select a **Client subnet**.
6. In the **Advanced settings** section, you can optionally modify the
following settings:
- Private IP address
- Hostname prefix
7. Click **Save**.
On the **Disaster recovery** tab, in the **Peer database** section, the
**Status** field shows you the progress of the create operation. The
peer database is ready to use when the **Status** field 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`.
When completed, you can view the new peer Autonomous AI Database in the
**Autonomous AI Databases** list along with its details. Also, after creating a
peer database in Google Cloud, you can manage and modify its network
settings in the OCI console.
## What's next
- [View peer database details](https://docs.cloud.google.com/oracle/database/docs/view-peer-databases.md.txt).
- Learn how to [switchover](https://docs.cloud.google.com/oracle/database/docs/perform-switchover.md.txt) to a a peer database.
- [Delete a peer database](https://docs.cloud.google.com/oracle/database/docs/delete-peer-database.md.txt).