Tip of the Day: How to Rollback a VDB Using Using the CLI

  • 2
  • Announcement
  • Updated 4 years ago
  • (Edited)
If you have a VDB provisioned from a particular parent and then refresh that VDB to to a new point in the parent time flow a new time flow is created for the VDB, however the original timeflow is still retained as long as there are snapshots and logs in it. (This is reliant on retention due to if the snapshots/logs have already been removed then the procedure will not work.)

The GUI will only display the in use time flow therefore, to access the alternate timeflows, you can use the CLI. In 4.0 or later version, there is a CLI database operation- switch time flow, that allows you to select a specific timeflow to be the active timeflow. After changing the current timeflow with switch time flow, return to the GUI and see the alternate timeflow and rollback from there.

ssh delphix_admin@delphix >ls

delphix > timeflow

delphix timeflow > /database select 'example'

delphix timeflow database 'example' > rollback

delphix timeflow database 'example' rollback *> ls



Properties

     t ype: OracleRollbackParameters

      credential: (unset)

      timeflowPointParameters:

      type: TimeflowPointSemantic

      container: (required)

      location: LATEST_POINT

      username: (unset)



delphix database 'example' rollback *> edit timeflowPointParameters
delphix database 'example' rollback timeflowPointParameters *> set type= Value must be one of:["TimeflowPointBookmark", "TimeflowPointBookmarkTag", "TimeflowPointLocation", "TimeflowPointSemantic", "TimeflowPointTimestamp"]

delphix database 'example' rollback timeflowPointParameters *> set type=TimeflowPointTimestamp

delphix database 'example' rollback timeflowPointParameters *> ls



Properties

      type: TimeflowPointTimestamp (*)

      timeflow: (required)

      timestamp: (required)


delphix database 'example' rollback timeflowPointParameters *> set timeflow='XX_XX@2014-05-16T10:33:41'

delphix database 'example' rollback timeflowPointParameters *> set timestamp="2014-05-16T17:37:41.095Z"

delphix database 'example' rollback timeflowPointParameters *> commit
Photo of Delphix FAQs

Delphix FAQs, Official Rep

  • 4,000 Points 4k badge 2x thumb

Posted 4 years ago

  • 2

Be the first to post a reply!