Oracle-L: RE: RMAN - problems restoring to clone server

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Thu, 30 Jan 2003 13:07:46 -0800
Message-ID: <F001.0053FA6B.20030130130746@fatcity.com>

Just offhand it looks to me like maybe you cant find the backup piece on the tape server. Talk to your tape folks and make sure that you can get to the delenn tape server from teh ariel server. They may need to put the tapes you backed up on brian into a different class or something.

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 1/30/2003 1:56 PM

The support analyst handling my TAR gave up, perhaps someone on here can

help me out...

I have an 8.0.4.4.0 database. I used RMAN to perform a full backup of my
database on server A (Brain). The RMAN recovery catalog database is on server B (Delenn). I am attempting to restore it to a 3rd instance which is
on server C (Ariel). On server C I created a new instance and it is in startup nomount currently. From server B I am attempting to restore to server C.

run {
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=delenn,NSR_CLIENT=ariel)';

set newname for datafile 1 to '/usr/oracle/DB1/datfiles/system01.dbf';
set newname for datafile 2 to '/usr/oracle/DB1/datfiles/rbs01.dbf';
set newname for datafile 3 to '/usr/oracle/DB1/datfiles/temp01.dbf';
set newname for datafile 4 to '/usr/oracle/DB1/datfiles/user01.dbf';

restore database;
release channel t1;
}

RMAN-10032: unhandled exception during execution of job step 1: ORA-06512:
at line 137
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry possible
ORA-19507: failed to retrieve sequential file, handle="Incr_level0_db_DB1_151_1.hot", parms="" ORA-27007: failed to open file
Additional information: 7009
Additional information: 2
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 925 RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE

Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gary Jackson
INET: fred_fred_1_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Freeman Robert - IL
INET: FREEMANR_at_tusc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------