Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> RMAN ASM Manual Clone (not using duplicate)
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'
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
![]() |
![]() |