Clone from ASM to non ASM. [message #445076] |
Thu, 25 February 2010 11:17 |
ridhi_sundar
Messages: 184 Registered: November 2007 Location: Bangalore
|
Senior Member |
|
|
Hi
I have an oracle database orcl1 in server app1 which is running on asm. I have to clone it to another server app2 which I need to be nonasm. Can any body tell me what are the options available to do so?
Thanks in advance.
Ridhi Sundar
|
|
|
|
Re: Clone from ASM to non ASM. [message #445080 is a reply to message #445076] |
Thu, 25 February 2010 12:30 |
ridhi_sundar
Messages: 184 Registered: November 2007 Location: Bangalore
|
Senior Member |
|
|
Hi Mahesh
I could not follow what you said.
I got 1 way.
below are the steps.
Quote:
Run below command in sql to get a script. Spool it to a file.
select 'copy datafile '||file_id||' to '||'''/app/oracle/TEST/'||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 apps2
create pfile for new instance.
startup nomount
create controlfile
startup db
Thanks
Ridhi Sundar
|
|
|
|
|
|