Re: RMAN backup to disk and then later copy to tape
Date: Mon, 13 Apr 2009 20:45:36 -0600
Yes indeed. Backup to (disk-based) FRA, followed by BACKUP RECOVERY AREA (to tape), is the cleanest and simplest way to take care of this. It avoids the race conditions (and the risk that your backup-to-tape may be invalid because it ran too soon), and RMAN remains aware of exactly where every backup is.
The only problem is that this requires an RMAN-compatible media manager. The Original Poster referred to "BackupExec"; the last time I checked (granted, about 4 years ago) this was not compatible with RMAN. Now, if the OP was interested in stepping up to NetBackup (or any of a couple dozen other products), this would be an option. A very, very, good option.
On Mon, Apr 13, 2009 at 1:54 PM, Fuad Arshad <fuadar_at_yahoo.com> wrote:
> Whiel backup t odisk should not be a problem it all depends on how you set
> it up.
> If thisis Oracle 10 you can setup a flash recovery area to backup to disk
> and do a backup recovery area to backup the complete flash recovery area to
> if flash recovery area ia not parto f the solution.
> How do you intend to restore the data is the question.
> Are you planning to backup to disk using rman and then using filesystem
> backups to backup to tape. If so remeber rman has no idea that the backup
> is on tape since MML operations were not involved. This can be troublesome
> when recovering since you will have to manually figure out what tpae has the
> backup and then restore it to a point where rman can recoverit.
> A VTL can normally help in this scenario since while it makes rman think
> its backing up to tape but the actual backup happens to disk with an
> automatic tape offload at a later point. Rman and the MML interact and talk
> to each other thus making restores a breeze.
> *From:* Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
> *To:* oracle-l-freelists <oracle-l_at_freelists.org>; oracle-db-l <
> *Sent:* Monday, April 13, 2009 12:21:55 PM
> *Subject:* RMAN backup to disk and then later copy to tape
> We are looking into switching from hot backups on Windows servers to RMAN
> 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
-- Cheers, -- Mark Brinsmead Senior DBA, The Pythian Group http://www.pythian.com/blogs -- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 13 2009 - 21:45:36 CDT