Delphix Products

Expand all | Collapse all

Continous log apply to VDBs from dSource

Jump to Best Answer
  • 1.  Continous log apply to VDBs from dSource

    Posted 08-22-2016 05:20:00 PM
    Hi, Is there anyway to create a VDB from dsource and continue to refresh VDB from logs? Basially I want to use VDB as an active data guard kind of scenario. Is that possible with Delphix?


  • 2.  RE: Continous log apply to VDBs from dSource
    Best Answer

    Posted 08-22-2016 05:36:00 PM
    Hemant, it sounds to me like you want to use Live Sources. Check out this page:

    https://docs.delphix.com/display/DOCS50/Oracle+LiveSources


  • 3.  RE: Continous log apply to VDBs from dSource

    Posted 08-22-2016 05:41:00 PM
    I agree wiyh Adam. He ever replies before me ;-)


  • 4.  RE: Continous log apply to VDBs from dSource

    Posted 08-22-2016 05:42:00 PM
    :) I wish I had one hundred partners like you, Gianpiero. ;)


  • 5.  RE: Continous log apply to VDBs from dSource

    Posted 08-22-2016 05:58:00 PM
    Thank you folks for quick reply. It is good to know the feature being new to Delphix.


  • 6.  RE: Continous log apply to VDBs from dSource

    Posted 08-23-2016 06:51:00 PM
    Hemant, Live Sources might solve your needs, but you should also know that you can use a VDB in an Active or typical Data Guard configuration.  You could Activate the VDB, run transactions and reports, Flash it Back, and resync it.  Just like a Physical Database.  

    If you don't need to run transactions, Delphix Live Sources is simple and convenient.  If you need transformations, what-if analysis, or your reporting system requires transactions (like Oracle EBS Concurrent Manager Jobs), you can fall back on your normal toolkit.  A VDB is just like a Physical VDB.  You can provision a VDB without opening it, which results in a VDB that is mounted and can be placed into a Data Guard configuration with standard DBA tools.  Hope it helps!


  • 7.  RE: Continous log apply to VDBs from dSource

    Posted 08-23-2016 07:08:00 PM
    I think you nailed it exactly on an answer I was looking for. Can you provide some white paper or a process  on how to do it?


  • 8.  RE: Continous log apply to VDBs from dSource

    Posted 08-23-2016 08:24:00 PM
    HB I'm sorry, there's no white paper, but the process is pretty straightforward.

    When you provision, you can go to Advanced and uncheck a box that says "Open Database After Provision".  

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1472180/RackMultipart20160823-64209-1j8lpg3-2016-08-23_14-12-28_inline.jpg?1471987147">
    That's going to leave you with all the files and an unrecovered mounted database.

    Looking at the oracle docs for building a physical standby, you've basically eliminated the need to take a backup of the database and restore it.  But you'll still need to follow the rest of the process.  For Oracle 12, here's the link: http://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4727">http://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4727">http://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4727

    Note that although Delphix gives you lots of shortcuts, you can still use your standard srvctl, sqlplus, and file system commands.  You'll still see datafiles, controlfiles, etc on the file system of your target, mounted as NFS files.  

    For this procedure, you'll treat the VDB just like a physical standby, stopping and starting it outside of Delphix with Dataguard commands.  

    If you are able to avoid transactions for your reporting needs, the Delphix LiveSource feature is a huge shortcut.  

    If you give me a little more insight into your Use Case, I can try to feed that back into our Product Management team.

    I'm also filing a documentation bug because it wasn't easy to find the information about "Open Database After Provision" switch.

    Hope it helps!