{"id":18095,"date":"2022-07-22T18:13:17","date_gmt":"2022-07-22T16:13:17","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=18095"},"modified":"2022-07-22T18:13:19","modified_gmt":"2022-07-22T16:13:19","slug":"oda-how-to-use-data-preserving-reprovisioning","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/","title":{"rendered":"ODA: How to use Data Preserving Reprovisioning?"},"content":{"rendered":"\n
Introduction<\/h2>\n\n\n\n
Oracle Database Appliance has a global patch available each quarter, so all the components can be patched together on a regular basis. Most of the time, applying the patch on your ODA will be OK, but sometimes you will struggle for multiple reasons. If you don’t apply patch frequently for example. Or if your ODA is heavily tuned. Or if your configuration is partially done manually. For those being not able anymore to correctly apply the patch, the only way of patching was to do a complete reimaging of the ODA, but it’s time consuming as all databases need to be restored.<\/p>\n\n\n\n
19.15 brought a new feature called “Data Preserving Reprovisioning”: like patching, it does not need a restore of all your databases, and like reimaging, your system is reistalled from scratch. This sounds like the best option for most of us.<\/p>\n\n\n\n
Limits<\/h2>\n\n\n\n
Data Preserving Reprovisioning (DPR) is limited to very old versions: 12.1.2.12, 12.2.1.4, 18.3, 18.5, 18.7, and 18.8. It may get increased compatibility in future versions.<\/p>\n\n\n\n
How does it work?<\/h2>\n\n\n\n
Reimaging normally implies to wipe out the data disks before, but this is not more mandatory. You can keep your databases on disk, extract the metadata of your ODA setup, reimage your appliance and then remap the databases to your fresh install. This is a kind of unplug\/plug of your ODA configuration.<\/p>\n\n\n\n
My test environment<\/h2>\n\n\n\n
I’m lucky to have an X8-2M I can play with. And the first thing I did is a reimaging to 18.8. X8 came along 19c, but also supports 18.8.<\/p>\n\n\n\n
For sure, I had to do a cleanup deploy before reimaging (this ODA was already using 19.15), and I struggled with reimaging because partition map prevent reimaging at first tries (probably because those partitions were created for Linux 7, and I put back a Linux 6 so the partition manager called by Anaconda didn’t recognize them). I solved the problem by starting a normal Linux 7 setup (with an Oracle Linux ISO not dedicated to ODA) and removing all partitions from the disks.<\/p>\n\n\n\n
On this 18.8 environment, I deployed 2 DB homes, 18.8 and 12.1. I created 3 databases on it.<\/p>\n\n\n\n
odacli describe-component<\/strong>\nSystem Version\n---------------\n18.8.0.0.0\n\nComponent Installed Version Available Version\n---------------------------------------- -------------------- --------------------\nOAK 18.8.0.0.0 up-to-date\nDB {\n[ OraDB18000_home1 ] 18.8.0.0.191015 up-to-date\n[ OraDB12102_home1 ] 12.1.0.2.191015 up-to-date\n}\nDCSAGENT 18.8.0.0.0 up-to-date\nILOM 5.0.2.24.r141466 4.0.4.38.a.r132148\nBIOS 52050300 52020500\nOS 6.10 up-to-date\nFIRMWARECONTROLLER VDV1RL04 vdv1rl02\nFIRMWAREDISK 1132 1102\n\nodacli list-databases<\/strong>\n\nID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n0681df5a-498e-4bb3-8b1e-a5464e891a56 TSTNOC18 Si 18.8.0.0.191015 false Oltp Odb6 Acfs Configured 3eac70f5-6510-4c7c-bf5b-ed938dc60aa1\n59ada2fe-cf7d-4fe6-b34b-496f611ab13e TSTC18 Si 18.8.0.0.191015 true Oltp Odb2 Asm Configured 3eac70f5-6510-4c7c-bf5b-ed938dc60aa1\ncc44fae8-e508-4b6d-87ee-257b4c48bed8 TSTNOC12 Si 12.1.0.2.191015 false Oltp Odb4 Acfs Configured 8dbba7de-4348-4c61-a171-f7413d30bc14\n<\/code><\/pre>\n\n\n\n
I didn’t do further changes on this system.<\/p>\n\n\n\n
DPR from 18.8 to 19.15: detach the node<\/h2>\n\n\n\n
First step is to detach your configuration, this is like unplugging a PDB. You will need this additional tool from MOS: <\/p>\n\n\n\n
Patch 33594115: DATA PRESERVING REPROVISIONING: UPLOAD ODA UPGRADE UTILITY ZIP TO ARU<\/p><\/blockquote>\n\n\n\n
Unzip the files and run the precheck:<\/p>\n\n\n\n
cd \/opt\/dbi\/\nunzip p33594115_1915000_Linux-x86-64.zip\nunzip -d \/opt\/oracle odaupgradeutil_220530.zip\ncd \/opt\/oracle\/odaupgradeutil\/\n.\/odaupgradeutil run-prechecks<\/strong>\n\nInitializing...\n########################## ODAUPGRADEUTIL - INIT - BEGIN ##########################\nPlease check \/opt\/oracle\/oak\/restore\/log\/odaupgradeutil_init_22-07-2022_11:06:55.log for details.\nGet System Version...BEGIN\nSystem Version is: 18.8.0.0.0\nGet System Version...DONE\nGet Hardware Info...BEGIN\nHardware Model: X8-2, Hardware Platform: M\nGet Hardware Info...DONE\nGet Grid home...BEGIN\nGrid Home is: \/u01\/app\/18.0.0.0\/grid\nGet Grid home...DONE\nGet system configuration details...BEGIN\nGrid user is: grid\nOracle user is: oracle\nGet system configuration details...DONE\n########################## ODAUPGRADEUTIL - INIT - END ##########################\n*********\nIMPORTANT\n*********\nodaupgradeutil will bring down the databases and grid services on the system.\nThe files that belong to the databases, which are stored on ASM or ACFS,\nare left intact on the storage. The databases will be started up back after\nre-imaging the ODA system using 'odacli restore-node' commands.\nAs a good precautionary measure, please backup all the databases on the\nsystem before you start this process. Do not store the backup on this ODA\nmachine since the local file system will be wiped out as part of the re-image.\n*********\nIMPORTANT\n*********\n########################## ODAUPGRADEUTIL - PRECHECKS - BEGIN ##########################\nPlease check \/opt\/oracle\/oak\/restore\/log\/odaupgradeutil_prechecks_22-07-2022_11:07:15.log for details.\nSystem version precheck...BEGIN\nSystem version precheck...PASSED\nSystem config precheck...BEGIN\nSystem config precheck...PASSED\nRequired Files precheck...BEGIN\nRequired Files precheck...PASSED\nNeed to discover DB homes\nGet Database homes...BEGIN\nGet Database homes...SUCCESS\nDisk space precheck...BEGIN\nGet Quorum Disks...BEGIN\nGet Quorum Disks...SUCCESS\nDisk space precheck...PASSED\nDCS Agent status precheck...BEGIN\nDCS Agent status precheck...PASSED\nOAK precheck...BEGIN\nOAK precheck...PASSED\nASM precheck...BEGIN\nASM precheck...PASSED\nDatabase precheck...BEGIN\nGet databases...BEGIN\n Database Name: TSTNOC18\n Oracle Home: \/u01\/app\/oracle\/product\/18.0.0.0\/dbhome_1\n Database Name: TSTC18\n Oracle Home: \/u01\/app\/oracle\/product\/18.0.0.0\/dbhome_1\n Database Name: TSTNOC12\n Oracle Home: \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\nGet databases...SUCCESS\nDatabase precheck...PASSED\nAudit Files precheck...BEGIN\nAudit Files precheck...WARNING\nCustom RPMs precheck...BEGIN\nCustom RPMs precheck...PASSED\n########################## ODAUPGRADEUTIL - PRECHECKS - END ##########################\nUse 'odaupgradeutil describe-precheck-report [-j]' to view the precheck report.<\/code><\/pre>\n\n\n\n
If something is wrong, you can probably try to solve the problem and do a precheck again.<\/p>\n\n\n\n
Once precheck is OK, you can detach:<\/p>\n\n\n\n
.\/odaupgradeutil detach-node<\/strong>\n*********\nIMPORTANT\n*********\nodaupgradeutil will bring down the databases and grid services on the system.\nThe files that belong to the databases, which are stored on ASM or ACFS,\nare left intact on the storage. The databases will be started up back after\nre-imaging the ODA system using 'odacli restore-node' commands.\nAs a good precautionary measure, please backup all the databases on the\nsystem before you start this process. Do not store the backup on this ODA\nmachine since the local file system will be wiped out as part of the re-image.\n*********\nIMPORTANT\n*********\nDo you want to continue? [y\/n]: y<\/strong>\n########################## ODAUPGRADEUTIL - SAVECONF - BEGIN ##########################\nPlease check \/opt\/oracle\/oak\/restore\/log\/odaupgradeutil_saveconf_22-07-2022_11:13:47.log for details.\nBackup files to \/opt\/oracle\/oak\/restore\/bkp...BEGIN\nBackup files to \/opt\/oracle\/oak\/restore\/bkp...SUCCESS\nGet provision instance...BEGIN\nGet provision instance...SUCCESS\nGet network configuration...BEGIN\nGet network configuration...SUCCESS\nGet databases...BEGIN\n Database Name: TSTNOC18\n Oracle Home: \/u01\/app\/oracle\/product\/18.0.0.0\/dbhome_1\n Database Name: TSTC18\n Oracle Home: \/u01\/app\/oracle\/product\/18.0.0.0\/dbhome_1\n Database Name: TSTNOC12\n Oracle Home: \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\nGet databases...SUCCESS\nGet Database homes...BEGIN\n Checking Unified Auditing for dbhome '\/u01\/app\/oracle\/product\/18.0.0.0\/dbhome_1'\n Unified Auditing is set to TRUE\n Checking Unified Auditing for dbhome '\/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1'\n Unified Auditing is set to TRUE\nGet Database homes...SUCCESS\nGet Database storages...BEGIN\n Database Name: TSTNOC18\n DATA destination: \/u02\/app\/oracle\/oradata\/TSTNOC18\/\n RECO destination: \/u03\/app\/oracle\/fast_recovery_area\/\n REDO destination: \/u04\/app\/oracle\/redo\/TSTNOC18\/\n Flash Cache destination:\n Database Name: TSTC18\n DATA destination: +DATA\n RECO destination: +RECO\n REDO destination: +RECO\n Flash Cache destination:\n Database Name: TSTNOC12\n DATA destination: \/u02\/app\/oracle\/oradata\/TSTNOC12\n RECO destination: \/u03\/app\/oracle\/fast_recovery_area\/\n REDO destination: \/u04\/app\/oracle\/redo\/TSTNOC12\/\n Flash Cache destination:\nGet Database storages...SUCCESS\nGet Volumes...BEGIN\nGet Volumes...SUCCESS\nGet Filesystems...BEGIN\nGet Filesystems...SUCCESS\nGet Quorum Disks...BEGIN\nGet Quorum Disks...SUCCESS\nSAVECONF: SUCCESS\n########################## ODAUPGRADEUTIL - SAVECONF - END ##########################\n########################## ODAUPGRADEUTIL - DETACHNODE - BEGIN ##########################\nPlease check \/opt\/oracle\/oak\/restore\/log\/odaupgradeutil_detachnode_22-07-2022_11:15:01.log for details.\nDeconfigure databases...BEGIN\n Database Name: TSTNOC18\n Local Instance: TSTNOC18\n Local Instance Status: RUNNING\n Stopping database 'TSTNOC18'...\n Removing database 'TSTNOC18' from CRS...\n Database Name: TSTC18\n Local Instance: TSTC18\n Local Instance Status: RUNNING\n Stopping database 'TSTC18'...\n Removing database 'TSTC18' from CRS...\n Database Name: TSTNOC12\n Local Instance: TSTNOC12\n Local Instance Status: RUNNING\n Stopping database 'TSTNOC12'...\n Removing database 'TSTNOC12' from CRS...\nDeconfigure databases...SUCCESS\nGet DB backup metadata...BEGIN\nNo backupconfigs found\nNo backupreports found\nQuorum Disks were found\n Quorum disk '\/dev\/SSD_QRMDSK_p1' is 1024 MB in size, no resizing needed\n Quorum disk '\/dev\/SSD_QRMDSK_p2' is 1024 MB in size, no resizing needed\nDeconfigure Grid Infrastructure...BEGIN\nDeconfigure Grid Infrastructure...SUCCESS\nBackup quorum disks...\n Backing up quorum disk '\/dev\/SSD_QRMDSK_p1'\n Backing up quorum disk '\/dev\/SSD_QRMDSK_p2'\nCreate serverarchives...BEGIN\n Serverarchive '\/opt\/oracle\/oak\/restore\/out\/serverarchive_dbi-oda-x8.zip' created\n Size = 365741 bytes\n SHA256 checksum = a272187c6dfd248d4c03a6e793154e3d0ba3a2b002430e9ad0b7adf4b2c19598\nCreate serverarchives...DONE\nDETACHNODE: SUCCESS\n[CRITICAL] Server data archive file(s) generated at \/opt\/oracle\/oak\/restore\/out . Please ensure the file(s) are copied outside the ODA system and preserved.\n########################## ODAUPGRADEUTIL - DETACHNODE - END ##########################<\/code><\/pre>\n\n\n\n
Backup the generated files on a secure place outside the appliance. Basically there is 1 file for a lite ODA, 3 files for an HA ODA.<\/p>\n\n\n\n
DPR from 18.8 to 19.15: reimage the node<\/h2>\n\n\n\n
You won’t do a cleanup.pl prior reimaging as for normal reimaging.<\/p>\n\n\n\n
Reimaging is very easy, first you need to connect the 19.15 ISO from the ILOM console, then choose CDROM for next boot, then do a power cycle. You will need to do that on each node for an HA ODA.<\/p>\n\n\n\n
Reimaging takes about 50 minutes to complete.<\/p>\n\n\n\n
Once done, your ODA is no more reachable on the network, because no network configuration exists on your system.<\/p>\n\n\n\n
DPR from 18.8 to 19.15: configure firstnet<\/h2>\n\n\n\n
After reimaging is finished, you can connect through ILOM console with root\/welcome1. First step after a normal reimaging is the configure firstnet, this is the same here. If you don’t remember your network settings, you can find them in the backup files:<\/p>\n\n\n\n
unzip serverarchive_dbi-oda-x8.zip\ncd restore\/\nls<\/strong>\nbkp\t\t\tconfigure-firstnet.rsp\tinit.params\t\tlog\t\t\tmetadata\t\tprechecks\ncat configure-firstnet.rsp<\/strong>\n# To be used for configure-firstnet post reimage\nHOSTNAME=dbi-oda-x8\nINTERFACE_NAME=btbond1\nVLAN=NO\nIP_ADDR=10.36.0.241\nSUBNET_MASK=255.255.255.0\nGATEWAY=10.36.0.1<\/code><\/pre>\n\n\n\n<\/figure>\n\n\n\n
DPR from 18.8 to 19.15: patch the microcodes<\/h2>\n\n\n\n
This is not my case in this particular example, but if you come from 18.8 or older versions, your microcodes are probably old and never had an update. Do the check, and if some microcodes need an update, you should apply the server and\/or storage patch on top of your fresh reimaging. Download the 19.15 patch, register it and apply the patch on both server and storage:<\/p>\n\n\n\n
Patch 34069644: ORACLE DATABASE APPLIANCE 19.15.0.0.0 SERVER PATCH FOR ALL ODACLI\/DCS STACK<\/p><\/blockquote>\n\n\n\n
DPR from 18.8 to 19.15: reprovision the appliance<\/h2>\n\n\n\n
Now the interesting part is coming. Put back the backup files and register them in the ODA repository, unzip and register the GI clone 19.15, and do a restore node with the -g (grid) option:<\/p>\n\n\n\n
odacli update-repository -f \/opt\/dbi\/serverarchive_dbi-oda-x8.zip\ncd \/opt\/dbi\nunzip p30403673_1915000_Linux-x86-64.zip\nodacli update-repository -f \/opt\/dbi\/odacli-dcs-19.15.0.0.0-220425-GI-19.15.0.0.zip\n\nodacli list-jobs<\/strong>\n\nID Description Created Status\n---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------\n82782a81-d8a2-4266-9074-9160f3f1b7bb Repository Update July 22, 2022 12:00:43 PM UTC Success\n8e60a4ef-04d2-4985-a69b-1ef768da16f9 Repository Update July 22, 2022 12:10:43 PM UTC Success\n\nodacli restore-node -g\nEnter new system password:\nRetype new system password:\nEnter an initial password for Web Console account (oda-admin):\nRetype the password for Web Console account (oda-admin):\nUser 'oda-admin' created successfully...\n{\n \"jobId\" : \"2f7a5cdc-9de7-412a-8107-552fd4980909\",\n \"status\" : \"Created\",\n \"message\" : \"The system will reboot, if required, to enable the licensed number of CPU cores\",\n \"reports\" : [ ],\n \"createTimestamp\" : \"July 22, 2022 12:14:19 PM UTC\",\n \"resourceList\" : [ ],\n \"description\" : \"Restore node service - GI\",\n \"updatedTime\" : \"July 22, 2022 12:14:19 PM UTC\"\n}\n\nodacli describe-job -i 2f7a5cdc-9de7-412a-8107-552fd4980909<\/strong>\n\nJob details\n----------------------------------------------------------------\n ID: 2f7a5cdc-9de7-412a-8107-552fd4980909\n Description: Restore node service - GI\n Status: Success\n Created: July 22, 2022 12:14:19 PM CEST\n Message: The system will reboot, if required, to enable the licensed number of CPU cores\n\nTask Name Start Time End Time Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nRestore node service creation July 22, 2022 12:14:28 PM CEST July 22, 2022 12:38:26 PM CEST Success\nSetting up Network July 22, 2022 12:14:29 PM CEST July 22, 2022 12:14:29 PM CEST Success\nSetting up Vlan July 22, 2022 12:14:48 PM CEST July 22, 2022 12:14:48 PM CEST Success\nSetting up Network July 22, 2022 12:15:08 PM CEST July 22, 2022 12:15:08 PM CEST Success\nnetwork update July 22, 2022 12:15:32 PM CEST July 22, 2022 12:15:51 PM CEST Success\nupdating network July 22, 2022 12:15:32 PM CEST July 22, 2022 12:15:51 PM CEST Success\nSetting up Network July 22, 2022 12:15:32 PM CEST July 22, 2022 12:15:32 PM CEST Success\nOS usergroup 'asmdba'creation July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nOS usergroup 'asmoper'creation July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nOS usergroup 'asmadmin'creation July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nOS usergroup 'dba'creation July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nOS usergroup 'dbaoper'creation July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nOS usergroup 'oinstall'creation July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nOS user 'grid'creation July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nOS user 'oracle'creation July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nDefault backup policy creation July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nBackup config metadata persist July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nGrant permission to RHP files July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nAdd SYSNAME in Env July 22, 2022 12:15:52 PM CEST July 22, 2022 12:15:52 PM CEST Success\nInstall oracle-ahf July 22, 2022 12:15:52 PM CEST July 22, 2022 12:16:53 PM CEST Success\nStop DCS Admin July 22, 2022 12:16:55 PM CEST July 22, 2022 12:16:55 PM CEST Success\nGenerate mTLS certificates July 22, 2022 12:16:55 PM CEST July 22, 2022 12:16:56 PM CEST Success\nExporting Public Keys July 22, 2022 12:16:56 PM CEST July 22, 2022 12:16:58 PM CEST Success\nCreating Trust Store July 22, 2022 12:16:58 PM CEST July 22, 2022 12:16:59 PM CEST Success\nUpdate config files July 22, 2022 12:16:59 PM CEST July 22, 2022 12:17:00 PM CEST Success\nRestart DCS Admin July 22, 2022 12:17:00 PM CEST July 22, 2022 12:17:20 PM CEST Success\nUnzipping storage configuration files July 22, 2022 12:17:20 PM CEST July 22, 2022 12:17:20 PM CEST Success\nReloading multipath devices July 22, 2022 12:17:20 PM CEST July 22, 2022 12:17:20 PM CEST Success\nrestart oakd July 22, 2022 12:17:20 PM CEST July 22, 2022 12:17:31 PM CEST Success\nReloading multipath devices July 22, 2022 12:18:32 PM CEST July 22, 2022 12:18:32 PM CEST Success\nrestart oakd July 22, 2022 12:18:32 PM CEST July 22, 2022 12:18:42 PM CEST Success\nRestore Quorum Disks July 22, 2022 12:18:42 PM CEST July 22, 2022 12:18:43 PM CEST Success\nCreating GI home directories July 22, 2022 12:18:43 PM CEST July 22, 2022 12:18:43 PM CEST Success\nExtract GI clone July 22, 2022 12:18:43 PM CEST July 22, 2022 12:20:15 PM CEST Success\nCreating wallet for Root User July 22, 2022 12:20:15 PM CEST July 22, 2022 12:20:20 PM CEST Success\nCreating wallet for ASM Client July 22, 2022 12:20:20 PM CEST July 22, 2022 12:20:23 PM CEST Success\nGrid stack creation July 22, 2022 12:20:24 PM CEST July 22, 2022 12:31:53 PM CEST Success\nGI Restore with RHP July 22, 2022 12:20:24 PM CEST July 22, 2022 12:28:32 PM CEST Success\nUpdating GIHome version July 22, 2022 12:28:33 PM CEST July 22, 2022 12:28:36 PM CEST Success\nPost cluster OAKD configuration July 22, 2022 12:31:53 PM CEST July 22, 2022 12:34:16 PM CEST Success\nMounting disk group DATA July 22, 2022 12:34:16 PM CEST July 22, 2022 12:34:17 PM CEST Success\nMounting disk group RECO July 22, 2022 12:34:25 PM CEST July 22, 2022 12:34:33 PM CEST Success\nSetting ACL for disk groups July 22, 2022 12:34:40 PM CEST July 22, 2022 12:34:44 PM CEST Success\nRegister Scan and Vips to Public Network July 22, 2022 12:34:44 PM CEST July 22, 2022 12:34:46 PM CEST Success\nConfigure export clones resource July 22, 2022 12:35:40 PM CEST July 22, 2022 12:35:41 PM CEST Success\nAdding Volume COMMONSTORE to Clusterware July 22, 2022 12:35:43 PM CEST July 22, 2022 12:35:47 PM CEST Success\nAdding Volume DATTSTNOC12 to Clusterware July 22, 2022 12:35:47 PM CEST July 22, 2022 12:35:50 PM CEST Success\nAdding Volume DATTSTNOC18 to Clusterware July 22, 2022 12:35:50 PM CEST July 22, 2022 12:35:54 PM CEST Success\nAdding Volume RDOTSTNOC12 to Clusterware July 22, 2022 12:35:54 PM CEST July 22, 2022 12:35:57 PM CEST Success\nAdding Volume RDOTSTNOC18 to Clusterware July 22, 2022 12:35:57 PM CEST July 22, 2022 12:36:01 PM CEST Success\nAdding Volume RECO to Clusterware July 22, 2022 12:36:01 PM CEST July 22, 2022 12:36:04 PM CEST Success\nEnabling Volume(s) July 22, 2022 12:36:04 PM CEST July 22, 2022 12:37:16 PM CEST Success\nProvisioning service creation July 22, 2022 12:38:25 PM CEST July 22, 2022 12:38:25 PM CEST Success\npersist new agent state entry July 22, 2022 12:38:25 PM CEST July 22, 2022 12:38:25 PM CEST Success\npersist new agent state entry July 22, 2022 12:38:25 PM CEST July 22, 2022 12:38:25 PM CEST Success\nRestart Zookeeper and DCS Agent July 22, 2022 12:38:25 PM CEST July 22, 2022 12:38:26 PM CEST Success\n\ndf -h \/dev\/asm\/*<\/strong>\nFilesystem Size Used Avail Use% Mounted on\n\/dev\/asm\/acfsclone-207 150G 7.0G 144G 5% \/opt\/oracle\/oak\/pkgrepos\/orapkgs\/clones\n\/dev\/asm\/commonstore-207 5.0G 319M 4.7G 7% \/opt\/oracle\/dcs\/commonstore\n\/dev\/asm\/dattstnoc12-207 100G 2.2G 98G 3% \/u02\/app\/oracle\/oradata\/TSTNOC12\n\/dev\/asm\/dattstnoc18-207 100G 2.1G 98G 3% \/u02\/app\/oracle\/oradata\/TSTNOC18\n\/dev\/asm\/rdotstnoc12-158 14G 13G 1.7G 88% \/u04\/app\/oracle\/redo\/TSTNOC12\n\/dev\/asm\/rdotstnoc18-158 29G 25G 4.7G 84% \/u04\/app\/oracle\/redo\/TSTNOC18\n\/dev\/asm\/reco-158 297G 976M 297G 1% \/u03\/app\/oracle\n\nsu - grid<\/strong>\nasmcmd ls +data\/TSTC18\/datafile\/*\nSYSAUX.271.1110706283\nSYSTEM.270.1110706247\nUNDOTBS1.272.1110706299\nUSERS.283.1110707033\n\nexit<\/strong>\n<\/code><\/pre>\n\n\n\n
My ACFS and ASM files are there.<\/p>\n\n\n\n
DPR from 18.8 to 19.15: reprovision the DB homes and remap the databases<\/h2>\n\n\n\n
I now need the DB clones files to be deployed. If you remember, I had 2x 18.8 databases, and 1x 12.1 database. Required clone files can be found in a list:<\/p>\n\n\n\n
cat \/opt\/oracle\/oak\/restore\/metadata\/dbVersions.list<\/strong>\n# List of all db versions found, to be used for downloading required clones before DB restore\n18.8.0.0.191015\n12.1.0.2.191015\n<\/code><\/pre>\n\n\n\n
I will use DB clones coming from my 18.8.<\/p>\n\n\n\n
I first need to create the dbhome storage:<\/p>\n\n\n\n
odacli configure-dbhome-storage -dg DATA -s 80<\/strong>\n<\/code><\/pre>\n\n\n\n
And add the DB clones to the repository:<\/p>\n\n\n\n
Now it’s possible to remap the database to the DB homes with the restore-node -d (database):<\/p>\n\n\n\n
odacli restore-node -d\n\nodacli describe-job -i 4b579397-2c93-420a-846b-5a2aebe71d32<\/strong>\n\nJob details\n----------------------------------------------------------------\n ID: 4b579397-2c93-420a-846b-5a2aebe71d32\n Description: Restore node service - Database\n Status: Success\n Created: July 22, 2022 4:36:29 PM CEST\n Message:\n\nTask Name Start Time End Time Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nSetting up ssh equivalance July 22, 2022 4:36:49 PM CEST July 22, 2022 4:36:49 PM CEST Success\nDB home creation: OraDB18000_home1 July 22, 2022 4:36:50 PM CEST July 22, 2022 4:39:31 PM CEST Success\nValidating dbHome available space July 22, 2022 4:36:50 PM CEST July 22, 2022 4:36:50 PM CEST Success\nCreating DbHome Directory July 22, 2022 4:36:50 PM CEST July 22, 2022 4:36:50 PM CEST Success\nCreate required directories July 22, 2022 4:36:50 PM CEST July 22, 2022 4:36:50 PM CEST Success\nExtract DB clone July 22, 2022 4:36:50 PM CEST July 22, 2022 4:38:15 PM CEST Success\nProvDbHome by using RHP July 22, 2022 4:38:15 PM CEST July 22, 2022 4:39:12 PM CEST Success\nEnable DB options July 22, 2022 4:39:13 PM CEST July 22, 2022 4:39:29 PM CEST Success\nCreating wallet for DB Client July 22, 2022 4:39:31 PM CEST July 22, 2022 4:39:31 PM CEST Success\nDB home creation: OraDB12102_home1 July 22, 2022 4:39:31 PM CEST July 22, 2022 4:42:47 PM CEST Success\nValidating dbHome available space July 22, 2022 4:39:31 PM CEST July 22, 2022 4:39:31 PM CEST Success\nCreating DbHome Directory July 22, 2022 4:39:31 PM CEST July 22, 2022 4:39:31 PM CEST Success\nCreate required directories July 22, 2022 4:39:31 PM CEST July 22, 2022 4:39:31 PM CEST Success\nExtract DB clone July 22, 2022 4:39:31 PM CEST July 22, 2022 4:41:02 PM CEST Success\nProvDbHome by using RHP July 22, 2022 4:41:02 PM CEST July 22, 2022 4:42:30 PM CEST Success\nEnable DB options July 22, 2022 4:42:30 PM CEST July 22, 2022 4:42:40 PM CEST Success\nCreating wallet for DB Client July 22, 2022 4:42:46 PM CEST July 22, 2022 4:42:47 PM CEST Success\nPersist database storage locations July 22, 2022 4:42:47 PM CEST July 22, 2022 4:42:47 PM CEST Success\n Save metadata for TSTNOC18 July 22, 2022 4:42:47 PM CEST July 22, 2022 4:42:47 PM CEST Success\n Save metadata for TSTC18 July 22, 2022 4:42:47 PM CEST July 22, 2022 4:42:47 PM CEST Success\n Save metadata for TSTNOC12 July 22, 2022 4:42:47 PM CEST July 22, 2022 4:42:47 PM CEST Success\nPersist database storages July 22, 2022 4:42:47 PM CEST July 22, 2022 4:42:47 PM CEST Success\n Save metadata for TSTNOC18 July 22, 2022 4:42:47 PM CEST July 22, 2022 4:42:47 PM CEST Success\n Save metadata for TSTC18 July 22, 2022 4:42:47 PM CEST July 22, 2022 4:42:47 PM CEST Success\n Save metadata for TSTNOC12 July 22, 2022 4:42:47 PM CEST July 22, 2022 4:42:47 PM CEST Success\nRestore database: TSTNOC18 July 22, 2022 4:42:47 PM CEST July 22, 2022 4:44:11 PM CEST Success\n Adding database TSTNOC18 to GI July 22, 2022 4:42:47 PM CEST July 22, 2022 4:42:49 PM CEST Success\n Adding database instance(s) to GI July 22, 2022 4:42:49 PM CEST July 22, 2022 4:42:49 PM CEST Success\n Modifying SPFILE for database July 22, 2022 4:42:49 PM CEST July 22, 2022 4:43:33 PM CEST Success\n Restore password file for database July 22, 2022 4:43:33 PM CEST July 22, 2022 4:43:34 PM CEST Success\n Start instance(s) for database July 22, 2022 4:43:34 PM CEST July 22, 2022 4:43:52 PM CEST Success\n Persist metadata for database July 22, 2022 4:43:52 PM CEST July 22, 2022 4:43:52 PM CEST Success\n Clear all listeners from Database July 22, 2022 4:43:52 PM CEST July 22, 2022 4:43:53 PM CEST Success\n Run SqlPatch July 22, 2022 4:43:56 PM CEST July 22, 2022 4:44:11 PM CEST Success\nRestore database: TSTC18 July 22, 2022 4:44:11 PM CEST July 22, 2022 4:46:05 PM CEST Success\n Adding database TSTC18 to GI July 22, 2022 4:44:11 PM CEST July 22, 2022 4:44:13 PM CEST Success\n Adding database instance(s) to GI July 22, 2022 4:44:13 PM CEST July 22, 2022 4:44:13 PM CEST Success\n Modifying SPFILE for database July 22, 2022 4:44:13 PM CEST July 22, 2022 4:45:05 PM CEST Success\n Restore password file for database July 22, 2022 4:45:05 PM CEST July 22, 2022 4:45:05 PM CEST Success\n Start instance(s) for database July 22, 2022 4:45:05 PM CEST July 22, 2022 4:45:28 PM CEST Success\n Persist metadata for database July 22, 2022 4:45:28 PM CEST July 22, 2022 4:45:28 PM CEST Success\n Clear all listeners from Database July 22, 2022 4:45:28 PM CEST July 22, 2022 4:45:29 PM CEST Success\n Run SqlPatch July 22, 2022 4:45:32 PM CEST July 22, 2022 4:46:05 PM CEST Success\nRestore database: TSTNOC12 July 22, 2022 4:46:05 PM CEST July 22, 2022 4:47:38 PM CEST Success\n Adding database TSTNOC12 to GI July 22, 2022 4:46:05 PM CEST July 22, 2022 4:46:07 PM CEST Success\n Adding database instance(s) to GI July 22, 2022 4:46:07 PM CEST July 22, 2022 4:46:07 PM CEST Success\n Modifying SPFILE for database July 22, 2022 4:46:07 PM CEST July 22, 2022 4:46:40 PM CEST Success\n Restore password file for database July 22, 2022 4:46:40 PM CEST July 22, 2022 4:46:41 PM CEST Success\n Start instance(s) for database July 22, 2022 4:46:41 PM CEST July 22, 2022 4:46:59 PM CEST Success\n Persist metadata for database July 22, 2022 4:46:59 PM CEST July 22, 2022 4:46:59 PM CEST Success\n Clear all listeners from Database July 22, 2022 4:46:59 PM CEST July 22, 2022 4:47:00 PM CEST Success\n Run SqlPatch July 22, 2022 4:47:03 PM CEST July 22, 2022 4:47:38 PM CEST Success\nRestore Object Stores July 22, 2022 4:47:38 PM CEST July 22, 2022 4:47:38 PM CEST Success\nRemount NFS backups July 22, 2022 4:47:38 PM CEST July 22, 2022 4:47:38 PM CEST Success\nRestore BackupConfigs July 22, 2022 4:47:38 PM CEST July 22, 2022 4:47:38 PM CEST Success\nReattach backupconfigs to DBs July 22, 2022 4:47:38 PM CEST July 22, 2022 4:47:39 PM CEST Success\nRestore backup reports July 22, 2022 4:47:39 PM CEST July 22, 2022 4:47:39 PM CEST Success\n<\/code><\/pre>\n\n\n\n
Everything looks OK.<\/p>\n\n\n\n
Let’s check databases and pmons:<\/p>\n\n\n\n
odacli list-databases<\/strong>\n\nID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n0a06b4a6-29a4-41e9-bd38-f1f2984f3590 TSTNOC18 SI 18.8.0.0.191015 false OLTP odb6 ACFS CONFIGURED 3514b78c-a1c8-42dd-a9b7-ff13d5a496fe\n35895ff7-f485-43d9-8877-bdc0a872a4bf TSTC18 SI 18.8.0.0.191015 true OLTP odb2 ASM CONFIGURED 3514b78c-a1c8-42dd-a9b7-ff13d5a496fe\n9c18400f-403c-4a6b-b0f7-7ec8bd7d4c87 TSTNOC12 SI 12.1.0.2.191015 false OLTP odb4 ACFS CONFIGURED 3b00a7ce-bdb4-4d4c-8153-9dac8dff6e61\n\nps -ef | grep pmon | grep -v grep<\/strong>\noracle 547 1 0 16:45 ? 00:00:00 ora_pmon_TSTC18\ngrid 6986 1 0 14:30 ? 00:00:00 asm_pmon_+ASM1\noracle 13404 1 0 16:46 ? 00:00:00 ora_pmon_TSTNOC12\ngrid 31490 1 0 14:35 ? 00:00:00 apx_pmon_+APX1\noracle 87126 1 0 16:43 ? 00:00:00 ora_pmon_TSTNOC18\n<\/code><\/pre>\n\n\n\n
Perfect!<\/p>\n\n\n\n
I would recommend deploying newest DB homes and migrating your databases to get rid of these old versions.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
This feature is really convenient, and it works. It’s definitely cleaner than patching, and faster than a complete reimaging. I just hope this will be possible for all starting version in the next releases. For now, I’ve no plan to use it because most of the ODAs I work on are now already using 19.x. Those using old versions are also running on old hardware.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction Oracle Database Appliance has a global patch available each quarter, so all the components can be patched together on a regular basis. Most of the time, applying the patch on your ODA will be OK, but sometimes you will struggle for multiple reasons. If you don’t apply patch frequently for example. Or if your […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[2623,656,1916,2570,2620,2621,2567,2619,2625,2626,2568,2622,2624,2618,2617],"type_dbi":[],"class_list":["post-18095","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-12-1","tag-12-2","tag-18-8","tag-19-15","tag-data-preserving-reprovisioning","tag-dpr","tag-oda-2","tag-odacli-restore-node","tag-odaupgradeutil","tag-odaupgradeutil-detach-node","tag-oracle-database-appliance-2","tag-patch-old-oda","tag-patching-or-reimaging","tag-patching-problem-solution","tag-reimaging-without-destroying-the-databases"],"acf":[],"yoast_head":"\n
ODA: How to use Data Preserving Reprovisioning? - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ODA: How to use Data Preserving Reprovisioning?\" \/>\n<meta property=\"og:description\" content=\"Introduction Oracle Database Appliance has a global patch available each quarter, so all the components can be patched together on a regular basis. Most of the time, applying the patch on your ODA will be OK, but sometimes you will struggle for multiple reasons. If you don’t apply patch frequently for example. Or if your […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-22T16:13:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T16:13:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/Screenshot-2022-07-22-at-13.37.29.png\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"ODA: How to use Data Preserving Reprovisioning?\",\"datePublished\":\"2022-07-22T16:13:17+00:00\",\"dateModified\":\"2022-07-22T16:13:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/\"},\"wordCount\":895,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/07\\\/Screenshot-2022-07-22-at-13.37.29.png\",\"keywords\":[\"12.1\",\"12.2\",\"18.8\",\"19.15\",\"Data Preserving Reprovisioning\",\"dpr\",\"oda\",\"odacli restore-node\",\"odaupgradeutil\",\"odaupgradeutil detach-node\",\"oracle database appliance\",\"patch old oda\",\"patching or reimaging\",\"patching problem solution\",\"reimaging without destroying the databases\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/\",\"name\":\"ODA: How to use Data Preserving Reprovisioning? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/07\\\/Screenshot-2022-07-22-at-13.37.29.png\",\"datePublished\":\"2022-07-22T16:13:17+00:00\",\"dateModified\":\"2022-07-22T16:13:19+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/07\\\/Screenshot-2022-07-22-at-13.37.29.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/07\\\/Screenshot-2022-07-22-at-13.37.29.png\",\"width\":904,\"height\":384},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-how-to-use-data-preserving-reprovisioning\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODA: How to use Data Preserving Reprovisioning?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\",\"name\":\"J\u00e9r\u00f4me Dubar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Dubar\"},\"description\":\"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\\\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/jerome-dubar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ODA: How to use Data Preserving Reprovisioning? - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/","og_locale":"en_US","og_type":"article","og_title":"ODA: How to use Data Preserving Reprovisioning?","og_description":"Introduction Oracle Database Appliance has a global patch available each quarter, so all the components can be patched together on a regular basis. Most of the time, applying the patch on your ODA will be OK, but sometimes you will struggle for multiple reasons. If you don’t apply patch frequently for example. Or if your […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/","og_site_name":"dbi Blog","article_published_time":"2022-07-22T16:13:17+00:00","article_modified_time":"2022-07-22T16:13:19+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/Screenshot-2022-07-22-at-13.37.29.png","type":"","width":"","height":""}],"author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"19 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"ODA: How to use Data Preserving Reprovisioning?","datePublished":"2022-07-22T16:13:17+00:00","dateModified":"2022-07-22T16:13:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/"},"wordCount":895,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/Screenshot-2022-07-22-at-13.37.29.png","keywords":["12.1","12.2","18.8","19.15","Data Preserving Reprovisioning","dpr","oda","odacli restore-node","odaupgradeutil","odaupgradeutil detach-node","oracle database appliance","patch old oda","patching or reimaging","patching problem solution","reimaging without destroying the databases"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/","url":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/","name":"ODA: How to use Data Preserving Reprovisioning? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/Screenshot-2022-07-22-at-13.37.29.png","datePublished":"2022-07-22T16:13:17+00:00","dateModified":"2022-07-22T16:13:19+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/Screenshot-2022-07-22-at-13.37.29.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/Screenshot-2022-07-22-at-13.37.29.png","width":904,"height":384},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODA: How to use Data Preserving Reprovisioning?"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd","name":"J\u00e9r\u00f4me Dubar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Dubar"},"description":"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=18095"}],"version-history":[{"count":5,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18095\/revisions"}],"predecessor-version":[{"id":18101,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18095\/revisions\/18101"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=18095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=18095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=18095"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=18095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/07\/Screenshot-2022-07-22-at-13.37.29.png\")
<\/figure>\n\n\n\n