Options on huge (5TB) partial data refresh possibility

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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.
Photo of Srinivasan Ramaswamy

Posted 2 years ago

  • 0
  • 1
Photo of Gianpiero Piccolo

Gianpiero Piccolo

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