Replication between multiple VDBs of single DSource.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Can we setup streams or GG replication between VDBs which are created out of same DSource. This could be useful option in case lower environment doesn't simulate exact production design. VDBs can be used for testing and certifying application releases or even testing replication software releases.
Photo of Asif Haliyal

Asif Haliyal

  • 110 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Tim Gorman

Tim Gorman, Delphix Field Services

  • 3,846 Points 3k badge 2x thumb
Official Response

I'm not sure I entirely understand the specific use-case you describe, but there is no problem setting up Oracle Streams or Oracle GG replication between VDBs.  The need to test replication solutions, along with all functionality, is not affected by the "virtual-ness" of a VDB.

VDBs are independent Oracle databases and instances with their own DBID, GLOBAL_NAMES, and other attributes important to any replication solution.  The only difference between a VDB and a "physical" database outside the influence of Delphix is that the storage of a VDB is actually located on the Delphix appliance using NFS, so only issues related to the storage of datafiles, tempfiles, controlfiles, online redo logfiles, archived redo logfiles, and such are affected.

Hope this helps!

-Tim Gorman