Introduction
Data Preserving Reprovisioning enables reprovisioning of an already deployed Oracle Database Appliance system without modifying the storage and and the databases on the appliance. The advantage of this method over the regular upgrade process is that it has a much shorter upgrade path. This is achieved by saving the information of the source system, capturing them as server data archive files.
Advantages of using Data Preserving Reprovisioning for upgrade are as follows:
- The upgrade utility runs prechecks on the system, such as detection of databases that are inactive and provides a warning before you upgrade the appliance. You can proactively address these failures beforehand and not encounter issues at the time of reprovisioning of the appliance.
- During the first step of detaching the node, information about the system is collected and preserved, including information about the VLAN, CPU, and Oracle AFD settings. These settings are migrated after the reimage and the third step in this process reprovisions these settings.
- The deployment is initially at Oracle Database Appliance release 12.1.2.12, 12.2.1.4, or 18.x, but after the reprovisioning process, the software is upgraded to Oracle Database Appliance release 19.15 and the deployment automatically starts using new features wherever applicable. For example, the database software is installed on Oracle ACFS-based storage.
- You can upgrade your appliance directly to the latest Oracle Database Appliance release without upgrading to intermediate releases.
Limits
Data Preserving Reprovisioning (DPR) is limited to old versions: 12.1.2.12, 12.2.1.4, 18.3, 18.5, 18.7, and 18.8.
How does it work?
Reimaging normally implies wiping out the data disks before, but this is not 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.
Environment
I have an X7 and the first thing I did is a reimaging to 18.8. X7 came along 19c, but also supports 18.8.
On this 18.8 environment, I deployed 2 DB homes, 18.8 and 12.2. I created 2 databases on it.
odacli describe-component
System Version
---------------
18.8.0.0.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
OAK 18.8.0.0.0 up-to-date
DB {
[ OraDB18000_home1 ] 18.8.0.0.191015 up-to-date
[ OraDB12204_home1 ] 12.2.1.4.191015 up-to-date
}
DCSAGENT 18.8.0.0.0 up-to-date
ILOM 5.0.2.24.r141466 4.0.4.38.a.r132148
BIOS 52050300 52020500
OS 6.10 up-to-date
FIRMWARECONTROLLER VDV1RL04 vdv1rl02
FIRMWAREDISK 1132 1102
odacli list-databases
ID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID
---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------
7c724f57-a495-4db9-a88a-48323f3632c6 DUTS18c Si 18.8.0.0.191015 false Oltp Odb4 ASM Configured 3eac70f5-6510-4c7c-bf5b-ed938dc60aa1
7041785be-d58e-44c6-b51d-d2729a99b8e8 DUTS12c Si 12.2.1.4.191015 false Oltp Odb4 ASM Configured 8dbba7de-4348-4c61-a171-f7413d30bc14
Detach the node
First step is to detach your configuration. You will need this additional tool from MOS:
Patch 33594115: DATA PRESERVING REPROVISIONING: UPLOAD ODA UPGRADE UTILITY ZIP TO ARU
Unzip the files and run the precheck:
cd /transfer/oracle unzip p33594115_1915000_Linux-x86-64.zip unzip -d /opt/oracle odaupgradeutil_220530.zip cd /opt/oracle/odaupgradeutil/ ./odaupgradeutil run-prechecks Initializing... ########################## ODAUPGRADEUTIL - INIT - BEGIN ########################## Please check /opt/oracle/oak/restore/log/odaupgradeutil_init_12-01-2023_10:06:55.log for details. Get System Version...BEGIN System Version is: 18.8.0.0.0 Get System Version...DONE Get Hardware Info...BEGIN Hardware Model: X7-2, Hardware Platform: M Get Hardware Info...DONE Get Grid home...BEGIN Grid Home is: /u01/app/18.0.0.0/grid Get Grid home...DONE Get system configuration details...BEGIN Grid user is: grid Oracle user is: oracle Get system configuration details...DONE ########################## ODAUPGRADEUTIL - INIT - END ########################## ********* IMPORTANT ********* odaupgradeutil will bring down the databases and grid services on the system. The files that belong to the databases, which are stored on ASM or ACFS, are left intact on the storage. The databases will be started up back after re-imaging the ODA system using 'odacli restore-node' commands. As a good precautionary measure, please backup all the databases on the system before you start this process. Do not store the backup on this ODA machine since the local file system will be wiped out as part of the re-image. ********* IMPORTANT ********* ########################## ODAUPGRADEUTIL - PRECHECKS - BEGIN ########################## Please check /opt/oracle/oak/restore/log/odaupgradeutil_prechecks_12-01-2023_10:07:15.log for details. System version precheck...BEGIN System version precheck...PASSED System config precheck...BEGIN System config precheck...PASSED Required Files precheck...BEGIN Required Files precheck...PASSED Need to discover DB homes Get Database homes...BEGIN Get Database homes...SUCCESS Disk space precheck...BEGIN Get Quorum Disks...BEGIN Get Quorum Disks...SUCCESS Disk space precheck...PASSED DCS Agent status precheck...BEGIN DCS Agent status precheck...PASSED OAK precheck...BEGIN OAK precheck...PASSED ASM precheck...BEGIN ASM precheck...PASSED Database precheck...BEGIN Get databases...BEGIN Database Name: DUTS18c Oracle Home: /u01/app/oracle/product/18.0/dbhome_1 Database Name: DUTS12c Oracle Home: /u01/app/oracle/product/12.2/dbhome_1 Get databases...SUCCESS Database precheck...PASSED Audit Files precheck...BEGIN Audit Files precheck...WARNING Custom RPMs precheck...BEGIN Custom RPMs precheck...PASSED ########################## ODAUPGRADEUTIL - PRECHECKS - END ########################## Use 'odaupgradeutil describe-precheck-report [-j]' to view the precheck report.
Once precheck is OK, you can detach:
./odaupgradeutil detach-node
*********
IMPORTANT
*********
odaupgradeutil will bring down the databases and grid services on the system.
The files that belong to the databases, which are stored on ASM or ACFS,
are left intact on the storage. The databases will be started up back after
re-imaging the ODA system using 'odacli restore-node' commands.
As a good precautionary measure, please backup all the databases on the
system before you start this process. Do not store the backup on this ODA
machine since the local file system will be wiped out as part of the re-image.
*********
IMPORTANT
*********
Do you want to continue? [y/n]: y
########################## ODAUPGRADEUTIL - SAVECONF - BEGIN ##########################
Please check /opt/oracle/oak/restore/log/odaupgradeutil_saveconf_12-01-2023_10:1:47.log for details.
Backup files to /opt/oracle/oak/restore/bkp...BEGIN
Backup files to /opt/oracle/oak/restore/bkp...SUCCESS
Get provision instance...BEGIN
Get provision instance...SUCCESS
Get network configuration...BEGIN
Get network configuration...SUCCESS
Get databases...BEGIN
Database Name: DUTS18c
Oracle Home: /u01/app/oracle/product/18.0/dbhome_1
Database Name: DUTS12c
Oracle Home: /u01/app/oracle/product/12.2/dbhome_1
Get databases...SUCCESS
Get Database homes...BEGIN
Checking Unified Auditing for dbhome '/u01/app/oracle/product/18.0/dbhome_1'
Unified Auditing is set to TRUE
Checking Unified Auditing for dbhome '/u01/app/oracle/product/12.2/dbhome_1'
Unified Auditing is set to TRUE
Get Database homes...SUCCESS
Get Database storages...BEGIN
Database Name: DUTS18c
DATA destination: +DATA
RECO destination: +RECO
REDO destination: +RECO
Flash Cache destination:
Database Name: DUTS12c
DATA destination: +DATA
RECO destination: +RECO
REDO destination: +RECO
Flash Cache destination:
Get Database storages...SUCCESS
Get Volumes...BEGIN
Get Volumes...SUCCESS
Get Filesystems...BEGIN
Get Filesystems...SUCCESS
Get Quorum Disks...BEGIN
Get Quorum Disks...SUCCESS
SAVECONF: SUCCESS
########################## ODAUPGRADEUTIL - SAVECONF - END ##########################
########################## ODAUPGRADEUTIL - DETACHNODE - BEGIN ##########################
Please check /opt/oracle/oak/restore/log/odaupgradeutil_detachnode_12-01-2023_10:15:01.log for details.
Deconfigure databases...BEGIN
Database Name: DUTS18c
Local Instance: DUTS18c
Local Instance Status: RUNNING
Stopping database 'DUTS18c'...
Removing database 'DUTS18c' from CRS...
Database Name: DUTS12c
Local Instance: DUTS12c
Local Instance Status: RUNNING
Stopping database 'DUTS12c'...
Removing database 'DUTS12c' from CRS...
Deconfigure databases...SUCCESS
Get DB backup metadata...BEGIN
No backupconfigs found
No backupreports found
Quorum Disks were found
Quorum disk '/dev/SSD_QRMDSK_p1' is 1024 MB in size, no resizing needed
Quorum disk '/dev/SSD_QRMDSK_p2' is 1024 MB in size, no resizing needed
Deconfigure Grid Infrastructure...BEGIN
Deconfigure Grid Infrastructure...SUCCESS
Backup quorum disks...
Backing up quorum disk '/dev/SSD_QRMDSK_p1'
Backing up quorum disk '/dev/SSD_QRMDSK_p2'
Create serverarchives...BEGIN
Serverarchive '/opt/oracle/oak/restore/out/serverarchive-oda-x7.zip' created
Size = 365741 bytes
SHA256 checksum = c01b39c7a35ccc3b081a3e83d2c71fa9a767ebfeb45c69f08e17dfe3ef375a7b
Create serverarchives...DONE
DETACHNODE: SUCCESS
[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.
########################## ODAUPGRADEUTIL - DETACHNODE - END ##########################
Backup was generated successfully. Let’s move it to an area outside of ODA.
ls -lrt /opt/oracle/oak/restore/out/ total 368 -rw------- 1 root root 65 Jan 12 10:21 serverarchive-oda-x7.zip.sha256 -rw-r--r-- 1 root root 365741 Jan 12 10:21 serverarchive-oda-x7.zip cp /opt/oracle/oak/restore/out/serverarchive* /transfer/oda-bkp-dpr
Reimage the node
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.
Reimaging takes about 60 minutes to complete.
Once done, your ODA is no more reachable on the network because no network configuration exists on your system.
Configure firstnet
After reimaging is finished, you can connect through ILOM console with root/welcome1.
First step after a normal reimaging is the configure firstnet.
[root@cko1 ~]# /opt/oracle/dcs/bin/odacli configure-firstnet Select the Interface to configure the network on (bond0 bond1) [bond0]: Configure DHCP on bond0 (yes/no) [no]: INFO: You have chosen Static configuration Use VLAN on bond0 (yes/no) [no]:yes Configure VLAN on bond0, input VLAN ID [2 - 4094] 1099 INFO: using network interface bond0.1099 Enter the IP address to configure : 200.201.65.100 Enter the Netmask address to configure : 255.255.255.0 Enter the Gateway address to configure[200.201.65.1] : INFO: Restarting the network Shutting down interface bond0: [ OK ] Shutting down interface bond1: [ OK ] Shutting down interface ib0: [ OK ] Shutting down interface ib1: [ OK ] Shutting down interface ibbond0: [ OK ] Shutting down loopback interface: [ OK ] Bringing up loopback interface: [ OK ] Bringing up interface bond0: [ OK ] Bringing up interface bond1: [ OK ] Bringing up interface ibbond0: Determining if ip address 192.168.16.24 is already in use for device ibbond0... [ OK ] Bringing up interface bond0.1099: Determining if ip address 200.201.65.100 is already in use for device bond0.1099... [ OK ] INFO: Restarting the DCS agent initdcsagent stop/waiting initdcsagent start/running, process 23750 [root@cko1 ~]#
Reprovision the appliance
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:
odacli update-repository -f /transfer/oda-bkp-dpr/serverarchive-oda-x7.zip
cd /transfer/oracle
unzip p30403673_1915000_Linux-x86-64.zip
odacli update-repository -f /transfer/oracle/odacli-dcs-19.15.0.0.0-220425-GI-19.15.0.0.zip
odacli list-jobs
ID Description Created Status
—————————————- ————————————————————————— ———————————– ———-
b66269aa-e007-4304-8074-7ba7e9c8c5c2 Repository Update Jan 12, 2023 1:00:43 PM UTC Success
f07961fa-4192-489b-9a55-53165a012376 Repository Update Jan 12, 2023 1:10:43 PM UTC Success
odacli restore-node -g
Enter new system password:
Retype new system password:
Enter an initial password for Web Console account (oda-admin):
Retype the password for Web Console account (oda-admin):
User ‘oda-admin’ created successfully…
{
“jobId” : “cdfd2e72-777b-4ccb-a670-17b88c7cc102”,
“status” : “Created”,
“message” : “The system will reboot, if required, to enable the licensed number of CPU cores”,
“reports” : [ ],
“createTimestamp” : “Jan 12, 2023 1:14:19 PM UTC”,
“resourceList” : [ ],
“description” : “Restore node service – GI”,
“updatedTime” : “July 12, 2023 1:14:19 PM UTC”
}
odacli describe-job -i cdfd2e72-777b-4ccb-a670-17b88c7cc102
Job details
—————————————————————-
ID: cdfd2e72-777b-4ccb-a670-17b88c7cc102
Description: Restore node service – GI
Status: Success
Created: Jan 12, 2023 1:14:19 PM CST
Message: The system will reboot, if required, to enable the licensed number of CPU cores
Task Name Start Time End Time Status
—————————————- ———————————– ———————————– ———-
Restore node service creation Jan 12, 2023 1:14:28 PM CST Jan 12, 2023 1:38:26 PM CST Success
Setting up Network Jan 12, 2023 1:14:29 PM CST Jan 12, 2023 1:14:29 PM CST Success
Setting up Vlan Jan 12, 2023 1:14:48 PM CST Jan 12, 2023 1:14:48 PM CST Success
Setting up Network Jan 12, 2023 1:15:08 PM CST Jan 12, 2023 1:15:08 PM CST Success
network update Jan 12, 2023 1:15:32 PM CST Jan 12, 2023 1:15:51 PM CST Success
updating network Jan 12, 2023 1:15:32 PM CST Jan 12, 2023 1:15:51 PM CST Success
Setting up Network Jan 12, 2023 1:15:32 PM CST Jan 12, 2023 1:15:32 PM CST Success
OS usergroup ‘asmdba’creation Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
OS usergroup ‘asmoper’creation Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
OS usergroup ‘asmadmin’creation Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
OS usergroup ‘dba’creation Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
OS usergroup ‘dbaoper’creation Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
OS usergroup ‘oinstall’creation Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
OS user ‘grid’creation Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
OS user ‘oracle’creation Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
Default backup policy creation Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
Backup config metadata persist Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
Grant permission to RHP files Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
Add SYSNAME in Env Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:15:52 PM CST Success
Install oracle-ahf Jan 12, 2023 1:15:52 PM CST Jan 12, 2023 1:16:53 PM CST Success
Stop DCS Admin Jan 12, 2023 1:16:55 PM CST Jan 12, 2023 1:16:55 PM CST Success
Generate mTLS certificates Jan 12, 2023 1:16:55 PM CST Jan 12, 2023 1:16:56 PM CST Success
Exporting Public Keys Jan 12, 2023 1:16:56 PM CST Jan 12, 2023 1:16:58 PM CST Success
Creating Trust Store Jan 12, 2023 1:16:58 PM CST Jan 12, 2023 1:16:59 PM CST Success
Update config files Jan 12, 2023 1:16:59 PM CST Jan 12, 2023 1:17:00 PM CST Success
Restart DCS Admin Jan 12, 2023 1:17:00 PM CST Jan 12, 2023 1:17:20 PM CST Success
Unzipping storage configuration files Jan 12, 2023 1:17:20 PM CST Jan 12, 2023 1:17:20 PM CST Success
Reloading multipath devices Jan 12, 2023 1:17:20 PM CST Jan 12, 2023 1:17:20 PM CST Success
restart oakd Jan 12, 2023 1:17:20 PM CST Jan 12, 2023 1:17:31 PM CST Success
Reloading multipath devices Jan 12, 2023 1:18:32 PM CST Jan 12, 2023 1:18:32 PM CST Success
restart oakd Jan 12, 2023 1:18:32 PM CST Jan 12, 2023 1:18:42 PM CST Success
Restore Quorum Disks Jan 12, 2023 1:18:42 PM CST Jan 12, 2023 1:18:43 PM CST Success
Creating GI home directories Jan 12, 2023 1:18:43 PM CST Jan 12, 2023 1:18:43 PM CST Success
Extract GI clone Jan 12, 2023 1:18:43 PM CST Jan 12, 2023 1:20:15 PM CST Success
Creating wallet for Root User Jan 12, 2023 1:20:15 PM CST Jan 12, 2023 1:20:20 PM CST Success
Creating wallet for ASM Client Jan 12, 2023 1:20:20 PM CST Jan 12, 2023 1:20:23 PM CST Success
Grid stack creation Jan 12, 2023 1:20:24 PM CST Jan 12, 2023 1:31:53 PM CST Success
GI Restore with RHP Jan 12, 2023 1:20:24 PM CST Jan 12, 2023 1:28:32 PM CST Success
Updating GIHome version Jan 12, 2023 1:28:33 PM CST Jan 12, 2023 1:28:36 PM CST Success
Post cluster OAKD configuration Jan 12, 2023 1:31:53 PM CST Jan 12, 2023 1:34:16 PM CST Success
Mounting disk group DATA Jan 12, 2023 1:34:16 PM CST Jan 12, 2023 1:34:17 PM CST Success
Mounting disk group RECO Jan 12, 2023 1:34:25 PM CST Jan 12, 2023 1:34:33 PM CST Success
Setting ACL for disk groups Jan 12, 2023 1:34:40 PM CST Jan 12, 2023 1:34:44 PM CST Success
Register Scan and Vips to Public Network Jan 12, 2023 1:34:44 PM CST Jan 12, 2023 1:34:46 PM CST Success
Configure export clones resource Jan 12, 2023 1:35:40 PM CST Jan 12, 2023 1:35:41 PM CST Success
Adding Volume COMMONSTORE to Clusterware Jan 12, 2023 1:35:43 PM CST Jan 12, 2023 1:35:47 PM CST Success
Adding Volume DATTSTNOC12 to Clusterware Jan 12, 2023 1:35:47 PM CST Jan 12, 2023 1:35:50 PM CST Success
Adding Volume DATTSTNOC18 to Clusterware Jan 12, 2023 1:35:50 PM CST Jan 12, 2023 1:35:54 PM CST Success
Adding Volume RDOTSTNOC12 to Clusterware Jan 12, 2023 1:35:54 PM CST Jan 12, 2023 1:35:57 PM CST Success
Adding Volume RDOTSTNOC18 to Clusterware Jan 12, 2023 1:35:57 PM CST Jan 12, 2023 1:36:01 PM CST Success
Adding Volume RECO to Clusterware Jan 12, 2023 1:36:01 PM CST Jan 12, 2023 1:36:04 PM CST Success
Enabling Volume(s) Jan 12, 2023 1:36:04 PM CST Jan 12, 2023 1:37:16 PM CST Success
Provisioning service creation Jan 12, 2023 1:38:25 PM CST Jan 12, 2023 1:38:25 PM CST Success
persist new agent state entry Jan 12, 2023 1:38:25 PM CST Jan 12, 2023 1:38:25 PM CST Success
persist new agent state entry Jan 12, 2023 1:38:25 PM CST Jan 12, 2023 1:38:25 PM CST Success Restart Zookeeper and DCS Agent Jan 12, 2023 1:38:25 PM CST Jan 12, 2023 1:38:26 PM CST Success
Reprovision the DB homes and remap the databases
Required clone files can be found in a list:
cat /opt/oracle/oak/restore/metadata/dbVersions.list # List of all db versions found, to be used for downloading required clones before DB restore 18.8.0.0.191015 12.2.0.4.191015
Add the DB clones to the repository:
odacli update-repository -f /transfer/oracle/odacli-dcs-18.8.0.0.0-191226-DB-12.2.0.4.zip odacli update-repository -f /transfer/oracle/odacli-dcs-18.8.0.0.0-191226-DB-18.0.0.0.zip
Now it’s possible to remap the database to the DB homes with the restore-node -d (database):
odacli restore-node -d
odacli describe-job -i 18d1e5f8-7c31-4ce7-8241-f7b2ed5673cd
Job details
----------------------------------------------------------------
ID: 18d1e5f8-7c31-4ce7-8241-f7b2ed5673cd
Description: Restore node service - Database
Status: Success
Created: Jan 12, 2023 4:36:29 PM CST
Message:
Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance Jan 12, 2023 4:36:49 PM CST Jan 12, 2023 4:36:49 PM CST Success
DB home creation: OraDB18000_home1 Jan 12, 2023 4:36:50 PM CST Jan 12, 2023 4:39:31 PM CST Success
Validating dbHome available space Jan 12, 2023 4:36:50 PM CST Jan 12, 2023 4:36:50 PM CST Success
Creating DbHome Directory Jan 12, 2023 4:36:50 PM CST Jan 12, 2023 4:36:50 PM CST Success
Create required directories Jan 12, 2023 4:36:50 PM CST Jan 12, 2023 4:36:50 PM CST Success
Extract DB clone Jan 12, 2023 4:36:50 PM CST Jan 12, 2023 4:38:15 PM CST Success
ProvDbHome by using RHP Jan 12, 2023 4:38:15 PM CST Jan 12, 2023 4:39:12 PM CST Success
Enable DB options Jan 12, 2023 4:39:13 PM CST Jan 12, 2023 4:39:29 PM CST Success
Creating wallet for DB Client Jan 12, 2023 4:39:31 PM CST Jan 12, 2023 4:39:31 PM CST Success
DB home creation: OraDB12204_home1 Jan 12, 2023 4:39:31 PM CST Jan 12, 2023 4:42:47 PM CST Success
Validating dbHome available space Jan 12, 2023 4:39:31 PM CST Jan 12, 2023 4:39:31 PM CST Success
Creating DbHome Directory Jan 12, 2023 4:39:31 PM CST Jan 12, 2023 4:39:31 PM CST Success
Create required directories Jan 12, 2023 4:39:31 PM CST Jan 12, 2023 4:39:31 PM CST Success
Extract DB clone Jan 12, 2023 4:39:31 PM CST Jan 12, 2023 4:41:02 PM CST Success
ProvDbHome by using RHP Jan 12, 2023 4:41:02 PM CST Jan 12, 2023 4:42:30 PM CST Success
Enable DB options Jan 12, 2023 4:42:30 PM CST Jan 12, 2023 4:42:40 PM CST Success
Creating wallet for DB Client Jan 12, 2023 4:42:46 PM CST Jan 12, 2023 4:42:47 PM CST Success
Persist database storage locations Jan 12, 2023 4:42:47 PM CST Jan 12, 2023 4:42:47 PM CST Success
Save metadata for DUTS18c Jan 12, 2023 4:42:47 PM CST Jan 12, 2023
4:42:47 PM CST Success
Save metadata for DUTS12c Jan 12, 2023 4:42:47 PM CST Jan 12, 2023 4:42:47 PM CST Success
Persist database storages Jan 12, 2023 4:42:47 PM CST Jan 12, 2023 4:42:47 PM CST Success
Save metadata for DUTS18c Jan 12, 2023 4:42:47 PM CST Jan 12, 2023 4:42:47 PM CST Success
Save metadata for DUTS12c Jan 12, 2023 4:42:47 PM CST Jan 12, 2023 4:42:47 PM CST Success
Restore database: DUTS18c Jan 12, 2023 4:42:47 PM CST Jan 12, 2023 4:44:11 PM CST Success
Adding database DUTS18c to GI Jan 12, 2023 4:42:47 PM CST Jan 12, 2023 4:42:49 PM CST Success
Adding database instance(s) to GI Jan 12, 2023 4:42:49 PM CST Jan 12, 2023 4:42:49 PM CST Success
Modifying SPFILE for database Jan 12, 2023 4:42:49 PM CST Jan 12, 2023 4:43:33 PM CST Success
Restore password file for database Jan 12, 2023 4:43:33 PM CST Jan 12, 2023 4:43:34 PM CST Success
Start instance(s) for database Jan 12, 2023 4:43:34 PM CST Jan 12, 2023 4:43:52 PM CST Success
Persist metadata for database Jan 12, 2023 4:43:52 PM CST Jan 12, 2023 4:43:52 PM CST Success
Clear all listeners from Database Jan 12, 2023 4:43:52 PM CST Jan 12, 2023 4:43:53 PM CST Success
Run SqlPatch Jan 12, 2023 4:43:56 PM CST Jan 12, 2023 4:44:11 PM CST Success
Restore database: DUTS12c Jan 12, 2023 4:44:11 PM CST Jan 12, 2023 4:46:05 PM CST Success
Adding database DUTS12c to GI Jan 12, 2023 4:44:11 PM CST Jan 12, 2023 4:44:13 PM CST Success
Adding database instance(s) to GI Jan 12, 2023 4:44:13 PM CST Jan 12, 2023 4:44:13 PM CST Success
Modifying SPFILE for database Jan 12, 2023 4:44:13 PM CST Jan 12, 2023 4:45:05 PM CST Success
Restore password file for database Jan 12, 2023 4:45:05 PM CST Jan 12, 2023 4:45:05 PM CST Success
Start instance(s) for database Jan 12, 2023 4:45:05 PM CST Jan 12, 2023 4:45:28 PM CST Success
Persist metadata for database Jan 12, 2023 4:45:28 PM CST Jan 12, 2023 4:45:28 PM CST Success
Clear all listeners from Database Jan 12, 2023 4:45:28 PM CST Jan 12, 2023 4:45:29 PM CST Success
Run SqlPatch Jan 12, 2023 4:45:32 PM CST Jan 12, 2023 4:46:05 PM CST Success
Restore Object Stores Jan 12, 2023 4:47:38 PM CST Jan 12, 2023 4:47:38 PM CST Success
Remount NFS backups Jan 12, 2023 4:47:38 PM CST Jan 12, 2023 4:47:38 PM CST Success
Restore BackupConfigs Jan 12, 2023 4:47:38 PM CST Jan 12, 2023 4:47:38 PM CST Success
Reattach backupconfigs to DBs Jan 12, 2023 4:47:38 PM CST Jan 12, 2023 4:47:39 PM CST Success
Restore backup reports Jan 12, 2023 4:47:39 PM CST Jan 12, 2023 4:47:39 PM CST Success
Everything looks OK.
Let’s check databases and pmon process:
odacli list-databases ID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID ---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ---------------------------------------- 886021e5-9bbf-4a14-9b50-398ddd00bfd0 DUTS18c SI 18.8.0.0.191015 false OLTP odb4 ASM CONFIGURED 3512b78c-a1c9-42dd-a9b7-ff13d5a587fe d791001f-b812-49fd-94f5-b11c5f580a30 DUTS12c SI 12.2.1.4.191015 false OLTP odb4 ASM CONFIGURED 3b10a8ce-bdb4-4d4c-2053-9dac8dff7e61 ps -ef | grep pmon | grep -v grep oracle 447 1 0 16:45 ? 00:00:00 ora_pmon_DUTS18c grid 2986 1 0 14:30 ? 00:00:00 asm_pmon_+ASM1 oracle 19304 1 0 16:46 ? 00:00:00 ora_pmon_DUTS12c
Hope this helps you!!!
Disclaimer: “The postings on this site are my own and don’t necessarily represent may actual employer positions, strategies or opinions. The information here was edited to be useful for general purpose, specific data and identifications was removed to allow reach generic audience and to be useful
