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:

  CODE

  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.

   CODE

   delphix> timeflow bookmark create

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

   CODE

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

3. Set the timeflow point timeflow and location

   CODE

   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

   CODE

   delphix timeflow bookmark create *> set name=myTimeFlowBookmark

5. Commit the result

   CODE

   delphix timeflow bookmark create *> commit
       TIMEFLOW_BOOKMARK-1

6. Display the list of timeflow bookmarks

   CODE

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

Provisioning from a TimeFlow bookmark

1. Execute the database provisioncommand.

   CODE

   delphix> database provision

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

   CODE

   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.

   CODE

   delphix database provision *> set timeflowPointParameters.type=TimeflowPointBookmark

4. Set the timeflow bookmark.

   CODE

   database provision *> set timeflowPointParameters.bookmark=myTimeFlowBookmark

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

   CODE

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

6. Set the base mountpoint

   CODE

   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.

   CODE

   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.

   CODE

   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.

   CODE

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

10. Commit the result.

    CODE

    delphix database provision *> commit