Restoring RMAN backup to a different host
Brothers and sisters,
I am trying to restore an RMAN backup taken onto a tape to a different server.
I have googled this process and also searched this forum also. There is a lot of material there about this.
But the problem is that the restoration gives me errors which Oracle doc says there should be additional messages.
The matter is in my case there is not.
Here how it goes in my case:
I have two different servers and a separate Tivoli storage server.
On each of the servers I have a DB and I can successfully backup and restore each of them
individually on the tape using an RMAN catalog which is a different DB on the primary server.
This meas that the tape system can connect to each of the servers.
My restoration code is very simple and a general one
./rman target/
connect catalog ....
connect auxiliary sys/oracle@TestDB
[sql]
run{
set newname for datafile 1 ..... to ...
....................................................
DUPICATE TARGET DATABASE TO TestDB
LOGFILE GROUP 1 ('/u02/sys/redo01.log') SIZE 100M REUSE,
GROUP 2 ('/u02/sys/redo02.log') SIZE 100M REUSE,
GROUP 3 ('/u02/sys/redo03.log') SIZE 100M REUSE,
GROUP 4 ('/u02/sys/redo04.log') SIZE 100M REUSE,
GROUP 5 ('/u02/sys/redo05.log') SIZE 100M REUSE;
[sql]
and here is the output
...............................
[error]
Starting restore at 15-MAY-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=150 device type=DISK
using channel ORA_AUX_SBT_TAPE_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/15/2010 15:19:43
RMAN-03015: error occurred in stored script Memory Script
ORA-27191: sbtinfo2 returned error
Additional information: 3402
[error]
I have seen a lot of cases in google, people trying to restore and each having some messages like datafile not found, no backup found or smth of this kind i.e. they have some additionale messages, but in my case it says error in memory script but no additional messages are there execpt for "Additional information: 3402" which i dont have any idea what means and which didnt give any google results either.
Oracle version is 11g, release 1.
Friends, if anyone of you can suggest smth it is really very appreciated.
Please give some hints.
Thanks.