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

Joe has valid point about crosscheck. You may mark backup as UNAVAILABLE 
just before moving to tape to avoid backups being marked as expired. If 
you ever copy backup from tap to disk, simply mark (change) backup to 
AVAILABLE.

HTH

Thanks
Mayen






"Sweetser, Joe" <JSweetser@xxxxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Apr 13 2009 01:34 PM
Please respond to
JSweetser@xxxxxxxx


To
JBECKSTROM@xxxxxxxxx, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>, 
oracle-db-l <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
cc

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


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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
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

Other related posts: