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


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:

    snapshot list database=dexample
    timeflow "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

  1. Execute the timeflow bookmark create command.

    delphix> timeflow bookmark create
  2. Set the timeflow point to be Oracle timeflow point.

    delphix timeflow bookmark create *> set timeflowPoint.type=OracleTimeflowPoint 
  3. Set the timeflow point timeflow and location

    delphix timeflow bookmark create *> set timeflowPoint.timeflow=dexample/default
    delphix timeflow bookmark create *> set timeflowPoint.location=1945519455791
  4. Set the name of the timeflow bookmark

    delphix timeflow bookmark create *> set name=myTimeFlowBookmark
  5. Commit the result

    delphix timeflow bookmark create *> commit
  6. Display the list of timeflow bookmarks

    delphix> timeflow bookmark ls
    NAME                TAG   TIMEFLOW       
    myTimeFlowBookmark  -     dexample/default

Provisioning from a TimeFlow Bookmark

  1. Execute the database provision command.

    delphix> database provision
  2. Set defaults and provide container (VDB or dSource) that you will be provisioning from 

    delphix database provision > defaults
    delphix database provision defaults > set container=<VDB or dSource>
    delphix database provision defaults > commit
  3. Set the timeflowPointParameters type to be TimeflowBookmark.

     delphix database provision *> set timeflowPointParameters.type=TimeflowPointBookmark 
  4. Set the timeflow bookmark.

    database provision *> set timeflowPointParameters.bookmark=myTimeFlowBookmark
  5. Set the name and group for the new VDB.

    delphix database provision *> set
    delphix database provision *> set"Untitled" 
  6. Set the base mountpoint.

    delphix database provision *> set source.mountBase=/mnt
  7. Set the source config type to be single instance Oracle, and set the database name and database unique name.

    delphix database provision *> set sourceConfig.type=OracleSIConfig
    delphix database provision *> set sourceConfig.databaseName=vexample
    delphix database provision *> set sourceConfig.uniqueName=vexample123
  8. Set the instance name and number.

    delphix database provision *> edit sourceConfig.instance
    delphix database provision sourceConfig.instance *> set instanceNumber=1
    delphix database provision sourceConfig.instance *> set instanceName=vexample
    delphix database provision sourceConfig.instance *> back 
  9. Set the target repository.

    delphix database provision *> set sourceConfig.repository=env/'/opt/oracle' 
  10. Commit the result.

    delphix database provision *> commit