Cloning a database to an alternate host
Contributors Download PDF of this page
You can use the clone create command to clone a database backup on an alternate host.
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.
To clone a database to an alternate host, enter the following command: smo clone create -backup-label backup_label_name-newsid new_sid-host target_host-label clone_label-commentcomment_text-profileprofile_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.