I'm not sure if I understood your question. However each VDB always uses Delphix Storage. You can assume it as a definition of a *Virtual* DB. After you deployed a VDB on exadata, if you want, you can move it to ASM and so the VDB will become Physical DB on ASM.
Hope I answered your question.
My question is our development environment is on exadata and currently we are creating multiple databases based on the different projects we are working on.
If we use VDB instead of multiple databases we are creating on this development exadata environment, will the VDB's use the storage of the existing development exadata box or delphix storage and for which i have received the answer. So we just need instances on the exadata rack that can be plugged to each of the VDB's created from the dSource.
Also, if we share same table in these multiple VDB's and one of the requirement in project is to drop a column, the first vdb and second vdb will be out of sync. how to manage these kind of scenarios.
Thanks in advance
May I try to answer here...
two points to consider
1. Space used for Dsource. I assume that Exadata does not presents EXADATA Luns for Delphix Purpose, In other words you have probably declared some LUNs from SAN to the host running Delphix. Note: Using Exadata storage cells for Dsource does not make sense. The Dsource is there only for one purpose: Be in sync with your Oracle Instance linked to your Dsource transferring oracle data block using RMAN API.
2. Exadata space available thru ASM. This storage will be used by VDBs only if the target environment you choose for your VDB is hosted by an exadata ORACLE_HOME.
Best regards, Den.
This is the great advantage Delphix offers.
In regards of your initial question: VDB is an Oracle instance running on compute node and uses storage exposed by Delphix Engine via NFS channel. No local space is used on the exadata.
- Yes, Delphix can run VDB's with Exa compute nodes.
- The VDB's will run on Delphix Storage and be presented to the compute nodes via NFS
- We have customers that do this today, and are very happy.
- VDB's do not duplicate storage
- Because Delphix does not duplicate data blocks and shares those block across all virtual instances, you can easily run 10 VDB's in the space of 1 regular VDB. But we have customers that have a much higher ratio than that.
I hope this helps.