Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rman/TDP-tivoli/Restore to another server fails.

Rman/TDP-tivoli/Restore to another server fails.

From: chao_ping <chao_ping_at_163.com>
Date: 18 Mar 2002 15:18:53 -0600
Message-ID: <3c9659bd$1_3@spamkiller.newsgroups.com>


Rman/TDP-tivoli/Restore to another server fails.

We are using RS p680 as production database server, and f80 and test server. I backup the database to IBM tape library using TDP/TSM, and now i want to restore this backup to another F80 machine.:

I have built the dirs. TDP is setup, and i can backup database on f80 to Tape library using TDP, also able to get it back.

RMAN> run{
2> allocate channel c3 type 'sbt_tape';
3> restore controlfile;}

RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: c3 RMAN-08500: channel c3: sid=9 devtype=SBT_TAPE RMAN-08526: channel c3: Tivoli Data Protection for Oracle: version 2.2.0.2

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel c3: starting datafile backupset restore RMAN-08502: set_count=27 set_stamp=456605958 creation_time=2002/03/15 18:59:18 RMAN-08021: channel c3: restoring controlfile RMAN-08505: output filename=/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: c3 RMAN-00571:
=========================================================== RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571:
=========================================================== RMAN-03002:
failure during compilation of command RMAN-03013: command type: restore RMAN-03007: retryable error occurred during execution of command: IRESTORE RMAN-07004: unhandled exception during command execution on channel c3 RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential fi le, handle="0rdjeg86_1_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP IECE

I have already checked metalink note:1020252.102 Try using£º RMAN> run{
4> allocate channel c3 type 'sbt_tape' parms3>

   'ENV=(DSMO_NODE=s80_rman)';
5> restore controlfile;}

RMAN-03022: compiling command: allocate

RMAN> run{

6> allocate channel c3 type 'sbt_tape'
7> parms 'ENV=(TDPO_NODE=s80_rman)';
8> restore controlfile;}

I also tested using: export DSMO_NODE, export TDPO_NODE£¬ neither of them works, jsut the same error message¡£ I think i had modified tdpo.conf with the s80 machine name, and generatged the new password file.

Who can help me? Thanks.

--
an oracle fan, 
an oracle beginner

Posted via dBforums
http://dbforums.com
Received on Mon Mar 18 2002 - 15:18:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US