Schema based refreshing

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)

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.

Photo of Thom T

Thom T

  • 838 Points 500 badge 2x thumb
  • Happy, Confidence, hopeful

Posted 2 years ago

  • 1
  • 1
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 2,336 Points 2k badge 2x thumb
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.

Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,782 Points 4k badge 2x thumb

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