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:

  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.

   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
       TIMEFLOW_BOOKMARK-1
   

6. Display the list of Timeflow bookmarks

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

Provisioning from a Timeflow bookmark

1. Execute the database provisioncommand.

   delphix> database provision
   

2. Set defaultsand 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 container.name=vexample
   delphix database provision *> set container.group="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