Skip to main content
SnapCenter Software 5.0

Clone Oracle database backup

Contributors netapp-soumikd
PDFs

You can use SnapCenter to clone an Oracle database using the backup of the database.

Steps

  1. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.

  2. In the Resources page, select either Database or Resource Group from the View list.

  3. Select the database.

  4. From the Manage Copies view page, select the backup from primary storage system.

  5. Select the Data backup, and then click clone icon.

  6. In the Name page, select whether you want to clone a database (CDB or non CDB) or clone a pluggable database (PDB).

  7. In the Locations page, specify the required details.

    If the Oracle database ANF volumes are configured in a manual QOS capacity pool, specify the QOS for the cloned volumes.

    If QOS for the cloned volumes is not specified, the QOS of the source volume will be used. If the automatic QOS capacity pool is used, the QOS value specified will be ignored.

  8. In the Credentials page, perform one of the following:

    1. For Credential name for sys user, select the Credential to be used for defining the sys user password of the clone database.

    2. For ASM Instance Credential name, select None if OS authentication is enabled for connecting to the ASM instance on the clone host.

      Otherwise, select the Oracle ASM credential configured with either “sys” user or a user having “sysasm” privilege applicable to the clone host.

  9. In the Pre-Ops page specify the path and arguments of the prescripts and in the Database Parameter settings section, modify the values of prepopulated database parameters that are used to initialize the database.

  10. In the Post-Ops page, Recover database and Until Cancel are selected by default to perform recovery of the cloned database.

    1. If you select Until Cancel, SnapCenter performs recovery by mounting the latest log backup having the unbroken sequence of archive logs after that data backup that was selected for cloning.

    2. If you select Date and time, SnapCenter recovers the database up to a specified date and time.

    3. If you select Until SCN, SnapCenter recovers the database up to a specified SCN.

    4. If you select Specify external archive log locations, SnapCenter identifies and mounts optimal number of log backups based on the specified SCN or the selected date and time.

    5. By default, Create new DBID check box is selected to generate a unique number (DBID) for the cloned database differentiating it from the source database.

      Clear the check box if you want to assign the DBID of the source database to the cloned database. In this scenario, if you want to register the cloned database with the external RMAN catalog where the source database is already registered, the operation fails.

    6. Select Create tempfile for temporary tablespace check box if you want to create a tempfile for the default temporary tablespace of the cloned database.

    7. In Enter sql entries to apply when clone is created, add the sql entries that you want to apply when the clone is created.

    8. In Enter scripts to run after clone operation, specify the path and the arguments of the postscript that you want to run after the clone operation.

  11. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.

  12. Review the summary, and then select Finish.

  13. Monitor the operation progress by selecting Monitor > Jobs.

Clone a pluggable database

You can clone a pluggable database (PDB) to a different or same target CDB on the same host or alternate host. You can also recover the cloned PDB to a desired SCN or date and time.

Steps

  1. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.

  2. In the Resources page, select either Database or Resource Group from the View list.

  3. Select the database of type single instance (multitenant).

  4. From the Manage Copies view page, select the backup from primary storage system.

  5. Select the backup, and then click clone icon.

  6. In the Name page, select PDB Clone and specify the other details.

  7. In the Locations page, specify the required details.

  8. In the Pre-Ops page specify the path and arguments of the prescripts and in the Database Parameter settings section, modify the values of prepopulated database parameters that are used to initialize the database.

  9. In the Post-Ops page, Until Cancel is selected by default to perform recovery of the cloned database.

    1. If you select Until Cancel, SnapCenter performs recovery by mounting the latest log backup having the unbroken sequence of archive logs after that data backup that was selected for cloning.

    2. If you select Date and time, SnapCenter recovers the database up to a specified date and time.

    3. If you select Specify external archive log locations, SnapCenter identifies and mounts optimal number of log backups based on the specified SCN or the selected date and time.

    4. By default, Create new DBID check box is selected to generate a unique number (DBID) for the cloned database differentiating it from the source database.

      Clear the check box if you want to assign the DBID of the source database to the cloned database. In this scenario, if you want to register the cloned database with the external RMAN catalog where the source database is already registered, the operation fails.

    5. Select Create tempfile for temporary tablespace check box if you want to create a tempfile for the default temporary tablespace of the cloned database.

    6. In Enter sql entries to apply when clone is created, add the sql entries that you want to apply when the clone is created.

    7. In Enter scripts to run after clone operation, specify the path and the arguments of the postscript that you want to run after the clone operation.

  10. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.

  11. Review the summary, and then select Finish.

  12. Monitor the operation progress by selecting Monitor > Jobs.

Split an Oracle database clone

You can use SnapCenter to split a cloned resource from the parent resource. The clone that is split becomes independent of the parent resource.

Steps

  1. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.

  2. In the Resources page, select Database from the View list.

  3. Select the cloned resource, (for example, the database or LUN) and then click clone icon.

  4. Review the estimated size of the clone that is to be split and the required space available on the aggregate, and then click Start.

  5. Monitor the operation progress by clicking Monitor > Jobs.

Split clone of a pluggable database

You can use SnapCenter to split a cloned pluggable database (PDB).

Steps

  1. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.

  2. Select the source container database (CDB) from the resource or resource group view.

  3. From the Manage Copies view, select Clones from the primary storage systems.

  4. Select the PDB clone (targetCDB:PDBClone) and then click clone icon.

  5. Review the estimated size of the clone that is to be split and the required space available on the aggregate, and then click Start.

  6. Monitor the operation progress by clicking Monitor > Jobs.