Refresh a Refreshable Clone on Autonomous Database

Shows you the steps to refresh a refreshable clone from the Oracle Cloud Infrastructure Console.

Perform the following prerequisite steps as necessary:

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

  • From the Oracle Cloud Infrastructure left navigation menu click Oracle Database and then click Autonomous Database.

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

You can refresh a refreshable clone as follows:

  1. On the Details page, under Clone information, in the Clone source field click the Refresh link.

    This shows the Refresh clone dialog.

  2. In the Refresh clone dialog, specify the Refresh point timestamp.

    The refresh point specifies the timestamp of the source database data to which the refreshable clone is refreshed.

    Description of adb_clone_refresh_clone.png follows
    Description of the illustration adb_clone_refresh_clone.png

    The timestamp can be a minimum of 1 minute in the past and a maximum of 7 days in the past. The timestamp must be later than, that is after, the last refresh point. Thus, if you create a refreshable clone, then you would need to wait some time before you refresh the clone.

  3. Click Refresh clone.

On the Oracle Cloud Infrastructure console the Lifecycle state shows Updating until the refresh operation completes. While the database is updating connections and queries wait until the refresh completes.

You can check the status of the refresh operation by selecting the Work requests tab on the Autonomous Database details page.

On the Oracle Cloud Infrastructure Console, under Clone Information the Refresh point shows the timestamp of the source database's data that the clone was refreshed to.

Note:

Refreshable clones have a one week refresh age limit. If you do not perform a refresh within a week (7 days), the refreshable clone automatically disconnects from its source database. The refresh by date is shown in the Oracle Cloud Infrastructure Console banner. See Disconnect a Refreshable Clone from the Source Database for more information.

Parent topic: Create and Manage Refreshable Clones