Is it correct that Delphix restrict to change init parameters

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
How Delphix create pointer for spfile and init.ora file, because init.ora reside in Oracle_home/dbs and spfile reside in DxFS
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,782 Points 4k badge 2x thumb
Hi,

At creation time delphix will use a temporary init insied $OH/dbs that points out to an spfile hosted under delphix storage.

Eg :

oracle@linuxtarget dbs]$ cat initBGL.ora
spfile='/mnt/provision/BGL/datafile/spfile.ora'
[oracle@linuxtarget dbs]$

Once the database is created delphix will issue an alter to set the spfile hosted under delphix to be the default spfile.

SQL> sho parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /mnt/provision/BGL/datafile/sp
file.ora
SQL>

Regards,

Mouhssine
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
so if we will execute command create pfile from spfile , so it will not create init.ora in OH/dbs...and also we can not alter static parameters
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
suppose if we want to increase sga_max_size after provision so how can we increase it
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,782 Points 4k badge 2x thumb
Hi,

Static and dynamic parameters can be modified inside spfile.

You have just to use correct scope with the alter commande.

Scope=memory, scope=spfile or scope=both

Regards,

Mouhssine
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
Thanks much.
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
one more question..can we add more redo log groups after provision
Photo of Ganesh Sundaresan

Ganesh Sundaresan

  • 92 Points 75 badge 2x thumb

You will not be able to change the online redo log size and groups using the Delphix interface after the VDB is provisioned. 

Although you can directly log on to the VDB to change your redo log size or number of redo log groups after the VDB is provisioned, your changes will disappear when the VDB is refreshed or rewound. They will be replaced by the Delphix settings you entered previously during provisioning

Photo of Jaclyn Schoof

Jaclyn Schoof, Community Manager

  • 5,092 Points 5k badge 2x thumb
Hi Ganesh,
If you would like to keep your init parameters after a refresh please follow our KB article: https://support.delphix.com/hc/en-us/articles/205316927-KB095-How-to-Ensure-a-VDB-Refresh-Keeps-Modi...