clone db (asm) to another server which is non asm

posted Mar 8, 2011, 6:27 AM by Sachchida Ojha
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