I changed my VDB Config Template, but when I Refresh my VDB, my changes aren't there. What's happening?

  • 0
  • 2
  • Problem
  • Updated 4 years ago
  • Solved
  • (Edited)
I provisioned my Oracle VDB using a template, and set the SGA to 16 GB.  But I needed to boost this parameter.  I changed the template, but nothing happened.  I even did a VDB Refresh, but it still didn't work!
Photo of Thom T

Thom T

  • 838 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 2
Photo of Ranzo Taylor

Ranzo Taylor, Employee

  • 1,666 Points 1k badge 2x thumb
Official Response
As explained in https://docs.delphix.com/display/DOCS/Customizing+Oracle+VDB+Configuration+Settings, the default behavior is to use the template parameters for the VDB at provisioning time, and to maintain those settings when you Refresh. 

You can change the default behavior, using the CLI as described in the above link.  You can use a reference to the template, and this will affect the VDB upon subsequent Refreshes.

Another important note: 
If you don't want to actually modify the template, you can modify the parameter using Oracle ALTER SYSTEM command.  This can change the parameter in memory, in the spfile, or both (just like a Physical DB).   However...these changes are ALWAYS wiped out when you run a Refresh operation, whether you use a template or not.