Delphix Products

Expand all | Collapse all

Is it possible to isolate the data in a single table so it is not impacted by a VDB Refresh?

  • 1.  Is it possible to isolate the data in a single table so it is not impacted by a VDB Refresh?

    Posted 08-30-2017 03:41:00 PM
    There is a single table within a database that has very sensitive region specific data and cannot be impacted by a VDB Refresh.   We need to refresh the entire VDB with the exception of one table.   Has anyone had to deal with this?


  • 2.  RE: Is it possible to isolate the data in a single table so it is not impacted by a VDB Refresh?

    Posted 08-30-2017 03:45:00 PM
    Hey John, we have many customers that have similar requirements. What they do is leverage our pre and post refresh hooks. A prerefresh hook exports the table from the VDB. After the refresh is over, the postrefresh hook imports the table back into the VDB. Here is a link for hooks with oracle Customizing">https://docs.delphix.com/display/DOCS/Customizing+Oracle+Management+with+Hook+Operations">Customizing Oracle Management with Hook Operations  and here is a link for hooks with MSSQL https://docs.delphix.com/display/DOCS/Hooks+for+SQL+Server


  • 3.  RE: Is it possible to isolate the data in a single table so it is not impacted by a VDB Refresh?

    Posted 08-30-2017 04:13:00 PM
    Thanks Adam.  I'll follow up with our DBA's on this.


  • 4.  RE: Is it possible to isolate the data in a single table so it is not impacted by a VDB Refresh?

    Posted 08-30-2017 06:30:00 PM
    John,

    Following on to Adam's excellent response, an almost ubiquitous requirement is to persist things like database account passwords, application account passwords, and database objects such as Oracle "database links" across a refresh operation.  These are normally set immediately following the initial provisioning of a VDB, and it is a hassle to have to re-set them manually each time a refresh is performed.

    Some of my colleagues within Delphix have begun posting code samples on Github.com, and I have resolved to do so as well, but I'm a little behind on it, so instead...

    If you'd like some sample UNIX/Linux shell-scripts for persisting Oracle database account passwords and Oracle database link definitions across refresh using Pre-Refresh and Post-Refresh hooks, then I'd be glad to share GDrive links to download them here (i.e. "ora_vdb_prerefresh.sh" and "ora_vdb_postrefresh.sh").  NOTE: these scripts are just example code with no warranty whatsoever;  use at your own risk, and it is unlikely that you'll find them useful if you don't modify them to fit your local standards.

    Hope this helps!

    -Tim