# 環境描述

- 系統：Redhat Linux 7.9
- 源端版本：Oracle RAC 11.2.0.4
- 目標端版本：Oracle RAC 19.15.0.0

# 資料同步

可以使用 RMAN 備份恢復，也可以使用 DG 做資料庫同步，此處不再贅述，總之建議做異機升級，然後在目標端機器我們會將 11g 環境升級到 19c，下面我將詳細說明升級過程

# 11g 升級

1. grid、oracle 兩個節點分別執行
   此處將資料庫升級為 11g 最新 PSU 的版本，檔案傳輸、zip包解壓、OPatch 升級此處略

```shell
   /u01/app/grid/OPatch/opatch auto /u01/31718723 -oh /u01/app/grid
   /u01/app/oracle/product/11.0/dbhome_1/OPatch/opatch auto /u01/31718723 -oh /u01/app/oracle/product/11.0/dbhome_1
   ```
   
2. 升級資料字典

略

# 升級 grid

### 環境準備

在目標端節點一上傳所有所需軟體包，然後解壓 grid、oracle 軟體到各自的 ORACLE_HOME 目錄，然後我們開始升級

### 設定 ASM 版本

```sql
alter diskgroup DATA set attribute 'compatible.asm'='11.2.0.4';
alter diskgroup DATA set attribute 'compatible.rdbms'='11.2.0.4.0';
```

### 升級軟體

