question about rman

I could test this myself but that would require coordination with the system administrators and they always seem to think their time is too important for testing. :)

i would like to implement RMAN in and 8.1.7.2 oltp environment and 9.2.0 warehouse environment. We use Omniback as an enterprise wide backup solution. Don't know if this is version specific so I thought I would mention. Here's the question....

Currently we are doing os level backups for both environments. We take the backup to disk and then omniback backs up the mountpoints we write to. A problem we have is that we are unable to predict when omniback will get to our backup mountpoints
due to the fact that there is a queue that serializes our backups and other servers are place in that queue ahead of us. This is a factor in our warehouse environment as it makes the downtime of a cold backup unpredictable. In the oltp environment this makes the length of backups unpredictable and GREATLY increases redo generation. The only option we have is to first backup to disk.

So here's my problem with RMAN...if we backup to disk through rman and then omniback takes that data to tape and the backup mountpoints are overwritten the very next time a backup is taken then RMAN's ability to find the necessary files is compromised if the redundancy is set to anything >1 (or whatever recovery window the translates to). So if I try and restore a database in either environment and RMAN can't find the necesary file(s) will it return a message asking where those files are? ...at which point i would call the sys admins to restore the particular file. or would i be hosed?

thank you very much for any responses.
(i plan on buying 9i rman soon but didn't want to wait on this)

chris

(wishing for dedicated tape drives)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chris Stephens
  INET: ChrisStephens_at_affina.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).