API/Python/Open-Source Solutions

Expand all | Collapse all

How to pass the specific snapshot details in the Rollback Vdb through REST api call ?

Jump to Best Answer
  • 1.  How to pass the specific snapshot details in the Rollback Vdb through REST api call ?

    Posted 04-13-2016 04:03:00 AM
    How to pass the specific snapshot details in the Rollback Vdb through api call ? 


    {    "type": "OracleRollbackParameters",
        "timeflowPointParameters": {
            "type": "TimeflowPointSemantic",
            "container": "ORACLE_DB_CONTAINER-7",
            "location": "LATEST_POINT"
        }
    }

    Need here is  : Wanted Vdb to go to specific snapshot ( like ORACLE_SNAPSHOT-144 ...etc ) ..Pls respond




  • 2.  RE: How to pass the specific snapshot details in the Rollback Vdb through REST api call ?
    Best Answer

    Posted 04-13-2016 06:37:00 AM
    The timeflowPointParameters property supports of variety of types, each representing a specific use case:

    TimeflowPointSemantic: Specific semantic point (lastest point or latest snapshot)

    TimeflowPointSnapshot: Specific snapshot (identified by its reference)

    TimeflowPointLocation: Specific "location" (scn, lsn, transaction id, ...)

    TimeflowPointTimestamp: Specific point in time
    ....
    Here is an example of an API call payload rolling back to a snapshot:
    {
    "type": "OracleRollbackParameters",
    "timeflowPointParameters": {
    "type": "TimeflowPointSnapshot",
    "snapshot": "ORACLE_SNAPSHOT-144"
    }
    }

    In general, using the Delphix CLI (accessible over SSH) makes it easy to discover new capabilities thanks to the integrated help and autocompletion of types.