Has anyone done an automation to take snapshot from dSource to vdb?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I need to find a way to automate the creation of snapshot from dSource to vdb? Has anyone done this?
Photo of Carla Abanes Caballa

Carla Abanes Caballa

  • 154 Points 100 badge 2x thumb
  • lucky

Posted 2 years ago

  • 0
  • 1
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 2,336 Points 2k badge 2x thumb
Ciao Carla,

what do you mean with "creation of snapshot from dSource to vdb"? This is a composite task that comprises:
1. Snapshot of the dSource (Delphix Engine get a new backup of the source)
2. Refresh on the vdb (Delphix Engine copies the data from the last backup (step 1) into the vdb.

Is this what you mean?
If so you can automate in two ways:
Regards.
Gianpiero
I have a dSource that is refreshed daily. I have a vdb that is a child of this dSource. my dSource is refreshed daily but its child vbd is not. is there a way to automate this? I m still grappling going the CLI way. do you have a prepared script that i can change some variables? thanks for reply and the time too!
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 2,336 Points 2k badge 2x thumb
If you want automate a periodic refresh of a VDB, you can use simply the refresh policies on the VDB (select "Manage" > "Policies" and select a policy for you vdb in the 4th column "VDB refresh".

Anyway, I'd like to make clear the terms used for dSources and VDBs, if you agree.

To make sure that your dSource is up to date with external linked DB, you have to snapshot it (you can schedule periodic snapshot with the snapshot policies). If you enable also LogSync you can get any "frame" of your DB between two snapshots and so your dSource is continuosly updated with your external linked DB.

To copy fresh data from the dSource into your VDB copy, you can do a refresh on VDB from the latest point of the timeflow of your dSource.

In few words, what you need is:
dSource -> snapshot
vDB -> refresh

And you can schedule periodic snapshots and periodic refresh through policies (Selecting "Manage" > "Policies" from the main menu).

Best Regards.
Gianpiero
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
I have several such examples on my blog: http://therealcloudsurgeon.com
unfortunately, I cannot open your blog site due to our company policy. you have link i can download a doc or something? thanks for the reply though!
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
In addition to a snapshot example, I also cover refresh examples:
http://blog.delphix.com/bowen/

But, if you want to do this on a time cadence, then you can use policies, like Gianpiero said.