Re: Anyone Using IBM flash Copy for Database Backups?

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Tue, 3 Nov 2009 09:12:34 -0700
Message-ID: <3c5f7820911030812m16c29e7bi2499999a11b5bc6d_at_mail.gmail.com>



We've had several discussions over the past year that involved Oracle and IBM people about the best way to handle various aspects of supporting the Oracle database. Oracle did not give their blessing on using IBM Flashcopy for backups. That being said, my IBM team said not only will they stand behind using it, but they also will do the pushing on Oracle to lend support if/when needed. So far the IBM team has been true to their word in pushing Oracle on every other issue we encountered when we moved to the IBM z9. Still, I'm leary of using something for disaster recovery that isn't blessed by Oracle on a critical production database. Once bitten, twice shy.

Sandy

On Tue, Nov 3, 2009 at 8:57 AM, Freeman, Donald <dofreeman_at_state.pa.us>wrote:

> Iím interested in this topic as we have the technology but nobody has
> really tried it out as a database backup mechanism. Iím a little alarmed
> about the report of db backups taking twice as long on 11G. I hope/believe
> that isnít going to be true. We will begin upgrades here soon. One problem
> around here is that if Oracle doesnít support it we would be very reluctant
> to do it. If we get into a problem with a backup scenario using this
> technology and it fails Oracle isnít going to be there to help.
>
>
>
> Donald Freeman
>
> Database Administrator II
>
> Commonwealth of Pennsylvania
>
> Department of Health
>
> Bureau of Information Technology
>
> 2150 Herr Street
>
> Harrisburg, PA 17103
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Sandra Becker
> *Sent:* Tuesday, November 03, 2009 10:51 AM
> *To:* Patty.Charlebois_at_greenshield.ca
> *Cc:* regdba_at_yahoo.com; oracle-l_at_freelists.org;
> oracle-l-bounce_at_freelists.org
> *Subject:* Re: Anyone Using IBM flash Copy for Database Backups?
>
>
>
> IBM has been pushing flashcopy for us but so far my sys admins haven't been
> able to get around to testing it. My questions:
>
>
>
> Do you use flashcopy for your production backup? If yes, how well does the
> restore work? What kind of recovery do you have to do?
>
>
>
> Our "expert" consultant says we have to have a quiet point to do the
> flashcopy if we want the restore to be successful but he's never tried it.
> It is rare that we ever have a quiet point in our database--we would have to
> manufacture one for the length of the flashcopy. How do you know when the
> flashcopy is complete? How do you know it was successful?
>
>
>
> Sandy
>
>
>
>
>
> On Mon, Nov 2, 2009 at 11:27 AM, <Patty.Charlebois_at_greenshield.ca> wrote:
>
>
> We use IBM Flashcopy for several purposes, including the creation of test
> and reporting databases on a nightly basis. We do this with the production
> (source) database up so there is actually no production downtime to do the
> copy.
>
> The nightly incremental copy only takes minutes for us to complete for an
> approximately 1TB source database.
>
> Patty
>

-- 
Sandy
Transzap, Inc.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 03 2009 - 10:12:34 CST

Original text of this message