oracle12c到19c adg搭建（五）dg搭建后进行切换19c进行数据字典升级_oracle12升级到19

一、备库切主库升级

12c切换为19c主库的时候是由低版本到高版本所以cdb和pdb的数据字典需要进行升级才可以让数据与软件版本兼容。

1.1切换

SQL> alter database recover managed standby database finish;

Database altered.

SQL> alter database commit to switchover to primary;

Database altered.

1.2升级cdb

SQL>

 SQL> shu immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup upgrade;

ORACLE instance started.

Total System Global Area 6174013840 bytes

Fixed Size                  9148816 bytes

Variable Size            1056964608 bytes

Database Buffers         5100273664 bytes

Redo Buffers                7626752 bytes

Database mounted.

Database opened.

SQL>

[oracle@o12u19s backup]$ cd $ORACLE_HOME/bin

[oracle@o12u19s bin]$ ./dbupgrade

跑了1小时9分58秒

1.3编译失效对象

[oracle@o12u19s bin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 18 19:44:49 2024

Ve