Skip to Main Content

Database Software

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!

restore database to new server

user641444Feb 23 2011 — edited Feb 23 2011
Hi,

today I wanted to test a restore to a new server.

DB=10.2.0.4
rman catalog is used
backup on TSM Tape


First I configured the new server to use the same TSM backup node as the original server.
tdpoconf showenv is ok.

Then I checked Meatlink 419137.1 and copied the pfile to the new server and changed the xxx_dest parameter.

Now I want to restore the controlfile.

RMAN> run {
2> allocate channel ch1 device type sbt;
3> restore controlfile;
4> }

released channel: ORA_SBT_TAPE_1
released channel: ORA_DISK_1
allocated channel: ch1
channel ch1: sid=154 devtype=SBT_TAPE
channel ch1: Data Protection for Oracle: version 5.3.3.0

Starting restore at 23-FEB-11

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/23/2011 12:47:27
ORA-27191: sbtinfo2 returned error
Additional information: 2



RMAN> list backup of controlfile;

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
839079 Incr 1 18.25M SBT_TAPE 00:00:05 22-FEB-11
BP Key: 839082 Status: AVAILABLE Compressed: NO Tag: TAG20110222T180016
Handle: INC1_WORX_24789_743796123_1 Media: 97852
Control File Included: Ckp SCN: 8267760886177 Ckp time: 22-FEB-11



obviously there is a control file!
I also tried to set the dbid from the server who made the backup

RMAN> set dbid=1324742276;

executing command: SET DBID
run {
database name is "WORX" and DBID is 1324742276

RMAN> 2> allocate channel ch1 device type sbt;
3> restore controlfile;
4> }

allocated channel: ch1
channel ch1: sid=154 devtype=SBT_TAPE
channel ch1: Data Protection for Oracle: version 5.3.3.0

Starting restore at 23-FEB-11

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/23/2011 12:50:03
ORA-27191: sbtinfo2 returned error
Additional information: 2


what's wrong?

br
Daniel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2011
Added on Feb 23 2011
2 comments
309 views