Skip to main content
NetApp Backup and Recovery

Clone Oracle Database workloads using NetApp Backup and Recovery

Contributors netapp-mwallis
PDFs

Use NetApp Backup and Recovery to create writeable clones of Oracle databases from on-premises ONTAP systems to primary or secondary storage. Manage the lifecycle of clones so that they are periodically refreshed according to a schedule.

Required Console role
Backup and Recovery super admin or Backup and Recovery backup admin role. Learn about NetApp Console access roles for all services.

Create a clone of an Oracle database

Create a clone immediately from an existing snapshot. Use this method to create a one-time clone that is not continuously refreshed from a snapshot.

Steps

  1. From the NetApp Console menu, select Protection > Backup and Recovery.

  2. Under Workloads, select the Oracle tile.

  3. Select Clone.

  4. Select Create new clone.

  5. In the Database source section, choose the source host and database from the lists.

  6. In the Database target section, choose the target host and database from the lists. The destination host and database can be different from the source.

  7. Select Next.

  8. In the Clone from section on the Select restore point page, select Existing snapshots.

  9. Choose an existing snapshot (restore point) from the list to use as a base for the clone and select Next.

    The Select snapshot location appears if the snapshot is stored in more than one location.

  10. Choose the snapshot location to use and select Next.

  11. On the Advanced options page, do the following:

    1. If you have previously saved a specification file, you can upload it to customize the cloned database settings. You can also download the default specification file for the database snapshot.

    2. In the Recovery scope section, choose how to limit what is restored to create the clone and enter the required information for the option you choose. Choosing None restores all data.

    3. In the Prescripts and postscripts section, enable one or both of the Prescript and Postscript options to execute a script before the clone operation begins or after it completes. For each option, enter the full script path and any required arguments.

  12. Select Clone.

Schedule a clone of an Oracle database

Schedule an instant clone creation and continuous refresh of the clone. This creates the most up-to-date possible clone of the database. Use this method if you want to continuously refresh the clone from the latest state of the database according to a schedule you choose.

Steps

  1. From the NetApp Console menu, select Protection > Backup and Recovery.

  2. Under Workloads, select the Oracle tile.

  3. Select Clone.

  4. Select Create new clone.

  5. In the Database source section, choose the source host and database from the lists.

  6. In the Database target section, choose the target host and database from the lists. The destination host and database can be different from the source.

  7. Select Next.

  8. In the Clone from section on the Select restore point page, select Instant snapshot and clone.

  9. Choose a location to store the snapshot when it is created.

  10. Select Next.

  11. On the Advanced options page, do the following:

    1. To customize the cloned database settings, enable the Customize target database parameters option. If you have previously saved a specification file, this option enables you to upload it to customize the cloned database settings. You can also download the default specification file for the database that reflects its current settings.

    2. In the Clone refresh schedule section, choose when and how often to refresh the clone. Refreshing the clone recreates the instant snapshot and overwrites the existing clone with a new clone.

    3. In the Prescripts and postscripts section, enable one or both of the Prescript and Postscript options to execute a script before the clone operation begins or after it completes. For each option, enter the full script path and any required arguments.

  12. Select Clone.

Split a clone

You can split a clone of your Oracle Database workloads. Splitting a clone creates a new backup from the clone. You can use the new backup to restore databases.

You can choose to split a clone as independent or long-term clones. A wizard shows the list of aggregates that are part of the SVM, their sizes, and where the cloned volume resides. NetApp Backup and Recovery also indicates whether there is enough space to split the clone. After the clone is split, the clone becomes an independent database for protection.

The clone job is not removed and it can be reused again for other clones.

Steps

  1. From the NetApp Backup and Recovery menu, select Clone.

  2. Select a clone.

  3. Select the Actions icon Actions option > Split clone.

  4. Review the split clone details and select Split.

  5. When the split clone is created, you can view it in the Inventory page.

Delete a clone

You can delete a clone of your Oracle Database workloads. When you delete a clone, it is removed from the object store, freeing up storage space.

If a policy protects the clone, both the clone and its job are deleted.

Steps

  1. From the NetApp Backup and Recovery menu, select Clone.

  2. Select a clone.

  3. Select the Actions icon Actions option > Delete clone.

  4. In the clone Delete confirmation dialog box, review the deletion details.

    1. To delete the cloned resources from SnapCenter even if the clones or their storage is not accessible, select Force delete.

    2. Select Delete.

  5. When the clone is deleted, it is removed from the Inventory page.