Announcements

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

  Thread closed by the administrator. It is viewable, but not accepting new replies.
  • 1.  Tip of the Day: How to Rollback a VDB Using Using the CLI

    Posted 09-08-2014 04:33:00 PM
    No replies, thread closed.

    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
    #cli
    #vdb
    #timeflow
    #Tip