Re: RMAN Guru Needed - RMAN/Netbackup

From: <rabbit_at_emirates.net.ae>
Date: Mon, 24 Jun 2002 03:38:19 -0800
Message-ID: <F001.0048539D.20020624033819@fatcity.com>

I am trying to alternate host to a point in time of 01-01-2002. I restore current controlfile then run
run {
 set until time "to_date('01-JAN-2002 03:00:01','DD-MON-YYYY HH24:MI:SS')"; allocate channel ch1 type 'sbt_tape';restore database;  recover database;
 }

The netbackup log asks for a cold backup tape from 29-dec-01, restores that data (if i resetlogs its is fine), then proceeds to ask for a group of archivelogs and fails with failed to retrieve handle "al_6548_1_450965598' Backup file not found.
When I look in the logs it is not asking for a tape like it did with the first part(cold backup) and when i look at rc_backup_piece this handle is pointing to a media that has been reused. But we did a 2 weekly redo log backup on the 12-jab-02 and clear which went to another tape that is still available. When i crosscheck rc_backup_redolog I see that there are various tapes for that sequence#(which i presume is the log file number), but how do we get rman to look at the other tape ?
and why does it not ask for any tape in the logs when it wants the archivelogs ? This whole process is very confusing and piss*** me off no end. There's a pint for anyome who can help me here. I'd be interested to know also how internally rman manages which tapes to use for restore. In theory the same arcgive logs are on many different tapes, so how does it decide which one to use ? Im RTFM'ing as well
thanks

Sam

--

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

Author:
  INET: rabbit_at_emirates.net.ae

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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). Received on Mon Jun 24 2002 - 06:38:19 CDT