RE: RMAN backup to disk and then later copy to tape
- From: Mayen.Shah@xxxxxxxxxx
- To: JSweetser@xxxxxxxx
- Date: Mon, 13 Apr 2009 13:42:35 -0400
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:
