Delphix Products

Expand all | Collapse all

Refreshing an upgraded vDB from an older dSource

Jump to Best Answer
  • 1.  Refreshing an upgraded vDB from an older dSource

    Posted 03-19-2015 04:20:00 PM
    Is it possible to refresh a vDB that has been upgraded to a higher Oracle binary version from a dSource that is still on the older version?

    For example -

    TEST1 is the dSource and is on 11.2.0.1.
    vDBTEST is the vDB that was created @ 11.2.0.1 but has then been upgraded to 11.2.0.3

    Can I refresh vDBTEST from TEST1? Would the binary revert back to 11.2.0.1?

    Thanks!
    Jimmy

    #Tip


  • 2.  RE: Refreshing an upgraded vDB from an older dSource

    Posted 03-19-2015 04:38:00 PM
    Thanks for the response!

    Not sure if I understand - I do not really mean rewinding a vDB but refreshing from the dSource. Would the upgraded vDB remain the same binary if refreshed from the dSource or would it revert back to the dSource binary?


  • 3.  RE: Refreshing an upgraded vDB from an older dSource

    Posted 03-19-2015 04:52:00 PM
    If you are refreshing then the VDB will revert back to the dSource binaries since a refresh from the dSource is like reprovisioning


  • 4.  RE: Refreshing an upgraded vDB from an older dSource

    Posted 03-19-2015 04:54:00 PM
    OK I got it. Thanks Jaclyn for the quick answer. Really appreciate the help here.


  • 5.  RE: Refreshing an upgraded vDB from an older dSource

    Posted 03-19-2015 05:18:00 PM
    I do also want to note that you might need to the "upgrade" the VDB again so that it points to the right Oracle binaries


  • 6.  RE: Refreshing an upgraded vDB from an older dSource

    Posted 03-19-2015 04:28:00 PM
    Hi Jimmy,
    Currently we do not have a rewind a VDB feature, though there is an open request for this that we are in the process of working on for future versions of Delphix. There are some workarounds to do this, if you haven't made any changes to the VDB the easiest thing would be to provision a new VDB from the point in time from before the upgrade. If you have made changes, a VDB is an Oracle database and you would be able to downgrade just as you would an Oracle database (this Oracle Support article might be helpful); though if you do this you also need to use the process in Upgrading an Oracle dSource so that Delphix picks up the new Oracle binaries. 

    Hope that helps!
    Jaclyn


  • 7.  RE: Refreshing an upgraded vDB from an older dSource

    Posted 08-04-2021 05:14:00 AM
    Hi Jimmy,

    I am facing the same situation and would like to know how you accomplished it. My VDB is Oracle 19C (upgraded months ago, rewind no longer available) and my dSource is still Oracle 12.1

    I need to refresh the VDB and upgrade to 19C again. My understanding from the posts below is that I can simply
    1.) refresh the VDB (no need to change Delphix metadata for the VDB back to Oracle 12.1 home)
    2.) upgrade the VDB to 19C

    ------------------------------
    Thinus Meyer
    Delphix Community Members
    ------------------------------



  • 8.  RE: Refreshing an upgraded vDB from an older dSource

    Posted 08-04-2021 05:35:00 AM

    Hello Thinus,

    Thanks for using the community to reach out. To switch a VDB back to it's lower version you will need to use the CLI.

    For example:


    # ssh admin@<delphix-engine>
    engine>
    engine> sourceconfig
    engine sourceconfig> ls
    Objects
    NAME REPOSITORY LINKINGENABLED
    TESTVDB '/u01/app/oracle/product/19.0.0.0/dbhome_1' true
    engine sourceconfig> select TESTVDB
    engine sourceconfig 'TESTVDB'> update
    engine sourceconfig 'TESTVDB' update *> set repository='/u01/app/ora12101/product/12.1.0/dbhome_1'
    engine sourceconfig 'TESTVDB' update *> commit

    Where
    set repository='/u01/app/ora12101/product/12.1.0/dbhome_1'
    is the 12c repository you copied.

    Refresh VDB back to Prod.

    I hope this helps.



    ------------------------------
    Luke Moss
    Senior Support Engineer
    Delphix
    ------------------------------



  • 9.  RE: Refreshing an upgraded vDB from an older dSource

    Posted 08-04-2021 07:47:00 AM
    Thank you Luke!
    I also followed Testing an Oracle Upgrade Using Rewind (KBA1772) - Delphix
    and set the compatible parameter down from 19 to 12

    /source; select MYVDB; update
    edit configParams
    set compatible='12.1.0.2.0'
    commit

    But the refresh from the GUI failed with:
    "SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 4 16:18:25 2021 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL> ORACLE>ORA-00401: the value for parameter compatible is not supported by this release"
    which indicates that the correct ORACLE_HOME is being used BUT that the compatible parameter is still 19.

    I used the CLI and did a ls on the properties and confirmed that compatible: '12.1.0.2.0'
    1.) How can I confirm what the setting is for the parameter compatible
    2.) How can I change it?


    Thanks
    Thinus





    ------------------------------
    Thinus Meyer
    Delphix Community Members
    ------------------------------



  • 10.  RE: Refreshing an upgraded vDB from an older dSource
    Best Answer

    Posted 08-04-2021 11:43:00 PM
    The process worked! Just some notes for the next person who needs to do the same task.

    VDB=19C & dSOURCE=12.1 & task was to refresh VDB

    Step1) set $ORACLE_HOME
    in the CLI
    /sourceconfig; select MYVDB; update;
    set repository=/'/oracle/app/product/12.1.0/dbhome_2';
    commit;
    & edit /etc/oratab on the VDB host

    Step2)set init.ora parameter from 19 to 12
    in the cli
    /source; select MYVDB; update
    edit configParams
    set compatible='12.1.0.2.0'
    set configTemplate=DPX-MEDIUM-12C    -------> we use VDB Config Templates
    commit

    Step3) refresh VDB from GUI -> a 12.1 VDB gets provisioned




    ------------------------------
    Thinus Meyer
    Specialist
    Abu Dhabi Investment Authority
    ------------------------------