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
------------------------------
Original Message:
Sent: 08-04-2021 07:46:48 AM
From: Thinus Meyer
Subject: Refreshing an upgraded vDB from an older dSource
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
Original Message:
Sent: 08-04-2021 05:35:08 AM
From: Luke Moss
Subject: Refreshing an upgraded vDB from an older dSource
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
Original Message:
Sent: 08-04-2021 05:14:12 AM
From: Thinus Meyer
Subject: Refreshing an upgraded vDB from an older dSource
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
Original Message:
Sent: 03-19-2015 04:20:00 PM
From: Jinmyon Coyne
Subject: Refreshing an upgraded vDB from an older dSource
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