~`~` Step By Step Cloning Oracle Database 10g Using RMAN`~`~ Delete existing DataFile folder in oradata location. Login to SQLprompt. SQL> shutdown abort; (target database) Now login to RMAN and set DBID: RMAN> set DBID 123456 ; (Get it from source database, by connecting RMAN.) Now, if there is no database i.e. you have just installed the target database (software only), then check if the dump destination folders are created at dump destination.Ex. - /app/oracle/admin/ULTIMUS/bdump/. Startup the database in no mount state : SQL> startup nomount; Restore pfile: SQL> restore spfile to pfile '$ORACLE_HOME/dbs/initULTIMUS.ora' from 'BACKUP_DESTINATION/autobackup/2011_06_20/o1_mf_s_744258937_6pofdsx4_.bkp’; (or copy pfile i.e. initULTIMUS.ora from live server then paste it to dbs folder, if the following command is not working). Restart the database with new pfile: SQL> startup force nomount pfile=' $ORACLE...