Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restoring RMAN backup to a different host

Fadai GanjaliyevMay 17 2010 — edited Jun 22 2010
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2010
Added on May 17 2010
11 comments
16,881 views