使用 rhpctl move database 切换回以前版本

[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

使用 rhpctl move database 切换回以前版本

上一篇:ORA-10456: cannot open standby database; media recovery session may be in progress


下一篇:SQL Server数据库后面多了“可疑”两个字解决方法