CLI cookbook: provisioning a VDB from a timeflow bookmark

This topic describes how to create a Timeflow bookmark and use it to provision a single instance Oracle VDB using the Delphix Engine command-line interface.

You can create Timeflow bookmarks to give a semantically meaningful name to a TimeFlow point (scn, location or timestamp within a Timeflow). You can then use the bookmarks you created to execute the following database operations:

Provision
Refresh
Export
Test file mappings
VDB Rewind

Prerequisites

You will need the following information:

The name of the Timeflow bookmark you want to create
The name of the VDB you want to create
The group in which to create the VDB
The Oracle database name
The Oracle database unique name
The Oracle database instance number
The Oracle database instance name
The source dSource or VDB from which you wish to provision
The SCN, or timestamp of the point you want to provision from. You can run these commands to get the list of snapshots or Timeflow ranges:
ActionScript
```
snapshot list database=dexampletimeflow "dexample" timeflowRanges; commit
```
The base mountpoint on the target server where VDB data should be mounted
The source repository (oracle install) in which to create the VDB. These can be listed with the /repository list command.

Creating the TimeFlow bookmark

Execute the timeflow bookmark createcommand.
ActionScript
```
delphix> timeflow bookmark create
```

Set the timeflow point to be Oracle timeflow point.

ActionScript

delphix timeflow bookmark create *> set timeflowPoint.type=OracleTimeflowPoint

Set the timeflow point timeflow and location

ActionScript

delphix timeflow bookmark create *> set timeflowPoint.timeflow=dexample/defaultdelphix timeflow bookmark create *> set timeflowPoint.location=1945519455791

Set the name of the timeflow bookmark

ActionScript

delphix timeflow bookmark create *> set name=myTimeFlowBookmark

Commit the result

ActionScript

delphix timeflow bookmark create *> commit    TIMEFLOW_BOOKMARK-1

Display the list of timeflow bookmarks

ActionScript

delphix> timeflow bookmark lsObjectsNAME                TAG   TIMEFLOW       myTimeFlowBookmark  -     dexample/defaultOperationscreate

Provisioning from a TimeFlow bookmark

Execute the database provisioncommand.
ActionScript
```
delphix> database provision
```

Set defaultsand provide container (VDB or dSource) that you will be provisioning from

ActionScript

delphix database provision > defaultsdelphix database provision defaults > set container=<VDB or dSource>delphix database provision defaults > commit

Set the timeflowPointParameters type to be TimeflowBookmark.

ActionScript

delphix database provision *> set timeflowPointParameters.type=TimeflowPointBookmark

Set the timeflow bookmark.

ActionScript

database provision *> set timeflowPointParameters.bookmark=myTimeFlowBookmark

Set the name and group for the new VDB.

ActionScript

delphix database provision *> set container.name=vexampledelphix database provision *> set container.group="Untitled"

Set the base mountpoint

ActionScript

delphix database provision *> set source.mountBase=/mnt

Set the source config type to be single instance Oracle, and set the database name and database unique name.

ActionScript

delphix database provision *> set sourceConfig.type=OracleSIConfigdelphix database provision *> set sourceConfig.databaseName=vexampledelphix database provision *> set sourceConfig.uniqueName=vexample123

Set the instance name and number.

ActionScript

delphix database provision *> edit sourceConfig.instancedelphix database provision sourceConfig.instance *> set instanceNumber=1delphix database provision sourceConfig.instance *> set instanceName=vexampledelphix database provision sourceConfig.instance *> back

Set the target repository.

ActionScript

delphix database provision *> set sourceConfig.repository=env/'/opt/oracle'

Commit the result.
ActionScript
```
delphix database provision *> commit
```