When provisioning a RAC VDB, how do I specify which instance numbers go to various nodes?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Sometimes when I provision, instance 1 goes to node 1, which is great.  Sometimes though, it goes to node 2!  I can't find a way to specify what I want.
Photo of Johnston Davis

Johnston Davis

  • 634 Points 500 badge 2x thumb
  • frustrated

Posted 3 years ago

  • 0
  • 1
Photo of Ranzo Taylor

Ranzo Taylor, Employee

  • 1,572 Points 1k badge 2x thumb
Official Response

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