I have an oracle database orcl1 in server dev1 which is running on asm. I have to clone it to another server dev2 which I need to be non asm. Can any body tell me what are the options available to do so? Run below command in sql to get a script. Spool it to a file. select 'copy datafile '||file_id||' to '||'''/u01/oracle/dev2/'||substr(file_name,21,instr(file_name,'.')-21)||'_01.dbf'''||';' from dba_data_files order by 1; Shut immediate; startup mount; rman target / Run the spooled file. zip backup files. backup controlfile to trace(create control file script) transfer files to dev2 create pfile for new instance. startup nomount create controlfile startup db |