Skip to main content
Skip table of contents

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:

    ACTIONSCRIPT3
    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 createcommand.

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

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

    ACTIONSCRIPT3
    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

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

    ACTIONSCRIPT3
    delphix timeflow bookmark create *> commit
        TIMEFLOW_BOOKMARK-1
  6. Display the list of timeflow bookmarks

    ACTIONSCRIPT3
    delphix> timeflow bookmark ls
    Objects
    NAME                TAG   TIMEFLOW       
    myTimeFlowBookmark  -     dexample/default
    Operations
    create

Provisioning from a TimeFlow bookmark

  1. Execute the database provisioncommand.

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

    ACTIONSCRIPT3
    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.

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

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

    ACTIONSCRIPT3
    delphix database provision *> set container.name=vexample
    delphix database provision *> set container.group="Untitled"
  6. Set the base mountpoint

    ACTIONSCRIPT3
    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.

    ACTIONSCRIPT3
    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.

    ACTIONSCRIPT3
    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.

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

    ACTIONSCRIPT3
    delphix database provision *> commit
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.