Home » RDBMS Server » Backup & Recovery » Clone from ASM to non ASM. (RHEL-5, Oracle 11.2.0.1.0, )
Clone from ASM to non ASM. [message #445076] Thu, 25 February 2010 11:17 Go to next message
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 #445078 is a reply to message #445076] Thu, 25 February 2010 11:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No difference from the regular RMAN duplication.
Just use something like this
DB_FILE_NAME_CONVERT=+ASM,/data/wherever 
LOG_FILE_NAME_CONVERT=+ASM,/data/wherever
Re: Clone from ASM to non ASM. [message #445080 is a reply to message #445076] Thu, 25 February 2010 12:30 Go to previous messageGo to next message
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


Re: Clone from ASM to non ASM. [message #445081 is a reply to message #445080] Thu, 25 February 2010 13:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Well, I thought you were talking about RMAN duplication/cloning.
What you are doing is just cold copy.
With 11gR2 you can just a cp in asmcmd (from asm to a generic filesystem)
Re: Clone from ASM to non ASM. [message #445082 is a reply to message #445080] Thu, 25 February 2010 13:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/asm_util.htm#CHDJEIEA
Re: Clone from ASM to non ASM. [message #445085 is a reply to message #445076] Thu, 25 February 2010 14:15 Go to previous message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Thanks for your help Mahesh. I was not sure if ASMCMD> cp comand will be working for cold copy.

Thanks
Ridhi Sundar
Previous Topic: Archive logs too big in size
Next Topic: Database Recover
Goto Forum:
  


Current Time: Tue Apr 16 14:36:08 CDT 2024