Tuesday, March 22, 2011

INTERESTING DUPLICATION IN RAC 11.2.0.2

you can't duplicate to TEST, name should be only in doble quotes. Probably reserved word in RMAN.



Environment:
ORACLE 11.2.0.2 RAC on ASM, 64 bit Linux RHEL5
TARGET DB=RTPS  (RAC DB)
AUXILIARY =TEST single instace(later RAC)

export ORACLE_SID=RTPS1
startup
export ORACLE_SID=TEST1
startup force nomount
alter system set  cluster_database=FALSE scope=spfile sid='*';

rman TARGET sys/xxxxx@RTPS  AUXILIARY /

duplicate target database to "TEST";

bla bla ....

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 2011-03-22 13:51:42



7 comments: