Hi,
I wonder if anyone can help me. My environment is Linux and the Oracle version is 11.2.0.3.0. I am attempting to clone a database from one server to another utilising a tape backup (not from active database). I have set up the relevant TNS entries, so the two systems can communicate. I created a password file and a PFILE in the destination server and I started up (NOMOUNT) the instance.
Initially I attempted the operation from the destination server; I received error such as: RMAN-06100: no channel to restore a backup or copy of datafile 11
Suspecting that the destination server may not have the appropriate access level in the MLL, I attempted the operation from the source server.
But I am getting: RMAN-06101: no channel to restore a backup or copy of the control file
Source database: MM1
Destination (cloned) database: MBA
RMAN script
------------------
connect target /
connect auxiliary sys/********@MBA
run {
allocate channel 'dev_01' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
allocate channel 'dev_02' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
allocate channel 'dev_03' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
allocate channel 'dev_04' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE disk;
set until time "to_date('14-aug-2013:16:20','dd-mon-YYYY:hh24:mi')";
DUPLICATE TARGET DATABASE TO MBA NOFILENAMECHECK;
release channel c1;
release channel 'dev_01';
release channel 'dev_02';
release channel 'dev_03';
release channel 'dev_04';
}
Log:
------
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Aug 15 11:27:24 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN>
RMAN>
connected to target database: MM1 (DBID=1713891644)
RMAN>
connected to auxiliary database: MBA (not mounted)
RMAN>
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>
using target database control file instead of recovery catalog
allocated channel: dev_01
channel dev_01: SID=188 device type=SBT_TAPE
channel dev_01: Data Protector A.06.20/PHSS_42081/PHSS_42082/DPSOL_00448/DPLNX_
allocated channel: dev_02
channel dev_02: SID=17 device type=SBT_TAPE
channel dev_02: Data Protector A.06.20/PHSS_42081/PHSS_42082/DPSOL_00448/DPLNX_
allocated channel: dev_03
channel dev_03: SID=191 device type=SBT_TAPE
channel dev_03: Data Protector A.06.20/PHSS_42081/PHSS_42082/DPSOL_00448/DPLNX_
allocated channel: dev_04
channel dev_04: SID=31 device type=SBT_TAPE
channel dev_04: Data Protector A.06.20/PHSS_42081/PHSS_42082/DPSOL_00448/DPLNX_
allocated channel: c1
channel c1: SID=161 device type=DISK
executing command: SET until clause
Starting Duplicate Db at 15-AUG-13
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 6631034880 bytes
Fixed Size 2240744 bytes
Variable Size 2315259672 bytes
Database Buffers 4294967296 bytes
Redo Buffers 18567168 bytes
allocated channel: c1
channel c1: SID=11 device type=DISK
contents of Memory Script:
{
set until scn 208772810;
sql clone "alter system set db_name =
''MM1'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''MBA'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script
executing command: SET until clause
sql statement: alter system set db_name = ''MM1'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''MBA'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 6631034880 bytes
Fixed Size 2240744 bytes
Variable Size 2315259672 bytes
Database Buffers 4294967296 bytes
Redo Buffers 18567168 bytes
allocated channel: c1
channel c1: SID=160 device type=DISK
Starting restore at 15-AUG-13
released channel: dev_01
released channel: dev_02
released channel: dev_03
released channel: dev_04
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/15/2013 11:28:44
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06101: no channel to restore a backup or copy of the control file
RMAN>
RMAN>
Recovery Manager complete.