Task: To Clone database TCCBAMT1 from TCCBAMT2.
command used:
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby1 type disk;
DUPLICATE DATABASE TO TCCBAMT1 FROM ACTIVE DATABASE;
}
failed at: (entire log file attached)
RMAN-03002: failure of Duplicate Db command at 02/02/2017 04:37:04
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
ORA-00349: failure obtaining block size for '+RDO1'
ORA-15001: diskgroup "RDO1" does not exist or is not mounted
ORA-15001: diskgroup "RDO1" does not exist or is not mounted
ORA-15001: diskgroup "RDO1" does not exist or is not mounted
I checked the errors and identified the potential issue and did the below changes in the spfile (auxiliary).
original values in spfile
*.db_create_online_log_dest_1='+RDO1'
*.db_create_online_log_dest_2='+RDO2'
changed to
*.db_create_online_log_dest_1='+DATA1'
*.db_create_online_log_dest_2='+FRA1'
Now as per the document I restarted from step 3. (not sure).
Manual Completion of a Failed RMAN Duplicate FROM ACTIVE DATABASE ( Doc ID 1602916.1 )
After starting from step 3:
run {
set until sequence 2431;
recover clone database;
alter clone database open resetlogs;
}
&
run {
sql clone "alter system set db_name = ''TCCBAMT1'' scope=spfile";
shutdown clone immediate;
startup clone force mount
}
both failed with the below error.
RMAN-06402: Oracle instance shut down
RMAN-06196: Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 02/02/2017 16:16:14
RMAN-06136: ORACLE error from auxiliary database: ORA-01103: database name 'TCCBAMT2' in control file is not 'TCCBAMT1'
a) was the fix correct? (changing db_create_online_log_dest_1). Was this the reason why the duplicate failed?
b) If so which step should I resume the rman duplicate. (based on ( Doc ID 1602916.1 ) .
c) How do I fix the current issue? ORA-01103:
I also read the following document but couldn't get much help.
RMAN-06136: ORACLE error from auxiliary database: ORA-01103: database name 'XXXXXX' in control file is not 'YYYYYY' (Doc ID 2151821.1)