Just to make sure we are on the same page: when you provision a VDB in a Delphix RAC cluster, Delphix will assign a random instance number to each node. This can create scenarios where in node 1 we have instance number 8 running, etc…
In the future release, this will be manageable through GUI. At this moment, we can only do it from CLI.
Using one of our RAC labs I did some testing and we can provision the VDB with the proper name, in the proper node, with CLI.
NOTE: this lab was performed on a 2 node cluster.
First Example: provision a RAC VDB (TEST1 instance running in rac1 node, TEST2 instance Running in rac2) from a SNC= 42601222. dSource name is "orcl". This is the script we ran
database
provision
defaults
set container=orcl —> Here we define the dSource from we will create the VDB
set type=TimeflowPointLocation
set timeflow=default
set location=42601222 —> Here we define the SCN that we want our VDB to be in during provisioning
commit
set container.name=TEST —> Here we define container Name
set container.group=Untitled
set sourceConfig.databaseName=TEST —> Here we define Database Name
set sourceConfig.uniqueName=TEST —> Here we define Database Unique Name
edit sourceConfig
set instances[0].instanceName=TEST1 —> on this line and the following, we make sure that instance name and node number are the same
set instances[0].instanceNumber=1
set instances[0].node=rac1
set instances[1].instanceName=TEST2
set instances[1].instanceNumber=2
set instances[1].node=rac2
commit
Running this script, we will provision a VDB on both nodes of the cluster with the proper instance name in each one.
Second Example We provision a RAC VDB only on one node, but with the proper instance name. On this one we will be provisioning the database in the second node of the cluster.
This will be the script:
provision
defaults
set container=orcl
set type=TimeflowPointLocation
set timeflow=default
set location=42601222
commit
set container.name=TEST
set container.group=Untitled
set sourceConfig.databaseName=TEST
set sourceConfig.uniqueName=TEST
edit sourceConfig
set instances[0].instanceName=TEST2
set instances[0].instanceNumber=2
set instances[0].node=rac2
commit