RE: Anyone Using IBM flash Copy for Database Backups?
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: "'sbecker6925@xxxxxxxxx'" <sbecker6925@xxxxxxxxx>, "Patty.Charlebois@xxxxxxxxxxxxxx" <Patty.Charlebois@xxxxxxxxxxxxxx>
- Date: Tue, 3 Nov 2009 10:57:24 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sandra Becker
Sent: Tuesday, November 03, 2009 10:51 AM
To: Patty.Charlebois@xxxxxxxxxxxxxx
Cc: regdba@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx<mailto:Patty.Charlebois@xxxxxxxxxxxxxx>> 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
Other related posts:
