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.
Thursday, March 24, 2011
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
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
Subscribe to:
Posts (Atom)