Duplicate from active database failed with RMAN-11003: failure during parse/execution of SQL stateme
Hello everyone.
I use 11.2.0.3 EE - same version on a source and target.
cmdfile:
run{
duplicate target database to b2test from active database
skip tablespace paynet, paynet_ind, payment, payment_ind
nofilenamecheck;
}
the error message itself:
Oracle instance started
Total System Global Area 2137886720 bytes
Fixed Size 2230072 bytes
Variable Size 1224739016 bytes
Database Buffers 905969664 bytes
Redo Buffers 4947968 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''B2TEST'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
}
executing Memory Script
sql statement: alter system set db_name = ''B2TEST'' comment= ''Reset to original value by RMAN'' scope=spfile
3