Creating and Managing Snapshots of a Database Deployment

Not Oracle Cloud Infrastructure This topic does not apply to Oracle Cloud Infrastructure.

On database deployments hosting a single-instance database, Oracle Database Classic Cloud Service supports the creation of storage snapshots, which you can then use to create new database deployments called linked clones.

When you create a storage snapshot, the database deployment is put into maintenance status and a snapshot of all the storage volumes for the deployment is taken. Then, when you create a linked clone deployment, Database Classic Cloud Service creates a new database deployment whose storage volumes are from the snapshot.

Using the “copy on write” technology that Oracle Compute Cloud Service supports for storage volume snapshots, the file data on the linked clone deployment can change without changing the snapshot itself. Thus, you can create several linked clones from the same snapshot to use for application testing or branched application development work.

Creating a Snapshot

  1. Go to the Snapshots page of the deployment you want to create a snapshot of:

    1. Open the Oracle Database Classic Cloud Service console.

      For detailed instructions, see Accessing the Oracle Database Classic Cloud Service Console.

    2. Click the name of the deployment you want to create a snapshot of.

      The Oracle Database Classic Cloud Service Overview page is displayed.

    3. Click the Administration tile and then click the Snapshots tab.

      The Oracle Database Classic Cloud Service Snapshots page is displayed. Any snapshots already created for the deployment are shown in the Available Storage Snapshots list.

  2. Click Create Storage Snapshot. In the Create Storage Snapshot window that is displayed, enter a name (and, optionally, a description) for the snapshot and then click Create.

    In the next window that is displayed, confirm that you want to put the database deployment into maintenance mode and create the snapshot by clicking Create.

Listing Linked Clone Database Deployments Created from a Snapshot

  1. Go to the Snapshots page of the deployment whose snapshot you want to see linked clone deployments of:

    1. Open the Oracle Database Classic Cloud Service console.

      For detailed instructions, see Accessing the Oracle Database Classic Cloud Service Console.

    2. Click the name of the deployment whose snapshot you want to see linked clone deployments of.

      The Oracle Database Classic Cloud Service Overview page is displayed.

    3. Click the Administration tile and then click the Snapshots tab.

      The Oracle Database Classic Cloud Service Snapshots page is displayed.

  2. In the Available Storage Snapshots list, locate the snapshot you’re interested in and check the value displayed next to Linked Clones.

    If the value is zero, no linked clone deployments have been created from the snapshot. Otherwise, click expand before Linked Clones to view the list of linked clone deployments.

    When viewing the list of linked clone deployments, you can click the name of a deployment to go directly to that deployment’s Overview page.

Deleting a Snapshot

Note:

You cannot delete a snapshot that has linked clone database deployments created from it. You must first delete the linked clone deployments, as described in Deleting a Database Deployment.

  1. Go to the Snapshots page of the deployment whose snapshot you want to delete:

    1. Open the Oracle Database Classic Cloud Service console.

      For detailed instructions, see Accessing the Oracle Database Classic Cloud Service Console.

    2. Click the name of the deployment whose snapshot you want to delete.

      The Oracle Database Classic Cloud Service Overview page is displayed.

    3. Click the Administration tile and then click the Snapshots tab.

      The Oracle Database Classic Cloud Service Snapshots page is displayed.

  2. In the Available Storage Snapshots list, locate the snapshot you want to delete and choose Delete from that snapshot’s action menu.

  3. In the Delete Storage Snapshot window, confirm that you want to delete the snapshot by clicking Delete.

    If the window warns you that you cannot delete the snapshot because there are database deployments cloned from it, click Close and then delete the linked clone deployments before trying to delete the snapshot.