Re: RMAN backup to disk and then later copy to tape
- From: Mark Brinsmead <pythianbrinsmead@xxxxxxxxx>
- To: fuadar@xxxxxxxxx
- 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@xxxxxxxxx> 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
> tape.
> 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@xxxxxxxxx>
> *To:* oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>; oracle-db-l <
> oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
> *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
> 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
>
--
Cheers,
-- Mark Brinsmead
Senior DBA,
The Pythian Group
http://www.pythian.com/blogs
Other related posts:
