API cookbook: example provision of an Oracle VDB

This API cookbook recipe demonstrates how to provision an Oracle VDB using the Delphix Engine API.

In order to provision an Oracle VDB using the API, you need to provide a set of parameters of type OracleProvisionParameters (having already authenticated as per API Cookbook: Authentication).

There are a number of parameters you will need to know:

Group reference - See the list operation in "/api#group" on your Delphix Engine
VDB name - The name you want the new VDB to be called
Mount path - Where to mount datasets on the target host.
DB/unique names - The Oracle DB and unique names, often the same as the VDB name
Instance name/number - The Oracle instance name and number to use (dictated by your environment, but often VDB name and 1)
Repository reference - See the list operation on "/api#repository" on your Delphix Engine
TimeFlow point - See API Cookbook: List Snapshots for more information on finding a TimeFlow point, as well as the reference at "/api#TimeflowPoint Parameters

You will need to use the structure of the OracleProvisionParameters object to fill it out, see "/api/#OracleProvisionParameters" for details on which fields are mandatory/optional.

Here is a minimal example using curl to communicate with the API, provisioning a VDB called "EGVDB" (authentication omitted)

CODE

curl -X POST -k --data @- http://delphix1.company.com/resources/json/delphix/database/provision \
    -b cookies.txt -H "Content-Type: application/json" <<EOF
{ 
    "container": {
        "group": "GROUP-2",
        "name": "EGVDB", 
        "type": "OracleDatabaseContainer"
    },
    "source": {
        "type": "OracleVirtualSource",
        "mountBase": "/mnt/provision", 
        "allowAutoVDBRestartOnHostReboot": true
    },  
    "sourceConfig": {
        "type": "OracleSIConfig",
        "databaseName": "EGVDB", 
        "uniqueName": "EGVDB", 
        "repository": "ORACLE_INSTALL-3",
        "instance": {
            "type": "OracleInstance",
            "instanceName": "EGVDB",
            "instanceNumber": 1
        }
    },
    "timeflowPointParameters": {
        "type": "TimeflowPointLocation",
        "timeflow": "ORACLE_TIMEFLOW-123",
        "location": "3043123"
    },
    "type": "OracleProvisionParameters"
}
EOF