使用 rhpctl move database 切换回以前版本
发布时间：2021-08-22
[oracle@otherdb ~]$ /u01/app/oracle/product/19.9.0/db_1/bin/rhpctl move database -sid orcl2 \
> -sourcehome /u01/app/oracle/product/19.10.0/db_1 \
> -desthome /u01/app/oracle/product/19.9.0/db_1 \
> -stopoption IMMEDIATE -ignorewcpatches
otherdb: verifying versions of Oracle homes ...
otherdb: verifying owners of Oracle homes ...
otherdb: verifying groups of Oracle homes ...
otherdb: starting to move the following databases: "orcl2"
otherdb: restarting databases: "orcl2" ...
otherdb: SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 5 22:56:44 2021Version 19.10.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.10.0.0.0
SQL> alter pluggable database all save state*ERROR at line 1:ORA-65090: operation only allowed in a container database
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.10.0.0.0 :successful
otherdb: stopping instances of databases "orcl2" ...
otherdb: SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 5 22:56:44 2021Version 19.10.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.10.0.0.0
SQL> Database closed.Database dismounted.ORACLE instance shut down.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.10.0.0.0 :successful
otherdb: trying datapatch run for orcl2, attempt### 1 ###
[oracle@otherdb ~]$
成功。
注意，一定不要忘了 -ignorewcpatches，否则，会报找不到补丁的错误。
PRGO-1691 : The move operation was rejected because the patched working copy "DEST_HOME_PATH_WC-1606998673" is missing the patches for bug numbers
> -sourcehome /u01/app/oracle/product/19.10.0/db_1 \
> -desthome /u01/app/oracle/product/19.9.0/db_1 \
> -stopoption IMMEDIATE -ignorewcpatches
otherdb: verifying versions of Oracle homes ...
otherdb: verifying owners of Oracle homes ...
otherdb: verifying groups of Oracle homes ...
otherdb: starting to move the following databases: "orcl2"
otherdb: restarting databases: "orcl2" ...
otherdb: SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 5 22:56:44 2021Version 19.10.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.10.0.0.0
SQL> alter pluggable database all save state*ERROR at line 1:ORA-65090: operation only allowed in a container database
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.10.0.0.0 :successful
otherdb: stopping instances of databases "orcl2" ...
otherdb: SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 5 22:56:44 2021Version 19.10.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.10.0.0.0
SQL> Database closed.Database dismounted.ORACLE instance shut down.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.10.0.0.0 :successful
otherdb: trying datapatch run for orcl2, attempt### 1 ###
[oracle@otherdb ~]$
成功。
注意，一定不要忘了 -ignorewcpatches，否则，会报找不到补丁的错误。
PRGO-1691 : The move operation was rejected because the patched working copy "DEST_HOME_PATH_WC-1606998673" is missing the patches for bug numbers
