RE: RMAN backup to disk and then later copy to tape

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Mon, 13 Apr 2009 11:34:51 -0600
Message-ID: <89FD2C8D7D551D4598EF20C7E42FEB45035B5E89_at_earthquake.ICAT.COM>



One issue I've encountered with this is that RMAN will not know ANYTHING about the backups on tape. So say, for example, you keep 7 days of backups on disk and then they are deleted since they have been copied to tape. If you run a crosscheck command, RMAN will mark the files that it can't find ON DISK as expired. So be careful with that. For restore, it adds an extra step in that you have to restore the files from tape to the directory they were in before attempting anything with RMAN.  

In short, there really isn't a problem, per se, with this scenario as long as you understand the implications. Oh - also pay careful attention to timing. If your tape backup comes along while the RMAN backup is still running, it's possible you would end up with an incomplete backup set on a single tape.  

hth,
-joe


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Monday, April 13, 2009 11:22 AM
To: oracle-l-freelists; oracle-db-l
Subject: RMAN backup to disk and then later copy to tape

We are looking into switching from hot backups on Windows servers to RMAN backups.  

Our intent is to use RMAN to backup to disk. At a later time, we will use Symantec Backupexec to copy the backup sets to tape.  

Anybody see a problem with doing this?    

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 13 2009 - 12:34:51 CDT

Original text of this message