Delphix Products

How Delphix create pointer for spfile and init.ora file, because init.ora reside in Oracle_home/dbs and spfile reside in DxFS
#Virtualization

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

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

suppose if we want to increase sga_max_size after provision so how can we increase it

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

Thanks much.

one more question..can we add more redo log groups after provision

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

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...">https://support.delphix.com/hc/en-us/articles/205316927-KB095-How-to-Ensure-a-VDB-Refresh-Keeps-Modified-init-Parameters">https://support.delphix.com/hc/en-us/articles/205316927-KB095-How-to-Ensure-a-VDB-Refresh-Keeps-Modi...