RMAN ASM Manual Clone (not using duplicate)

From: <sales_at_trulymobile.co.uk>
Date: 22 May 2007 00:17:28 -0700
Message-ID: <1179818248.301774.166210@e65g2000hsc.googlegroups.com>

I need to make a copy of database dev1 to uat1, these are both on same machine, and this seems to be not working due to asm:
-both databases use asm
-DEV1 is on +DEV1 diskgroup and UAT1 should be on +UAT1 diskgroup to
-CANNOT USE DUPLICATE: need to do this using manual commands in asm as
the database is large so need to backup and copy 100gb at a time as the area on disk where i store dumps does not have enough disk space(cannot use the duplicate command)
-the ORACLE_SID and disk group name in ASM is different for both
databases.

What are steps to do this?

i did following which did not work:
-created backup of DEV1
-export ORACLE_SID=UAT1
-created uat1 init.ora (kept db_name=dev1, changed
db_unique_name=uat1)
-rman target / catalog/password_at_catalog

startup nomount
restore controlfile

set newname for file 1 to '+UAT1'
set newname for file 2 to '+UAT1'
set newname for file 2 to '+UAT1'

restore database

When i restored database, it restored the files over the PROD1 database, it seems that set newname is not having any affect). How can i get this to restore to correct place? Can i do this using db_file_convert? Any other way to do? What if i wanted both instances to reside on same asm disk group?

Kind Regards
Mark Received on Tue May 22 2007 - 02:17:28 CDT