Clone a database to an alternate host

Contributors

You can use the clone create command to clone a database backup on an alternate host.

What you’ll need

  • Create a profile or have an existing profile.

  • Create a full backup or have an existing database backup.

  • Create a clone specification or have an existing clone specification.

Step
  1. To clone a database to an alternate host, enter the following command:

    smsap clone create -backup-label backup_label_name -newsid new_sid -host target_host -label clone_label -comment comment_text -profile profile_name -clonespec full_path_to_clonespecfile

    Oracle does not let you run two databases with the same SID simultaneously on the same host. Because of this, you must supply a new SID for each clone. However, you can have a database on another host with the same SID.