Search

Top 60 Oracle Blogs

Recent comments

Webcast June 19th: Jonathan Lewis – Expert Look at Delphix

Concept of Hand with Electronic Fingerprintshttp://dboptimizer.com/wp-content/uploads/2013/06/MP900431702-300x199.jpg 300w, http://dboptimizer.com/wp-content/uploads/2013/06/MP900431702-1024x682.jpg 1024w" sizes="(max-width: 461px) 100vw, 461px" />Live webcast: Jonathan Lewis – An Oracle Expert’s Look at the Delphix Technology
Date: 
Wednesday, June 19 @ 9am PT
Click Here to Register

Jonathan Lewis joins us for the 2nd webcast of 3 in his series on Delphix technology and his experiences. Jonathan came out to the Delphix offices in California in March and kicked the tires on the product for a few days and had a chance to talk to some of the creators of Delphix, ZFS, DTrace and Active Dataguard at the Delphix offices.

The first webcast was an informal discussion of his experiences. This second webcast will also be informal but more technical.

Please send us questions by commenting on this blog post and we will try to incorporate the questions into the webcast

Some of the areas we may talk about are

Introduction

  • motivation for virtualizing databases covering some use cases that database virtualization solves.

Ease of Use of Delphix

  • link to a source database
  • provision a virtual database clone
  • eadministration automates of change collection and purging of old data.

Delphix on a laptop

  • Jonathan and I have set up Delphix on our laptops and we will discuss a bit on how this has worked for us.
  • Demo of Delphix (either on laptop or on a “real” machine”)

Technical explanations

ZFS

  • ZFS “Keeps a copy of every new version of a block”
  • ZFS equivalent of the read-consistent index  that gives you the file as at any point in time
  • Awareness of Oracle block size – setting logical ZFS block size to Oracle block size
  • Being able to compress the ZFS logical block to a smaller number of sectors
  • Special case of empty blocks compressing to fit the ZFS meta-data entry

Source database linking

  • RMAN full backup run  by delphix
  • Delphix uses RMAN tape library APIs
  • RMAN backup from SCN
  • Allows consistent versions of database for EVERY incremental backup taken, forever
  • Enable ctwr  (block change tracking) to minimise backup times
  • Ability to copy all redo logs, and keep up with online redo logs  so able to start from any level 1 and roll forward to any point before next level 1
  • How old versions of data blocks from the backup history can be dropped when there are no snapshots that depend on them so that the backup keeps rolling forward in time without needing a whole new starting snapshot to be taken
  • The complexity of making this task efficient
  • The importance and benefit of being able to do it.

Virtual Database

  • Creating a vDB and how the new data is created without a history trail and unchanged datablocks come from a snapshot and are mostly the original backups.

Related blog posts by Jonathan’s blog