Delphix Products

Expand all | Collapse all

Schema based refreshing

Jump to Best Answer
  • 1.  Schema based refreshing

    Posted 07-25-2016 09:57:00 AM
    Hi,

    I am aware that Delphix data refresh is full a database refresh, but can Delphix do schema based refreshing? Like user wants to only refresh certain schema?

    Thank you.

    Thom.


  • 2.  RE: Schema based refreshing
    Best Answer

    Posted 07-25-2016 10:21:00 AM
    Hi Thom,

    I confirm that Delphix works with entire instance of the DB. So you'll have to work with a new database instance (the virtual copy provisioned by Delphix) that will contain your intended schema(s). What is your concern about working with a new instance?

    Storage? The first snapshot of your original DB uses only 30% of the unvirtualized storage space (benefit of the compression services offered by Delphix). Then Delphix will use storage only for recording the changed data: the not modified schemas won't use any further space.

    RAM? In the provisioning wizard, you'll be able to set memory parameters to lower size than the original instance (since you won't use all schemas).

    Security? You can use an hook script that drop other users before take the new instance available to your db users.

    Refresh time? I can assure that the time for refreshing the entire instance will be shorter than a normal exp/imp procedure, if you follow all Delphix requirements.

    Keep other schemas unrefreshed while refreshing the intended schema? If you want to take advantage of the powerful features of delphix, in this case, you should use a dedicated instance for your intended schema(s). If you have a cross DB user that join table across separated schema you'll be able to configure an hook script (after refresh event) that creates DBLinks and synonyms.   

    Feel free to reply any your concern. Me and others from community try to help you, if we are able.

    Regards.
    Gianpiero


  • 3.  RE: Schema based refreshing
    Best Answer

    Posted 07-31-2016 05:10:00 PM
    Hi, An other way is to have a kind of dsource template, i mean by this create a database with the minimum configuration like using dbca general perpose template and link it to delphix. Every time you need to import a dump just create a vdb based on the dsource template and use a hook to call your datapump script. Be awear that if you refresh your vdb you Will loose everything, but you can workaround this by dumping your vdb before and import again the dump after the refresh operation. As Geanpiero told it's faster to refresh a complete vdb than traying to use datapump to refresh schemas Regards, Mouhssine