Delphix Products

Expand all | Collapse all

Rolling Forward a VDB

Jump to Best Answer
  • 1.  Rolling Forward a VDB

    Posted 08-05-2015 04:06:00 PM

    I am trying to roll forward vDB using following doc

    https://docs.delphix.com/display/DOCS42/CLI+Cookbook%3A+Rolling+Forward+a+VDB

    Following step is failing

    delphix database "PVDB" rollback *> set timeflowPointParameters.timeflow='DB_PROVISION@2013-11-25T17:37:06'

    No such property 'timeflow'.

    Am I missing something?



  • 2.  RE: Rolling Forward a VDB

    Posted 08-05-2015 04:36:00 PM
    I believe the type field of timeflowPointParameters should be changed first. For example, set it to TimeflowPointLocation if you will be supplying an scn/location as in the example.


  • 3.  RE: Rolling Forward a VDB
    Best Answer

    Posted 08-05-2015 04:43:00 PM
    Hi Syed,
    Yes, that value 'DB_PROVISION@2013-11-25T17:37:06' is obtained from the /timeflow for the vdb.
    A rewind operation must have occurred first on that VDB.

    Then step 1 in our documentation. 
    When entering into CLI enter
    /timeflow
    ls
    find the timeflows for that VDB.

    Now you can use that value listed in step 5 to set the timeflowPointParameter correctly for that VDB.

    I hope this helps.
    Cheers,
    Dave G.



  • 4.  RE: Rolling Forward a VDB

    Posted 08-05-2015 04:45:00 PM

    Location is set to LATEST_POINT and I am not changing it.



  • 5.  RE: Rolling Forward a VDB

    Posted 08-05-2015 04:46:00 PM
    yes vDB was rewind and I am using correct timeflow.


  • 6.  RE: Rolling Forward a VDB

    Posted 08-05-2015 05:06:00 PM
    Hi Syed,
    Thank you. After determining the correct timeflow to use.
    We need to change the timeflowPointParameters.type, as follows:
    delphix database "PVDB" rollback *> set timeflowPointParameters.type=TimeflowPointLocation
    delphix database "PVDB" rollback *> set timeflowPointParameters.timeflow='DB_PROVISION@2013-11-25T17:37:06'
    ls
    I hope that helps. We are updating our documentation shortly to add this additional change.
    Cheers,
    Dave G.



  • 7.  RE: Rolling Forward a VDB

    Posted 08-06-2015 01:22:00 PM

     set timeflowPointParameters.type=TimeflowPointLocation did the trick.

    I think it should be part of that documentation.



  • 8.  RE: Rolling Forward a VDB

    Posted 08-06-2015 01:25:00 PM
    Why it does not accept LATEST_POINT for location when rolling forward?


  • 9.  RE: Rolling Forward a VDB

    Posted 08-06-2015 03:13:00 PM
    You should be able to use LATEST_POINT, but in this case you are using a 
    TimeflowPointSemantictype and would have  to specify the container instead of timeflow (as LATEST_POINT refers to the latest point for an entire container). There's no way, at the moment, to ask for the latest point of a specific timeflow (that is, one has to manually enter the SCN/LSN or timestamp of the timeflow)