```shell
./gridSetup.sh
```
![image-20220501214542469](http://img.blog.itpub.net/blog/2022/05/05/5ae768a59b92fc1b.png?x-oss-process=style/bb)

![image-20220501214614074](http://img.blog.itpub.net/blog/2022/05/05/058464d1269c963f.png?x-oss-process=style/bb)

![image-20220501214715804](http://img.blog.itpub.net/blog/2022/05/05/7f029adca5643a87.png?x-oss-process=style/bb)

![image-20220501215408303](http://img.blog.itpub.net/blog/2022/05/05/d1afd59c2155e153.png?x-oss-process=style/bb)

![image-20220501215515996](http://img.blog.itpub.net/blog/2022/05/05/5eee46311a5fd689.png?x-oss-process=style/bb)

![image-20220502014216011](http://img.blog.itpub.net/blog/2022/05/05/bc78f0b5aaecacd9.png?x-oss-process=style/bb)

![image-20220502014240559](http://img.blog.itpub.net/blog/2022/05/05/661758ff1d27c069.png?x-oss-process=style/bb)

```
/u01/app/19.0/grid/rootupgrade.sh
```

```
[root@node1 ~]# /u01/app/19.0/grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/19.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/crsdata/node1/crsconfig/rootcrs_node1_2022-05-02_04-37-29AM.log
2022/05/02 04:37:49 CLSRSC-595: Executing upgrade step 1 of 18: 'UpgradeTFA'.
2022/05/02 04:37:49 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2022/05/02 04:37:49 CLSRSC-595: Executing upgrade step 2 of 18: 'ValidateEnv'.
2022/05/02 04:37:57 CLSRSC-595: Executing upgrade step 3 of 18: 'GetOldConfig'.
2022/05/02 04:37:57 CLSRSC-464: Starting retrieval of the cluster configuration data
2022/05/02 04:38:07 CLSRSC-692: Checking whether CRS entities are ready for upgrade. This operation may take a few minutes.
2022/05/02 04:40:51 CLSRSC-693: CRS entities validation completed successfully.
2022/05/02 04:40:59 CLSRSC-515: Starting OCR manual backup.
2022/05/02 04:41:09 CLSRSC-516: OCR manual backup successful.
2022/05/02 04:41:13 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2022/05/02 04:43:30 CLSRSC-486: 
 At this stage of upgrade, the OCR has changed.
 Any attempt to downgrade the cluster after this point will require a complete cluster outage to restore the OCR.
2022/05/02 04:43:30 CLSRSC-541: 
 To downgrade the cluster: 
 1. All nodes that have been upgraded must be downgraded.
2022/05/02 04:43:30 CLSRSC-542: 
 2. Before downgrading the last node, the Grid Infrastructure stack on all other cluster nodes must be down.
2022/05/02 04:43:40 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2022/05/02 04:43:40 CLSRSC-595: Executing upgrade step 4 of 18: 'GenSiteGUIDs'.
2022/05/02 04:43:41 CLSRSC-595: Executing upgrade step 5 of 18: 'UpgPrechecks'.
2022/05/02 04:43:46 CLSRSC-363: User ignored prerequisites during installation
2022/05/02 04:43:53 CLSRSC-595: Executing upgrade step 6 of 18: 'SetupOSD'.
2022/05/02 04:43:53 CLSRSC-595: Executing upgrade step 7 of 18: 'PreUpgrade'.
2022/05/02 04:44:24 CLSRSC-468: Setting Oracle Clusterware and ASM to rolling migration mode
2022/05/02 04:44:25 CLSRSC-482: Running command: '/u01/app/19.0/grid/bin/asmca -silent -upgradeNodeASM -nonRolling false -oldCRSHome /u01/app/grid -oldCRSVersion 11.2.0.4.0 -firstNode true -startRolling true '

ASM configuration upgraded in local node successfully.

2022/05/02 04:44:33 CLSRSC-469: Successfully set Oracle Clusterware and ASM to rolling migration mode
2022/05/02 04:44:44 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack
2022/05/02 04:45:11 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.
2022/05/02 04:45:17 CLSRSC-595: Executing upgrade step 8 of 18: 'CheckCRSConfig'.
2022/05/02 04:45:18 CLSRSC-595: Executing upgrade step 9 of 18: 'UpgradeOLR'.
2022/05/02 04:45:30 CLSRSC-595: Executing upgrade step 10 of 18: 'ConfigCHMOS'.
2022/05/02 04:45:30 CLSRSC-595: Executing upgrade step 11 of 18: 'UpgradeAFD'.
2022/05/02 04:45:39 CLSRSC-595: Executing upgrade step 12 of 18: 'createOHASD'.
2022/05/02 04:45:51 CLSRSC-595: Executing upgrade step 13 of 18: 'ConfigOHASD'.
2022/05/02 04:45:52 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2022/05/02 04:46:48 CLSRSC-595: Executing upgrade step 14 of 18: 'InstallACFS'.
2022/05/02 04:47:51 CLSRSC-595: Executing upgrade step 15 of 18: 'InstallKA'.
2022/05/02 04:48:00 CLSRSC-595: Executing upgrade step 16 of 18: 'UpgradeCluster'.
clscfg: EXISTING configuration version 5 detected.
Successfully taken the backup of node specific configuration in OCR. 
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
2022/05/02 05:01:51 CLSRSC-343: Successfully started Oracle Clusterware stack
2022/05/02 05:01:58 CLSRSC-595: Executing upgrade step 17 of 18: 'UpgradeNode'.
2022/05/02 05:02:03 CLSRSC-474: Initiating upgrade of resource types
2022/05/02 05:02:41 CLSRSC-475: Upgrade of resource types successfully initiated.
2022/05/02 05:02:54 CLSRSC-595: Executing upgrade step 18 of 18: 'PostUpgrade'.
2022/05/02 05:03:08 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
```

![image-20220504231630393](http://img.blog.itpub.net/blog/2022/05/05/917713ce87b12554.png?x-oss-process=style/bb)

![image-20220504231714543](http://img.blog.itpub.net/blog/2022/05/05/629800db742a5e70.png?x-oss-process=style/bb)

# 升級 DB

```shell
groupadd -g 1007 backupdba
groupadd -g 1008 dgdba
groupadd -g 1009 kmdba
usermod -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,oper,asmadmin oracle
```

```shell
./runInstaller
```

![image-20220502024332819](http://img.blog.itpub.net/blog/2022/05/05/3cd7a2549e7ca27c.png?x-oss-process=style/bb)

![image-20220502024355943](http://img.blog.itpub.net/blog/2022/05/05/baffa7011e52690c.png?x-oss-process=style/bb)

![image-20220502024413955](http://img.blog.itpub.net/blog/2022/05/05/95a70cbca55118c1.png?x-oss-process=style/bb)

![image-20220502024539977](http://img.blog.itpub.net/blog/2022/05/05/caeb670c52efa424.png?x-oss-process=style/bb)

![image-20220502024555685](http://img.blog.itpub.net/blog/2022/05/05/fe1091441d8f5c61.png?x-oss-process=style/bb)

![image-20220502025457321](http://img.blog.itpub.net/blog/2022/05/05/cae0f44292a923e8.png?x-oss-process=style/bb)

![image-20220502025525517](http://img.blog.itpub.net/blog/2022/05/05/4ba59724787e68a2.png?x-oss-process=style/bb)

![image-20220502103520509](http://img.blog.itpub.net/blog/2022/05/05/0a8c9e42a2421c8a.png?x-oss-process=style/bb)

![image-20220502103546144](http://img.blog.itpub.net/blog/2022/05/05/64e922885da24d58.png?x-oss-process=style/bb)

```shell
/u01/app/oracle/product/19.0/dbhome_1/root.sh
```

![image-20220505081042844](http://img.blog.itpub.net/blog/2022/05/05/6c56cbfa1b512d62.png?x-oss-process=style/bb)

# 升級資料庫

```shell
dbua
```

![image-20220505081517043](http://img.blog.itpub.net/blog/2022/05/05/c3942d9818c116b5.png?x-oss-process=style/bb)

![image-20220505081710278](http://img.blog.itpub.net/blog/2022/05/05/32c91e3aff003488.png?x-oss-process=style/bb)

- Starting with Oracle Database 12c, the OLAP Catalog (OLAP AMD) is desupported and will be automatically marked as OPTION OFF during the database upgrade if present. Oracle recommends removing OLAP Catalog (OLAP AMD) before database upgrade. This step can be manually performed before the upgrade to reduce downtime. (more details)
- Starting with Oracle Database 12c, the local Enterprise Manager Database Control does not exist anymore. The repository will be removed from your database during the upgrade. This step can be manually performed before the upgrade to reduce downtime. (more details)
- Starting with Oracle Database Release 18, APEX is not upgraded automatically as part of the database upgrade. Refer to My Oracle Support Note 1088970.1 for information about APEX installation and upgrades. (more details)

![image-20220505082017642](http://img.blog.itpub.net/blog/2022/05/05/50d2283e1cf37653.png?x-oss-process=style/bb)

![image-20220505082046977](http://img.blog.itpub.net/blog/2022/05/05/c7827980c833724b.png?x-oss-process=style/bb)

![image-20220505082200351](http://img.blog.itpub.net/blog/2022/05/05/5e6dfef4c5b8f134.png?x-oss-process=style/bb)

![image-20220505083437017](http://img.blog.itpub.net/blog/2022/05/05/26738dcbe40d9240.png?x-oss-process=style/bb)

![image-20220505083502568](http://img.blog.itpub.net/blog/2022/05/05/fea0e36b2ec21734.png?x-oss-process=style/bb)

![image-20220505084550254](http://img.blog.itpub.net/blog/2022/05/05/fe47656c7226dbeb.png?x-oss-process=style/bb)

![image-20220505163338533](http://img.blog.itpub.net/blog/2022/05/05/afef339b40bca815.png?x-oss-process=style/bb)

# 回退

1. 回退指令碼

```shell
   /u01/app/oracle/cfgtoollogs/dbua/upgrade2022-05-05_09-26-12AM/orcl/orcl1_restore.sh
   ```

# 解除安裝 Oracle 11g

### 刪除 DB Home

1. 解除安裝軟體

```shell
   /u01/app/oracle/product/19.0/dbhome_1/oui/bin/runInstaller -detachHome -silent ORACLE_HOME=/u01/app/oracle/product/11.0/dbhome_1
   ```

2. 刪除目錄

```shell
   rm -rf /u01/app/oracle/product/11.2.0
   ```

### 刪除 GRID Home

1. 解除安裝軟體

```shell
   /u01/app/19.0/grid/oui/bin/runInstaller -detachHome -silent ORACLE_HOME=/u01/app/grid
   ```

2. 刪除目錄

```shell
   rm -rf /u01/app/grid
   ```

### 修改 inventory

```shell
vim /u01/app/oraInventory/ContentsXML/inventory.xml
```

### 刪除還原點

```shell
set line 333 pages 9999
col RESTORE_POINT_TIME for a32
col TIME for a32
col NAME for a20
select SCN, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE, TIME, NAME
  from v$restore_point;

SCN GUARAN STORAGE_SIZE TIME				NAME
---------- ------ ------------ -------------------------------- --------------------
   1030197 YES	    1835008000 05-MAY-22 09.29.57.000000000 AM	GRP_1651714197258

SQL> drop restore point GRP_1651714197258;

Restore point dropped.

```

Oracle：Oracle RAC 11.2.0.4 升級為 19c

相關文章