Skip to main content
BlueXP backup and recovery
All cloud providers
  • Amazon Web Services
  • Google Cloud
  • Microsoft Azure
  • All cloud providers

Clone cloud-native Oracle databases

Contributors netapp-soumikd

You can clone an Oracle database residing on Amazon FSx for NetApp ONTAP or Cloud Volumes ONTAP using the backup of the database either to the source database host or to an alternate host.

You might clone databases for the following reasons:

  • To test functionality that must be implemented using the current database structure and content during application development cycles.

  • To populate data warehouses using data extraction and manipulation tools.

  • To recover data that was mistakenly deleted or changed.

Before you begin

You should understand the clone concepts and ensure that all the requirements are met. Learn more.

Steps

  1. Click icon to select the action corresponding to the database that you want to clone and click View Details.

  2. Click icon to select the action corresponding to the data backup and click Clone.

  3. In the Clone Details page, select one of the clone options.

  4. Depending on the option selected, perform the following actions:

    If you have selected…​ Do this…​

    Basic

    1. Select the clone host.

      If you want to create the clone on an alternate host, select the host having the same version of Oracle and OS as that of the source database host.

    2. Specify the SID of the clone.

    3. Select the clone naming scheme.

      If the database is cloned to the source host, the clone naming scheme will be auto-generated. If the database is cloned to an alternate host, clone naming scheme will be identical.

    4. Specify the Oracle home path.

    5. (Optional) Specify the database credentials.

      • Database credential: If the OS User authentication is disabled, you should provide a password for the sys user to connect to the cloned database on the same or target host.

      • ASM credential: If the OS user authentication is disabled on the target host, you should provide a sysasm privileged user's credentials to connect to the ASM instance on the target host.

        Note Ensure that the listener is up and running on the target host.

    6. Click Next.

    7. Click Clone.

    Specification file

    1. Click Download File to download the specification file.

    2. Select the clone naming scheme.

      If you select, Auto-generated, you should specify the suffix.

    3. Edit the specification file as per the requirement and upload it by clicking the Browse button.

    4. Select the clone host.

      If you want to create the clone on an alternate host, select the host having the same version of Oracle and OS as that of the source database host.

    5. Specify the SID of the clone.

    6. (Optional) Specify the database credentials.

      • Database credential: If the OS User authentication is disabled, you should provide a password for the sys user to connect to the cloned database on the same or target host.

      • ASM credential: If the OS user authentication is disabled on the target host, you should provide a sysasm privileged user's credentials to connect to the ASM instance on the target host.

        Note Ensure that the listener is up and running on the target host.

    7. Click Next.

    8. Click Clone.

  5. Click icon to select the action adjacent to Filter By and select Clone options > Clones to view the clones.