Thursday, March 24, 2011

Latvian Oracle User Group and Java User Group conference 2011


I am pleased to announce that on April 14, in hotel Tallink Hotel Riga, Elizabeth Street, 24 / 1 will be LVOUG conference. For the first time it is going together with the Java User Group (JUG). This year's conference will held three parallel sessions: database technology, application development and Java technologies.


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