HI Gurus,
I am trying to duplicate the database through RMAN duplicate command.
Here I am using 11.2.0.3 with ASM. I created different diskgroup for new DB instance. When I am firing the below command its throwing below error. Please help.
[ora11g@inpudicrmrdbpbbsa1:/export]rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Aug 5 21:07:36 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: CRAMPBS2 (not mounted)
RMAN> RUN{
2> DUPLICATE DATABASE TO CRAMPBS2 BACKUP LOCATION '/export/rman'
3> SPFILE
4> PARAMETER_VALUE_CONVERT 'DATA1','DATA_PBS2','FRA','FRA_PBS2','CRAMPRD','CRAMPBS2'
5> SET INSTANCE_NUMBER='1'
6> SET CLUSTER_DATABASE='FALSE'
7> SET LOG_FILE_NAME_CONVERT 'DATA1','DATA_PBS2','FRA','FRA_PBS2'
8> SET DB_CREATE_FILE_DEST '+DATA_PBS2'
SET DB_RECOVERY_FILE_DEST '+FRA_PBS2';
9> 10> }
Starting Duplicate Db at 05-AUG-13
contents of Memory Script:
{
restore clone spfile to '/oravl01/ora11g/112_RAC/dbs/spfileCRAMPBS21.ora' from
'/export/rman/dbp_2ood3811_1_1';
sql clone "alter system set spfile= ''/oravl01/ora11g/112_RAC/dbs/spfileCRAMPBS21.ora''";
}
executing Memory Script
Starting restore at 05-AUG-13
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=2173 device type=DISK
channel ORA_AUX_DISK_1: restoring spfile from AUTOBACKUP /export/rman/dbp_2ood3811_1_1
channel ORA_AUX_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 05-AUG-13
sql statement: alter system set spfile= ''/oravl01/ora11g/112_RAC/dbs/spfileCRAMPBS21.ora''
contents of Memory Script:
{
sql clone "alter system set db_name =
''CRAMPBS2'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set control_files =
''+DATA_PBS2/oradata/CRAMPBS2/cntrl_1.dbf'', ''+DATA_PBS2/oradata/CRAMPBS2/cntrl_2.dbf'' comment=
'''' scope=spfile";
sql clone "alter system set instance_name =
''CRAMPBS22'', ''CRAMPBS21'' comment=
'''' scope=spfile";
sql clone "alter system set instance_name =
''CRAMPBS22'', ''CRAMPBS21'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_format =
''archCRAMPBS2_%r_%t_%s.arc'' comment=
'''' scope=spfile";
sql clone "alter system set rdbms_server_dn =
''cn=CRAMPBS2,dc=CRAMPRD'' comment=
'''' scope=spfile";
sql clone "alter system set INSTANCE_NUMBER =
1 comment=
'''' scope=spfile";
sql clone "alter system set CLUSTER_DATABASE =
FALSE comment=
'''' scope=spfile";
sql clone "alter system set LOG_FILE_NAME_CONVERT =
''DATA1'', ''DATA_PBS2'', ''FRA'', ''FRA_PBS2'' comment=
'''' scope=spfile";
sql clone "alter system set DB_CREATE_FILE_DEST =
''+DATA_PBS2'' comment=
'''' scope=spfile";
sql clone "alter system set db_recovery_file_dest =
''+FRA_PBS2'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''CRAMPBS2'' comment= ''duplicate'' scope=spfile
sql statement: alter system set control_files = ''+DATA_PBS2/oradata/CRAMPBS2/cntrl_1.dbf'', ''+DATA_PBS2/oradata/CRAMPBS2/cntrl_2.dbf'' comment= '''' scope=spfile
sql statement: alter system set instance_name = ''CRAMPBS22'', ''CRAMPBS21'' comment= '''' scope=spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/05/2013 21:08:17
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 08/05/2013 21:08:17
RMAN-11003: failure during parse/execution of SQL statement: alter system set instance_name = 'CRAMPBS22', 'CRAMPBS21' comment= '' scope=spfile
ORA-02095: specified initialization parameter cannot be modified
Regards,
Nikhil Mehta.