Delphix Products

Expand all | Collapse all

Options on huge (5TB) partial data refresh possibility

  • 1.  Options on huge (5TB) partial data refresh possibility

    Posted 09-29-2016 04:49:00 PM
    Use Case - Ingest a huge DB - say 15TB - Provision a vDB say as of day 1 - Day 3, in vDB - I want Schema02 to be refreshed (5TB) with current data and all other Schema** remain not refreshed - Above point is a requirement What are the options I have - does Delphix provide any better/quicker solution when combined with Oracle options.
    #Reporting


  • 2.  RE: Options on huge (5TB) partial data refresh possibility
    Best Answer

    Posted 09-29-2016 08:55:00 PM
    Delphix works with entire DB instances. And it allows you to refresh large volume od data in few minutes (instead of hours or days). It allows you also to not need extra storage.

    If you have to leave not refreshed some schemas, I can suggest you to provision two VDB copies:
    Copy A for refreshing the Schema02
    Copy B for leaving not refreshed other schemas.

    You have to drop the Schema02 into Copy B and create a DBLink to Copy A and synonym to simulate that Schema02 is into the Copy B.

    Your applications have to connect only to Copy B.

    When you refresh the copy A, you are refreshing only the Schema02 into the Copy B.

    ATTENTION: When you refresh the copy B, you are refreshing all schemas, recreating the Schema02 and loosing the DBLink and synonyms. To avoid this, you have to create a after refresh hook script that repeat the DBLink creation every time you refresh the Copy B.

    Hope this help you.

    Regards.
    Gianpiero