I’m used to doing the time finder (EMC BCV or SRDF to another frame) or Shadow Image (Hitachi’s equivalent) to sync all the disks to a mirror then split the
mirror and mount it on another server for the backup. That works quite well. We do that nightly. We put the source DB in “hot backup mode” before doing the split each night and on Sunday morning at 2 AM we actually shut down the DB to do a “cold backup”
but the disk array steps are the same. In “hot backup mode” Oracle continues to allow activity which is written to the archive logs but not committed to the live database. Once you take Oracle out of “hot backup mode” it commits what was writing to the archive
logs.
Since SRDF goes to another frame (and I believe Hitachi’s Shadow Image will allow this as well) you could have the other frame at your offsite storage facility
via WAN. I believe I’ve seen discussions of doing just that on EMC’s site in the past. Some quick searching ought to do it. By doing this you’re not “backing up” to data domain OR tape – you’re just putting it on another frame.
One place I worked rather than doing BCV/SRDF/Shadow Image we had an exact copy of the Production database on another server and it was left in a mode (unmounted?)
that meant it was there but no one could attach to it to use it. We had a “log shipping” process in place to continually copy archive logs from the Production server to the backup server and would apply the logs to the backup database on a 6 hour time delay
so that bad things happening Production didn’t immediately replicate to the backup database. In the event of failure of the Production server we could apply remaining logs quickly then bring it up and point traffic to the backup server. Presumably this
could also be at an offsite storage facility (Disaster Recovery providers like Sunguard may even allow for this.)
As Mikhail noted pushing that much data to tape drives or disk deduplication is going to take a lot of resources – both storage units for the backup and bandwidth
pushing to them. Were I tasked with this level of backup I think I’d check with the offsite storage providers like Recall and IronMountain and with DR providers like Sunguard to see what they would allow us to keep offsite.
Of course another solution might be a cloud provider.
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu]
On Behalf Of Mikhail Nikitin
Sent: Monday, April 21, 2014 8:34 PM
To: Anurag Sharma
Cc: veritas-bu-bounces AT mailman.eng.auburn DOT edu; veritas-bu
Subject: Re: [Veritas-bu] Backup 450TB Oracle Database
Speaking strictly from the Data Domain perspective, you may have issues fitting such a database into a single box unless you are running the 990 or a GDA.
The only feasible solution with manageable backup window would be a split mirror backup on the array or VxVM, then depending on the backup schedule, you may need awfully lot of tape drives or a really high-end Data Domian. If you're planning to have daily
fills then you need to design a system capable of pushing circa 20TB/hr
I am not sure about the change rate in your case, but in general I would be hesitant to backup such a large DB with one single monthly full: in case of recovery it will take unreasonably long time even with cumulative incremental backups, which are quite
effective in Oracle.
WBR, Mikhail
On 22/04/2014 7:35 AM, "Anurag Sharma" <sharma.anurag AT hotmail DOT com> wrote:
Hi Experts,
I have been tasked with to purpose a solution to backup 450TB of Oracle Database.
So far my suggestion has been to take Timefinder local clone and do monthly full on tape using T10000c tapes on SL3000
Please through some lights and guide a soloution? Would it be better to use datadomain ?
Anurag