Delphix Products

 View Only
  • 1.  Downgrade VDB

    Posted 09-22-2020 10:20:00 AM
    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
    ------------------------------


  • 2.  RE: Downgrade VDB

    Posted 09-22-2020 11:40:00 AM
    Edited by Sandro Latini 09-22-2020 11:40:11 AM

    Hi Lisa,

    I believe it would be best to address this issue via a Support case however, sourceconfig should be available via the CLI while logged in as an Admin user. While this is for PDBs, the steps are similar: https://support.delphix.com/Delphix_Virtualization_Engine/Oracle/Upgrading_or_Changing_ORACLE_HOME_for_vPDB_or_PDB_dSource_(KBA1799)

    Thank you.

    Sandro



    ------------------------------
    Sandro Latini
    Principal Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: Downgrade VDB

    Posted 09-22-2020 12:27:00 PM
    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
    ------------------------------



  • 4.  RE: Downgrade VDB

    Posted 09-22-2020 02:05:00 PM
    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
    ------------------------------



  • 5.  RE: Downgrade VDB

    Posted 09-22-2020 04:04:00 PM

    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
    ------------------------------



  • 6.  RE: Downgrade VDB
    Best Answer

    Posted 09-22-2020 04:56:00 PM

    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
    ------------------------------



  • 7.  RE: Downgrade VDB

    Posted 09-23-2020 03:15:00 AM
    Lisa,

    Glad to hear you've got it fixed with support help.

    KR,

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------