Useful new cloning features in ADB - Clone across regions, and making Refreshable Clones read/write for 24 hours

January 31, 2022 | 3 minute read
Nilay Panchal
Principal Product Manager
Text Size 100%:

As if cloning wasn't already one of the most useful database management features, earlier this year we really souped up cloning in Autonomous Database! We've introduced two new cloning features :

  1. Clone your database from any region to any other region
  2. Open a refreshable clone as read/write, for analysis and testing, and reconnect it back to its source database within 24 hours


Read on for more detail about these features as well as some screens on how to navigate to and try these  out for yourself.

Cross-Region Cloning

Until recently, you have been able to clone your database in a few simple clicks within the same region as the source database. With our recent update, databases can now be cloned (in full or metadata only) from its current, source region to any other region your tenancy is subscribed to, with the same ease of use and clone provisioning flow.

From the database you wish to clone, select "Create Clone" on the console like you would before.




Now, in the clone provisioning flow, notice the option to "Choose your Preferred Region". Once you have selected the target region you wish to clone your database to, continue on with the rest of the familiar cloning options. Once you hit Create Clone at the bottom of this screen, a new tab will open with your clone being provisioned in the target region you selected! It's that simple.


Make your Refreshable Clones read-write for 24 hours

The second cloning feature we released is the ability to turn back time on a Refreshable Clone that has been disconnected from its source database. Previously, if you needed to temporarily insert / update data on a refreshable clone for analysis or testing, which could not be done on the source production database, the only option you had was to disconnect the clone from its source or create a new clone.

Now, within a one day (ie. a 24 hour period) of a Refreshable Clone being disconnected, you may reconnect the clone to its source and continue refreshing your data. This means you may temporarily disconnect your refreshable clone and use it as a read-write cloned database for upto 1 day, before reverting it. When reconnecting, the clone's data will be restored back to the time when the clone was disconnected, so as to stay consistent with the source in future refreshes.

To reconnect a disconnected clone to its source, within the 24 hour time window you will see a banner as well as an option under "More Actions" on your database console to reconnect the cloned database to its source. Once again, note that when reconnecting the clone to its source, the data inserted, updated or deleted since the time of disconnection will be deleted, and the clone will be restored to the time when it was disonnected.


Clicking on the reconnect button, your database will go into an "Updating" state for several minutes, after which your database will be reconnected to and ready to refresh from its source database once again.


I hope these simple yet powerful cloning features come in handy to your organization to copy databases across regions and use refreshable clones for temporary updates & daily analysis. You may real all the detail about these features in the database cloning documentation.

I will catch you in the next one - Stay tuned for some major new Autonomous Database features in the coming months!


Like what I write? Follow me on the Twitter!

Nilay Panchal

Principal Product Manager

Nilay is a principal product manager at Oracle, responsible for adoption and feature development of Oracle's flagship converged cloud database - Autonomous Database. He was previously a developer and data scientist, and has a decade worth of experience in data warehousing, dimensional modeling, search engines and machine learning. A global Carnegie Mellon graduate, he has had the opportunity to work, travel and study in several different countries in various fields. His avocation is music; in his downtime he enjoys playing guitar or piano with a strong cup of chai nearby.

Nilay blogs regularly, and often speaks at cloud and database events. Follow his work on the Twitter @theproductlad

Previous Post

Check out the new LiveLabs ADB Workshop Series!

Marty Gubar | 2 min read

Next Post

Autonomous Database Newsletter - Feb 1, 2022

Keith Laker | 49 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider