From earlier, the RESTFul URL for a virtual database refresh will look like:
http://<delphix_engine>/resources/json/delphix/database/MSSQL_DB_CONTAINER-39/refresh
where the MSSQL_DB_CONTAINER-39 represents the target virtualized database to refresh and we need to POST the JSON data to the URL for processing.
{
"type": "RefreshParameters",
"timeflowPointParameters": {
"type": "TimeflowPointSemantic",
"container": "MSSQL_DB_CONTAINER-38"
}
}
Timeflow Parameters
The "timeflowPointParameters" key has 6 "type": "..." options which each have their own set of parameters. The type "TimeflowPointSemantic" uses the default LATEST_POINT within the source container. Now, for more on timeflowPointParameters.
http://<delphix_engine>/api/#TimeflowPointParameters
TimeflowPointParameters
Parameters indicating a TimeFlow point to use as input to database operations.
TypedObject
TimeflowPointParameters
Direct Known Subclasses:
TimeflowPointTimestamp, TimeflowPointSnapshot, TimeflowPointSemantic, TimeflowPointLocation, TimeflowPointBookmark, TimeflowPointBookmarkTag
TimeflowPointTimestamp
| timeflow | Reference to TimeFlow containing this point. Type: Reference to Timeflow Constraints: Required: true |
| timestamp | The logical time corresponding to the TimeFlow location. Type: date Constraints: Required: true |
TimeflowPointSnapshot
| snapshot | Reference to the snapshot. Type: Reference to TimeflowSnapshot |
TimeflowPointSemantic
Semantic reference to a Timeflow point.
The reference is relative to a container and not a TimeFlow. If the container contains multiple TimeFlows, the Delphix Engine will evaluate the semantic reference with regards to all TimeFlows in that container.
| container | Reference to the container. Type: Reference to Container Constraints: Required: true |
| location | A semantic description of a TimeFlow location. Type: string Constraints: Default: LATEST_POINT Acceptable values: LATEST_POINT, LATEST_SNAPSHOT Create: optional Update: optional |
TimeflowPointLocation
TimeFlow point based on a database-specific identifier (SCN, LSN, etc).
| location | The TimeFlow location. Type: string Constraints: Required: true |
| timeflow | Reference to TimeFlow containing this location. Type: Reference to Timeflow Constraints: Required: true |
TimeflowPointBookmark
| bookmark | Reference to the bookmark. Type: Reference to TimeflowBookmark Constraints: Required: true |
TimeflowPointBookmarkTag
| container | Reference to the container. Type: Reference to Container Constraints: Required: true |
| tag | The name of the tag. Type: string Constraints: Required: true |
Timeflow API Objects: Timeflow, snapshot, timeflowRanges
The sample code provides information on the Timeflow, timeflowRanges and snapshot objects for the respective VDB.
Filename: flows.sh
$ ./flows.sh VBITT10
Session API
Login API
Login {"type":"OKResult","status":"OK","result":"USER-2","job":null,"action":null}
Source: VBITT10
container reference: ORACLE_DB_CONTAINER-75
Timeflows API
timeflow names:
DB_PROVISION@2016-09-27T13:15:18
DB_ROLLBACK@2016-09-28T00:33:54
DB_ROLLBACK@2016-09-28T00:38:33
DB_ROLLBACK@2016-09-28T00:41:44
Select Timeflow Name (copy-n-paste from the above list):
DB_ROLLBACK@2016-09-28T00:33:54 timeflow reference: ORACLE_TIMEFLOW-97
TimeflowRanges for this Timeflow ...
{
"type": "ListResult",
"status": "OK",
"result": [
{
"type": "TimeflowRange",
"startPoint": {
"type": "OracleTimeflowPoint",
"location": "5475918",
"timestamp": "2016-09-28T04:35:39.000Z",
"timeflow": "ORACLE_TIMEFLOW-97"
},
"endPoint": {
"type": "OracleTimeflowPoint",
"location": "5476181",
"timestamp": "2016-09-28T04:37:53.000Z",
"timeflow": "ORACLE_TIMEFLOW-97"
},
"provisionable": true
}
],
"job":null,
"action":null,
"total": 1,
"overflow": false
}
Snapshot per Timeflow ...
snapshots:
@2016-09-28T04:35:39.826Z
@2016-09-28T04:37:38.537Z
@2016-09-28T04:37:51.273Z
Select Snapshot Name (copy-n-paste from the above list):
@2016-09-28T04:37:38.537Z
snapshot reference: ORACLE_SNAPSHOT-152
{
"type": "OracleSnapshot",
"reference": "ORACLE_SNAPSHOT-152",
"namespace":null,
"name": "@2016-09-28T04:37:38.537Z",
"consistency": "CRASH_CONSISTENT",
"missingNonLoggedData": false,
"container": "ORACLE_DB_CONTAINER-75",
"creationTime": "2016-09-28T04:37:38.537Z",
"firstChangePoint": {
"type": "OracleTimeflowPoint",
"location": "5476152",
"timestamp":null,
"timeflow": "ORACLE_TIMEFLOW-97"
},
"latestChangePoint": {
"type": "OracleTimeflowPoint",
"location": "5476157",
"timestamp": "2016-09-28T04:37:38.000Z",
"timeflow": "ORACLE_TIMEFLOW-97"
},
"retention": 0,
"timeflow": "ORACLE_TIMEFLOW-97",
"timezone": "US/Eastern,EDT-0400",
"version": "11.2.0.4.0",
"runtime": {
"type": "OracleSnapshotRuntime",
"provisionable": true,
"missingLogs":null
},
"temporary": false,
"fromPhysicalStandbyVdb": false,
"fractionTimeflows":null,
"redoLogSizeInBytes": 52428800
}
Done
The following scripts demonstrate REFRESH and RESET/ROLLBACK for the Timeflow types of timestamp, snapshot and scn/lsn.
Filename: vdb_refresh_timestamp.sh
Filename: vdb_refresh_snapshot.sh
Filename: vdb_refresh_scn.sh
Filename: vdb_rollback_timestamp.sh
Filename: vdb_rollback_snapshot.sh
Filename: vdb_rollback_scn.sh
Usage: ./vdb_[all_the_above_scripts].sh [source_vdb_name]
Sample Usage: Copy-and-Paste the timeflow name to the "Select timeflow Name:" prompt. Enter any timestamp between the startPoint and endPoint values using the format:
[yyyy] - [MM] - [dd]T[HH] : [mm] : [ss] . [SSS]Z
$ ./vdb_rollback_timestamp.sh VBITT Session and Login Successful ... database container reference: ORACLE_DB_CONTAINER-73 Timeflows API Timeflow Names: DB_REFRESH@2016-09-28T00:13:13 DB_PROVISION@2016-09-26T07:00:08 DB_ROLLBACK@2016-09-26T07:45:30 DB_REFRESH@2016-09-26T12:20:57 DB_ROLLBACK@2016-09-27T12:29:47
Select Timeflow Name (copy-n-paste from above list):
DB_ROLLBACK@2016-09-26T07:45:30
Timeflow Reference: ORACLE_TIMEFLOW-89
TimeflowRanges for this timeflow ...
{
"type": "ListResult",
"status": "OK",
"result": [
{
"type": "TimeflowRange",
"startPoint": {
"type": "OracleTimeflowPoint",
"location": "5474012",
"timestamp": "2016-09-26T15:30:35.000Z",
"timeflow": "ORACLE_TIMEFLOW-89"
},
"endPoint": {
"type": "OracleTimeflowPoint",
"location": "5482482",
"timestamp": "2016-09-26T21:15:17.000Z",
"timeflow": "ORACLE_TIMEFLOW-89"
},
"provisionable": true
}
],
"job": null,
"action": null,
"total": 1,
"overflow": false
}
Timestamp Format "[yyyy][MM][dd]T[HH]:[mm]:[ss].[SSS]Z"
Enter Timestamp between Start and End Point values (exclude quotes):
2016-09-26T15:45:00.000Z
json> {
"type": "OracleRollbackParameters",
"timeflowPointParameters": {
"type": "TimeflowPointTimestamp",
"timeflow": "ORACLE_TIMEFLOW-89",
"timestamp": "2016-09-26T15:45:00.000Z"
},
"username": ""
}
Job: JOB-515
Current status as of Wed Sep 28 00:49:39 EDT 2016 : RUNNING 0% Completed
. . .
Current status as of Wed Sep 28 00:51:10 EDT 2016 : RUNNING 73% Completed
Current status as of Wed Sep 28 00:51:50 EDT 2016 : RUNNING 96% Completed
Job: JOB-515 COMPLETED 100% Completed ...
Done ...