Where does virtual DB resides?

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
  • (Edited)
Does virtual database  resides with Delphix server? If yes then why Target Environment is needed while provisioning?
If VDB resides within the Target Environment, why is it called "Virtual Db" ?
I want to the how Delphix is storing its VDB on target environment/Delphix server.
Photo of anshul gupta

anshul gupta

  • 466 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Guillaume Nocent

Guillaume Nocent

  • 110 Points 100 badge 2x thumb

Hi,

Target environment hosts database binaries (Oracle/SQL/Sybase... "engine").

Database FILES are hosted on Delphix Engine.

It is called virtual database as the database files are not copied for each VDB but common data blocks are internally shared between VDBs instead of copied n times). 

Photo of Gary Hallam

Gary Hallam, Official Rep

  • 2,008 Points 2k badge 2x thumb
Hi Anshul,
The database binaries reside on the target server, the datafiles however reside in the storage assigned to the Delphix Engine, mounted on an NFS or ISCSI mount point on the target server  and accessed over the network between the Delphix Engine and the Target Server.  The way that Delphix handles the file pointers to the Virtual Database means that much of the non-unique data for each of the VDBs is shared.  Since the data is NOT provisioned nor moved to the target machine and because many VDBs can point to the same physical data then it is described as "Virtual".
Check out https://www.youtube.com/watch?v=ASuvXBIEKGM  - Jonathan Lewis explaining Delphix for Oracle, it might give some more insight.
Regards,
Gary