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

From: Mark Brinsmead <pythianbrinsmead_at_gmail.com>
Date: Mon, 13 Apr 2009 20:45:36 -0600
Message-ID: <cf3341710904131945w3feb9aaeu645972ad89b2e2bf_at_mail.gmail.com>

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
> 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_at_gcrta.org>
> *To:* oracle-l-freelists <oracle-l_at_freelists.org>; oracle-db-l <
> oracle-db-l_at_Groups.ITtoolbox.com>
> *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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 13 2009 - 21:45:36 CDT