A better question may be to ask why is 5TB backup a challenge?
I have clients with 30TB OLTP databases that we backup FULL twice a week and
clients with 500TB EDW that we backup weekly to tape and to disk.
What problems are you having that you are asking the question for other options?
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
<mailto:Dimensional.dba@xxxxxxxxxxx> Dimensional.dba@xxxxxxxxxxx
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's
profile on LinkedIn
<http://www.dimensionaldba.com/> www.dimensionaldba.com
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Chris Taylor
Sent: Tuesday, July 12, 2016 10:42 AM
To: ORACLE-L
Subject: Looking for Suggestions - 5 TB DB WHSE Backup options
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