RMAN question: restore backupset from tape to disk

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Wed, 16 Jul 2008 17:32:25 -0400
Message-ID: <1c8f76b90807161432j376bb3a3x5a533d537b346356@mail.gmail.com>


Hello RMAN gurus:

 is there any way through rman you can copy a backupset from disk to tape?

I have some weird situation. I have logical corruption in database ( 10.2.0.4 on solaris 10, 11.1.0.6 ASM )
so I did the following

run {
allocate channel d1 type disk;
backup check logical validate database;
release channel d1;
}

v$database_block_corruption listed 121 blocks

Then we did the following

run {
allocate channel sbt DEVICE TYPE 'SBT_TAPE' parms 'ENV=(NSR_SERVER=searchbu,NSR_GROUP=RMAN-DD)' FORMAT 'DF_%d_ID%I_%T_t%t_s%s_p%p.BKP';
blockrecover corruption list;
}

and it is getting hung while reading a backup set. Here is the log. We use networker oracle module to backup to tape.

channel sbt: restoring block(s)
channel sbt: specifying block(s) to restore from backup set restoring blocks of datafile 00004
channel sbt: reading from backup piece
DF_DVRPROD_ID3409228420_20080711_t659752995_s134_p1.BKP

Now to rule out the media or networker issues we want to first restore the backup set DF_DVRPROD_ID3409228420_20080711_t659752995_s134_p1.BKP directly to disk to see if the tape is alright. BTW networker is not reporting any errors while rman is hung.

is there any way through rman you can copy a backupset from disk to tape? we tried to user networker recover command, but it does not restore that file.

Thanks a lot for your help.
Deen

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 16 2008 - 16:32:25 CDT

Original text of this message