关于使用DBUA对oracle11.2.0.4升级19c中断的后续处理

使用DBUA对Oracle11.2.0.4进行19c升级时进程异常中断的后续处理，在dbua进程进行数据库upgrade升级的时候，DBUA工具因为突然异常退出导致升级程序中断,很多步骤没有跑完，然后sqlplus /  as sysdba进入空闲实例启动数据库的时候提示报错

SQL> startup
ORACLE instance started.

Total System Global Area 1593831936 bytes
Fixed Size 8897024 bytes
Variable Size 922746880 bytes
Database Buffers 654311424 bytes
Redo Buffers 7876608 bytes
Database mounted.
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier
Process ID: 15589
Session ID: 4 Serial number: 39325

并且trc文件提示

*** 2024-10-16T14:00:53.022277+08:00
*** SESSION ID:(4.39325) 2024-10-16T14:00:53.022367+08:00
*** CLIENT ID:() 2024-10-16T14:00:53.022450+08:00
*** SERVICE NAME:(SYS$USERS) 2024-10-16T14:00:53.022489+08:00
*** MODULE NAME:(sqlplus@oracle11g (TNS V1-V3)) 2024-10-16T14:00:53.022525+08:00
*** ACTION NAME:() 2024-10-16T14:00:53.022561+08:00
*** CLIENT DRIVER:(SQL*PLUS) 2024-10-16T14:00:53.022595+08:00

ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier
<error barrier> at 0x7ffd1d700e18 placed dbsdrv.c@4959
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier
<error barrier> at 0x7ffd1d700e18 placed dbsdrv.c@4959
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier

*** 2024-10-16T14:00:54.142242+08:00
2024-10-16T14:00:54.141906+08:00
Incident 253556 created, dump file: /u01/app/oracle/diag/rdbms/oracle11g/oracle11g/incident/incdir_253556/oracle11g_ora_15589_i253556.trc
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier

kgefec: fatal error 1092

*** 2024-10-16T14:00:58.757459+08:00
USER(prelim) (ospid: 15589): terminating the instance due to ORA error 704

通过mos文档知道大致流程

原数据库的版本是11.2.0.4，现在目标数据库的版本是升级的19.0.0.0，需要对其进行使用并行升级实用程序catctl.pl来调用catupgrd.sql进行补充升级

SQL> startup mount

ORACLE instance started.

Total System Global Area 1593831936 bytes
Fixed Size 8897024 bytes
Variable Size 922746880 bytes
Database Buffers 654311424 bytes
Redo Buffers 7876608 bytes
Database mounted.
 

打开为upgrade模式

SQL> alter database open upgrade;

Database altered.

SQL> select status from v$instance;

STATUS
------------
OPEN MIGRATE

执行catupgrd.sql进行补充升级

su - ooracle

cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql

等待漫长的运行时间，将近五个小时

执行完毕后关闭数据库重新启动open，做升级后续操作

1.执行dbupgdiag.sql检查19C数据库情况

<