Mouhssine,
Unfortunately with invalid parameters, the database won't go into the nomount stage. Support was able to set a bit which would keep the NFS file systems mounted. Then I was able to recreate the spfile without those parameters.
sqlplus / as sysdba
create pfile='/tmp/init.ora' from spfile='/var/appl/delphix/<dbname>/spfile.ora';
exit;
Use your favorite editor to remove the parameters from /tmp/init.ora
sqlplus / as sysdba
create spfile='/var/appl/delphix/<dbname>/spfile.ora' from pfile='/tmp/init.ora' ;
It's unfortunate it required a support case to resolve, but thankfully we were able to get it back up and running today.
Best Regards,
------------------------------
Lisa Garczynski
Database Engineer III
Paychex
------------------------------
Original Message:
Sent: 09-22-2020 04:03:55 PM
From: Mouhssine SAIDI
Subject: Downgrade VDB
Hi Lisa,
You can use a hooks before DB start to unset those underscored parameters, you can get the full list for the parameters with issue from the alert log of your vdb.
once done construct a sql command with commands like this one to disable them
alter system reset __unified_pga_pool_size scope=spfile;
You have to get the database at least at nomount stage.
BR,
Mouhssine
------------------------------
Mouhssine SAIDI
Community Member
Delphix Community Members
Original Message:
Sent: 09-22-2020 02:04:41 PM
From: Lisa Garczynski
Subject: Downgrade VDB
Thanks, that was my issue.
The other problem was oracle adding new underscore parameters when the DB was started with 19c that were invalid with the older release. These are not in my template.. Those had to be removed but I needed Delphix support help to mount the file systems so the spfile could be fixed.
example
__unified_pga_pool_size=0
Thanks for the reply.
------------------------------
Lisa Garczynski
Database Engineer III
Paychex
Original Message:
Sent: 09-22-2020 12:27:17 PM
From: Kevin Gross
Subject: Downgrade VDB
Hi Lisa,
You wrote:
>> sourceconfig doesn't exist and source doesn't have a "update repository" option.
sourceconfig is only available when logging into the CLI as the user 'delphix_admin' or 'admin' or any other user with the User Type of Engine Administrator.
Thanks
Kevin
------------------------------
Kevin Gross
Senior Technical Support Engineer
Delphix
Original Message:
Sent: 09-22-2020 10:19:33 AM
From: Lisa Garczynski
Subject: Downgrade VDB
A couple of VDBs were marked as "upgrade" when they were not actually upgraded. When the VDBs had to be restarted for something else, now they will not start because they are attempting to use the new binaries.
How do I point a VDB at the proper binaries after the "upgrade" option was chosen in error?
This option to update in the CLI doesn't work.
https://support.delphix.com/Delphix_Virtualization_Engine/Oracle/Testing_an_Oracle_Upgrade_Using_Rewind_(KBA1772)
sourceconfig doesn't exist and source doesn't have a "update repository" option.
We're using 5.3.6
Thanks!
Lisa
------------------------------
Lisa Garczynski
Database Engineer III
Paychex
------------------------------