Find specific timeflow from a few days ago

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

We have the following issue
Our SQL dSource is backed up every 2 mins.  There is a restriction in the GUI to only show the last 1500 snapshots.
This means that we cannot see any snapshots from last friday.
Our support team need a delphix VDB refreshed from a certain timepoint 2016-06-03T13:29:59.000Z

If I use the CLI to view timeflow

timeflow "DBName" timeflowRanges

I get a massive list and cannot scroll up enough to view all...

So I try and refresh manually using the CLI and guess the timeflow (we have logsync on)

> database> select <VDB name>
> refresh
> set timeflowPointParameters.type= TimeflowPointTimestamp
> set timeflowPointParameters.location=2016-06-03T13:29:59:000Z<br>
but the CLI keeps saying the timeflow does not exist

Also tried
set timeflowPointParameters.timeflow=2016-06-03T13:29:59:000Z

instead of location.

Is there anyway to restrict the timeflowranges that come back in the first query to only look at a certain daterange?

Is there a better way to refresh a DB to a particular point in time without knowing this information?

Thanks in advance
Photo of Mark Hayter

Mark Hayter

  • 766 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Scott MacDonald

Scott MacDonald, Staff Engineer

  • 2,722 Points 2k badge 2x thumb
Official Response
Hi Mark,

You'll need to get a correct timeflow specified for a timestamp refresh.

Easiest is to list the available timeflows for the database with:

/timeflow list database=<VDB Name>

probably only one or maybe two, then use that as the "timeflow" parameter in the TimeflowPointTimestamp args.