# 环境描述 - 系统：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 ```        ``` /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 ```   # 升级 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 ```          ```shell /u01/app/oracle/product/19.0/dbhome_1/root.sh ```  # 升级数据库 ```shell dbua ```   - 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)        # 回退 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. ```