Loading...

Cloning an Oracle Database

You can use the cloning feature to do the following:

  • Duplicate large databases in a short amount of time
  • Create test environments
  • Retrieve data quickly without without intensive resource use on the production environment
  • Alleviate the load on production servers

You can create a clone from an existing data and log volume full backup. When you create a clone, you must specify the reservation period. The system automatically shuts down the clone database and frees up all resources (including the snapshot clones on the storage array and ASM disk groups when the reservation period expires.

Schedule clones to run periodically so that the clones are refreshed on a regular basis.

You cannot clone an Oracle 12c container database or pluggable database.

Before You Begin

  1. Have the backup administrator configure a client, and a subclient for the clone feature.
  2. Verify that the Oracle database version on the destination database is the same as the one on the source database.
  3. Verify that the Oracle user in both the source and destination database servers have the same user ID.
  4. Install the Oracle Agent and the MediaAgent on the proxy.
  5. On the destination client where want to create the clone database, create a directory for the mount path for the database clone files. This directory must be writable by the Oracle user.
  6. If the Oracle database version is 11.2.0.3.0, 11.2.0.3.1, or 11.2.0.3.2, install Oracle patch 13366202 or the latest Oracle 11gR2 Patch Set Update on the destination database.
  7. If the Oracle database version is Oracle 12c, install a minimum version of Oracle 12.1.0.2 with patch 19404068.
  8. Optional: Create an additional instance on the destination server with the same name as of the clone database so that you can store the clone instance properties (for example, ORACLE_HOME).
  9. You can clone a database to the same or different computer. If you clone a database to an instance that resides on a proxy computer, the following criteria must be met:
    • The Oracle database version on the proxy computer must be the same as the one in the source database.
    • The proxy computer must have access to the storage array containing the source database volumes.
    • The Oracle user in both the source and destination computers must have the same user ID.
    • The Oracle Agent and the MediaAgent must be installed on the proxy.
    • You must create a dummy Oracle instance with the same name as of the source database.
  10. Perform a full backup.
  11. Set the database to the correct mode defined in the table.

    Control File in the Restore

    Required Database Mode

    Control file is included in the restore

    NOMOUNT

    Control file is not included in the restore

    MOUNT

Procedure

  1. You can clone a database on the instances page, or the manage clones page.
    • Mange clones: From the navigation pane, click Solutions > DB Instances >instance. In the upper right of the page, click Manage clones,and then on the manage clones page, click Create clone.
    • Instances: From the navigation pane, click Solutions >DB Instances , in the Actions column for the instance, click the action button action_button, and then click Instant clone.

      The General information page appears.

  2. Determine the backup that you want to clone.
    • To clone the database from the most recent time, in the Recover to area, select Most recent backup.
    • To clone the database from a point in time, under Recover to, select Point in time. Then in the From time and To time boxes, click the calendar to specify the dates.
  3. Click Next.

    The Destination Details page appears.

  4. Provide the destination information.
    1. From the Client Name list, select the client that you want the clone to be on.
    2. From the Instance Name list, select the instance that you want the clone to be on.
    3. In the Oracle Home box, type the full path to the destination Oracle home directory.
    4. In the Username box, type the user name that has access to the destination client Oracle database.
    5. In the PFile box, type the full path to the destination startup parameter file.
    6. In the Staging path box, type the full path to the location that the Oracle software uses to stage the clone.
  5. Click Next.

    The Clone options page appears.

  6. Provide the clone options.
    1. In the Clone reservation boxes, type the number of days and hours that the software retains the test environment.
    2. In the Copy Precedence box, type the precedence to use for the clone.
    3. To mask the data on the destination, select the Mask sensitive data check box, and then from the Data masking policy list, select the data masking policy.
    4. To run a script, for example a data masking script, after the clone operation, under Post clone operation, in the command file box, type the full path to the script.
  7. Click Next.

    The Summary page appears and lists the selections.

  8. Click Finish.

What to Do Next

You can control or view the job. For more information, see Jobs.

Last modified: 8/1/2018 1:21:36 PM