Oracle Cloud Infrastructure Documentation

Reconnect a Refreshable Clone to the Source Database

Shows you the steps to reconnect a disconnected clone to the source database.

After you disconnect a refreshable clone, during the following 24 hour reconnect period you can reconnect to the source database. The reconnect operation restores all the data back to that time when the clone was disconnected.

Perform the following prerequisite steps as necessary:

  • Open the Oracle Cloud Infrastructure Console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation menu click Oracle Database and then, depending on your workload click one of: Autonomous Data Warehouse, Autonomous JSON Database, or Autonomous Transaction Processing.

  • On the Autonomous Databases page select your Autonomous Database from the links under the Display name column.

Reconnect a database and restore all the data back to that time when the refreshable clone was disconnected from the source database as follows:

  1. On the Details page, from the More actions drop-down list, select Reconnect refreshable clone.

    This shows the Reconnect Refreshable Clone dialog.

  2. In the Reconnect Refreshable Clone dialog, enter the source database name to confirm.
    Note

    All data and metadata inserted, updated, or deleted from the database where you run the reconnect operation will be lost when the database is reconnected to the source database.
  3. Click Reconnect refreshable clone.

The Autonomous Database Lifecycle state changes to Updating.

When the reconnect refreshable clone operation completes, the Oracle Cloud Infrastructure Console on the clone indicates the change as follows:

  • The Mode shows Read Only.

  • If the clone was available when you initiated the reconnect operation, the Lifecycle state changes to Available.

  • If the clone was stopped when you initiated the reconnect operation, the Lifecycle state shows Stopped.

  • On the Autonomous Database Details page, the Clone Information area is updated. The Clone type shows Refreshable Clone, the Clone source shows the source database link, the Refresh link, Disconnect link, and the Refresh point shows the last refresh timestamp.

Notes for reconnecting a disconnected clone to the source database:

  • If you disconnect a refreshable clone, you have 24 hours to use the reconnect operation. After the reconnect period is over, the reconnect operation is not available. If you do not reconnect a disconnected refreshable clone, the Autonomous Database is a standard read/write database and there is no longer an option to reconnect the database to the source database.

  • Network ACLs and Private Endpoint network configuration options on a refreshable clone can be changed when the clone is disconnected from the source database. When you reconnect a refreshable clone to its source database, the reconnect operation does not restore the network ACLs or Private Endpoint network configuration options on the refreshable clone.