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:

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

    Copy 
    delphix> timeflow bookmark create

  2. Set the Timeflow point to be Oracle Timeflow point.

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

  3. Set the Timeflow point Timeflow and location

    Copy 
    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

    Copy 
    delphix timeflow bookmark create *> set name=myTimeFlowBookmark

  5. Commit the result

    Copy 
    delphix timeflow bookmark create *> commit
        TIMEFLOW_BOOKMARK-1

  6. Display the list of Timeflow bookmarks

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

Provisioning from a Timeflow bookmark

  1. Execute the database provisioncommand.

    Copy 
    delphix> database provision

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

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

    Copy 
    delphix database provision *> set timeflowPointParameters.type=TimeflowPointBookmark

  4. Set the Timeflow bookmark.

    Copy 
    database provision *> set timeflowPointParameters.bookmark=myTimeFlowBookmark

  5. Set the name and group for the new VDB.

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

  6. Set the base mountpoint

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

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

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

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

  10. Commit the result.

    Copy 
    delphix database provision *> commit