Re: Anyone Using IBM flash Copy for Database Backups?

Flashcopy copy us a consistent copy 
Or a crash recovery copy . Consistent copy needs begin backup and end backup  
for a brief moment and the split  happening . This is required to perform a 
backup to tape from the copy .  

Fuad


On Nov 3, 2009, at 9:50 AM, Sandra Becker <sbecker6925@xxxxxxxxx> wrote:

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> 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: