It really depends on your netbackup infrastructure and your network
infrastructure in between your database server and your backup infrastructure
or your remote copy on disk and your backup infrastructure.
If you have a 1GB backup network from your db server to your Netbackup
Infrastrucutre with proper tuning you can normally achieve 104MB/sec assuming
proper tuning and architecture or about 432GB/hr or in your case a 9hr full
backup.
If you have a 10Gb backup network from your db server to your Netbackup
Infrastructure with proper tuning you can normally achieve 780MB/sec assuming
proper tuning and architecture or about 2.88TB/hr or in your case a 2hr full
backup.
This is without any special equipment or SW licenses.
You also could
1. If you have the Oracle ASO for advanced compression then you can also
turn on compression in your RMAN backups and decrease the amount of data that
has to be transferred across the link.
2. look at performing mixed incrementals and partial fulls to spread a
full backup over multiple days.
3. Use the Incremental forever, although I wouldn’t recommend this.
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's
profile on LinkedIn
www.dimensionaldba.com <http://www.dimensionaldba.com/>
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Ilmar Kerm
Sent: Tuesday, July 12, 2016 3:20 PM
To: christopherdtaylor1994@xxxxxxxxx
Cc: ORACLE-L
Subject: Re: Looking for Suggestions - 5 TB DB WHSE Backup options
Hi
We do "incremental forever" backups using incrementally updated image copies
that are located on a separate disk storage than the primary database. Before
updating the image copy, we snapshot the backup filesystem to provide backup
history. Also store a second copy of the archivelogs in that same filesystem
where the image copy is located - LOG_ARCHIVE_DEST_x parameter, so no separate
archivelog backup is needed.
Tape is ruled out in this case and you also need either a storage system that
can do NFS, snapshots, compression (optional) and thin clones (Oracle ZFSSA,
Netapp, ...) or a filesystem that can do these things (ACFS, ZFS, ..?). But all
the steps needed (except storage snapshots) can be done using RMAN and no 3rd
party libraries are needed - just need to write a script to orchestrate the
steps.
Ilmar
On Tue, Jul 12, 2016 at 7:42 PM, Chris Taylor
<christopherdtaylor1994@xxxxxxxxx> 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
--
Ilmar Kerm
