Autonomous Database offers data guard feature. You can create 1 local & 1 cross region standby databases. One of the major differences between local and remote standby database is that Autonomous Data Guard will only convert local standby to primary database in case of primary database goes down. For remote standby database, you will have to perform manual failover. Standby database is not available for read only operations.

It is very simple and straight forward process to create Autonomous Database in OCI. Oracle provides Always Free Autonomous Database (with some limitations), so you can try it out without spending any money. I will cover how to create Autonomous Database in another post.

For this post, I’m going to use existing ADB created named ADB-DEV in my tenancy compartment. I will focus on how to create cross region scenario here. Click on Autonomous Database ADB-DEV to get to details of this database as shown below.

Cross region standby database can be created by going to resources section on ADB home page. Click on Add Standby Database as shown in following figure.

Provide Region where you want to create standby database, destination compartment and click on Add Standby Database as shown in following figure.

That’s it! It will take few minutes to provision standby database. At the end status will be reported as shown below. Click on the Peer Autonomous Database name as shown in following figure.

You will find detailed information about standby database. Notice the region on the top right corner as shown in following figure.

I will go over Autonomous database cloning feature in the next post.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>