Re: Looking for Suggestions - 5 TB DB WHSE Backup options

On 07/12/2016 01:42 PM, Chris Taylor wrote:
> Ok, guys & gals, I'm looking for suggestions for the following
> challenge. I'm very familiar with RMAN fulls w/ incrementals writing
> either to disk or directly to tape. What I'm NOT familiar with is
> other options that I may not know of and that's where I need your help.
>
> Objective:
> Nightly backups of 5 TB Data Warehouse that is currently being
> snapshotted weekly at the SAN Layer instead of tape or disk based backups.
>
> Hardware/OS:
> IBM XIV Storage (not sure of model #)
> RedHat Linux OS (5.x)
> Oracle 11.2.0.4
> Netbackup is tape solution
>
> Method Options:
> 1. RMAN Fulls on Weekend, (either to disk or direct to tape) with
> nightly incrementals. I'm leaning toward disk based backups which are
> then written to tape and using parallel threads for the disk based
> backup to prevent overwhelming our tape library
>
> 2. Other options?
>
> Chris

Well, there aren't many options. You must do database backup to disk, so that you can use multiple channels and benefit from the disk speed, while copying to tape in the background, possibly with a considerable lag. The details are a matter of choice. Any backup software can do that. Not much to think about, really.

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


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