RE: NetApp flier - based snapshots and db backups

  • From: "Matthew Zito" <mzito@xxxxxxxxxxx>
  • To: <Brandon.Allen@xxxxxxxxxxx>, <kevin.closson@xxxxxx>, <amit.poddar@xxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 20 Jul 2007 21:01:27 -0400

That's correct.  What's very exciting about Netapp snapshots, too, is that if 
you get the FlexClone option, you can make multiple read-write copies of your 
snapshots, and those copies only take up as much space as the data that is 
changed.  So, you could give each developer a full copy of your production 
database, and assuming they're not going to change a lot of data in the 
database, they can run it to their heart's content.  Then, every week, or every 
few weeks, destroy and recreate the snapshots from production.

Very cool stuff.


Matthew Zito
Chief Scientist
GridApp Systems
P: 646-452-4090

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Allen, Brandon
Sent: Fri 7/20/2007 6:08 PM
To: kevin.closson@xxxxxx; amit.poddar@xxxxxxxx; oracle-l
Subject: RE: NetApp flier - based snapshots and db backups
Just to help clarify, and make sure I understand correctly - I think
what you're both saying is that you could use the copied data, control
and online log files to start another copy of the database instance,
which would then perform crash recovery, i.e. roll forward through the
online logs and then rollback any uncommitted transactions.  However you
could not apply any archived logs to the copied database.  Please let me
know if I've got it wrong.

Other related posts: