Delphix Products

  • 1.  Rewind a VDB to a specific snapshot using CLI

    Posted 02-02-2017 11:42:00 PM
    So I took a new snapshot of an Oracle vdb. I want to run some tests in this vdb. Then rewind to the snapshot I took to get back to pre-test state. Could anybody provide the CLI commands to do this?


  • 2.  RE: Rewind a VDB to a specific snapshot using CLI
    Best Answer

    Posted 02-03-2017 03:34:00 PM
    Bharatham, we're constantly improving our CLI Cookbook.  I hope these examples can help you; if not, let us know and we'll try to improve it for your needs:

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


  • 3.  RE: Rewind a VDB to a specific snapshot using CLI

    Posted 02-03-2017 07:25:00 PM
    Here is what I needed - which is a bit different from what is shown in the above documentation page. 1. Take a snapshot of your vdb via GUI or CLI 2. Run your tests 3. Rollback to the snapshot you took de database> select yourdb de database 'yourdb'> ls de database 'yourdb'> rollback de database 'yourdb' rollback *> ls de database 'yourdb' rollback *> set timeflowPointParameters.type=TimeflowPoint de database 'yourdb' rollback *> set timeflowPointParameters.type=TimeflowPointSnapshot de database 'yourdb' rollback *> set timeflowPointParameters.snapshot='@2017-02-01T22:18:29.331Z' de database 'yourdb' rollback *> commit; Thanks for your response though.