重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 2298|回复: 3
打印 上一主题 下一主题

使用rhpctl move database 从高版本移动到低版本失败

[复制链接]
跳转到指定楼层
楼主
发表于 2021-4-5 22:22:31 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
[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
otherdb: verifying versions of Oracle homes ...
otherdb: verifying owners of Oracle homes ...
otherdb: verifying groups of Oracle homes ...
PRCG-1238 : failed to execute the Rapid Home Provisioning action for command 'move database'
PRGO-1691 : The move operation was rejected because the patched working copy "DEST_HOME_PATH_WC-1606998673" is missing the patches for bug numbers "26305045,28677941,28961306,29062169,29214935,29273690,29311884,29326865,29383352,29410215,29476870,29517825,29580769,29739311,29774011,29786909,29837622,29839491,29846228,29868857,29892960,29916357,29921907,29922214,29963691,30019681,30041206,30041449,30084746,30208669,30213406,30248128,30271965,30295481,30334608,30386318,30437043,30459504,30490575,30513007,30513500,30536579,30536831,30539011,30642847,30654186,30713448,30729744,30729963,30757495,30776140,30797842,30804716,30821154,30833909,30839975,30862339,30866727,30869943,30869952,30870843,30871601,30921995,30932867,30942927,30959735,31021750,31036365,31057336,31062167,31070231,31105578,31128452,31132515,31136241,31144248,31152741,31162995,31167566,31170705,31185877,31190347,31215354,31215465,31234260,31236358,31239791,31240849,31245469,31249821,31264160,31268377,31284440,31295991,31335355,31347162,31352245,31376095,31381403,31387322,31389598,31396227,31400353,31402036,31410517,31418685,31419690,31420488,31448087,31454822,31467424,31469099,31477893,31488316,31493961,31494121,31505672,31512222,31513130,31535792,31536584,31538597,31541335,31548159,31560944,31571712,31572761,31581504,31582073,31585952,31587709,31588830,31602792,31607561,31613535,31615178,31621560,31623529,31627854,31633643,31637251,31637944,31643935,31644757,31644786,31657416,31664039,31668967,31673723,31685476,31691947,31693766,31697356,31698938,31699081,31702089,31707454,31717344,31722457,31742512,31748711,31751387,31752814,31753874,31756012,31765043,31772216,31775359,31775363,31777242,31778138,31779513,31794046,31795055,31825446,31825584,31835699,31837685,31837842,31837923,31839233,31848063,31849609,31856488,31857840,31864173,31887422,31900921,31901236,31935022,31943944,31987354,31992593,32069815,32137544,32178524,31625618,32321765,16664572,19138896,20867658,21232786,21528318,21629064,24957575,25607406,25792962,26127355,26173091,27004828,27130348,27195575,27362994,27622946,27661222,27684864,27742354,27829722,27998559,28007516,28127569,28133903,28145995,28187837,28338211,28370061,28403019,28625580,28630381,28640772,28698087,28700945,28751498,28755084,28763291,28785273,28806517,28816871,28818063,28837979,28872829,28897123,28957260,28985114,28985272,28985362,28999046,29020423,29024028,29030184,29030927,29053902,29146077,29148799,29199163,29203041,29217856,29247183,29255705,29273168,29281112,29286220,29302565,29302614,29305093,29321689,29326233,29329848,29340333,29396481,29397841,29415493,29418341,29431402,29437029,29442400,29450273,29451085,29458132,29471857,29487407,29491784,29495171,29505225,29505589,29518604,29518767,29532112,29536794,29539413,29550530,29558926,29587720,29591641,29597716,29599243,29599552,29614931,29628647,29642451,29649694,29666451,29670713,29680700,29695987,29697928,29706160,29708324,29718198,29720373,29737941,29744637,29748325,29764644,29765219,29765347,29765493,29772514,29772761,29783142,29785831,29796916,29801164,29806964,29811616,29814995,29816887,29820341,29829339,29838740,29842369,29846525,29856420,29856890,29858420,29860022,29869052,29870533,29875200,29894021,29901961,29910218,29912135,29931956,29932310,29934048,29947428,29952700,29961360,29970261,29970587,29972134,29990779,30001105,30004660,30004856,30007536,30014200,30021830,30026596,30027649,30028182,30032233,30032484,30045273,30068792,30072018,30073422,30080111,30087165,30087509,30088229,30094929,30102774,30104348,30106901,30108012,30122523,30123138,30126470,30137792,30147195,30147307,30148929,30155489,30155999,30156569,30157526,30158313,30173370,30175587,30179038,30183367,30187627,30189535,30192729,30192853,30193262,30193506,30193584,30198239,30208690,30209222,30210429,30210753,30214769,30214826,30222669,30222975,30224544,30224725,30233934,30234132,30234227,30236964,30240858,30240972,30248531,30259120,30259469,30276144,30277887,30278402,30282918,30285026,30285166,30285251,30292305,30294465,30300523,30313749,30317397,30321076,30321398,30324466,30327810,30329751,30336383,30336530,30336996,30337245,30338591,30345926,30350177,30352532,30357698,30358416,30359614,30361635,30363311,30364481,30368917,30377692,30380907,30382646,30387628,30388853,30389821,30390635,30392870,30396120,30403412,30404639,30409472,30412772,30421026,30436399,30437003,30439985,30440651,30441277,30446820,30447994,30460095,30461123,30486896,30489582,30492380,30494259,30494900,30505029,30508100,30512690,30513480,30517635,30518349,30524736,30528687,30529790,30530585,30536237,30537584,30549368,30556326,30558561,30561404,30564898,30565004,30565595,30566054,30567372,30571306,30591475,30593104,30593863,30594167,30595408,30596694,30605676,30608583,30610406,30616406,30616738,30619138,30619728,30622755,30624243,30624874,30628834,30629139,30634548,30641541,30644530,30644766,30645896,30651570,30657196,30657566,30657906,30657940,30659940,30661000,30665399,30670328,30671958,30677633,30681521,30684902,30686017,30689557,30693791,30705448,30712670,30713133,30719327,30727759,30739876,30748707,30750219,30751527,30751639,30753432,30758836,30758854,30761871,30764405,30765995,30767277,30768636,30782266,30782300,30783395,30786237,30786641,30788973,30804646,30806757,30806984,30807888,30809087,30810765,30815495,30819340,30819629,30830555,30834068,30835184,30836129,30839451,30839836,30841241,30842277,30843271,30846063,30846782,30847871,30848028,30851448,30852954,30858877,30860803,30863115,30864607,30874270,30874337,30874660,30879169,30879708,30883715,30889607,30891760,30891792,30895426,30896685,30898381,30898748,30898939,30902655,30909596,30915781,30919587,30921136,30923514,30925316,30930149,30931311,30931981,30932674,30936251,30936942,30937391,30938413,30939317,30940869,30946768,30956571,30956647,30960356,30960736,30965554,30972817,30972947,30972951,30972959,30973085,30973127,30973197,30973877,30974813,30977411,30980115,30985906,30988444,30992330,30993518,30998035,30998662,31001490,31002223,31002923,31003137,31006792,31009545,31009590,31010218,31011361,31014323,31021068,31025520,31025531,31026591,31026860,31027747,31030898,31035287,31037421,31038447,31043630,31044145,31044951,31045929,31046188,31046619,31047022,31047169,31048025,31048741,31049215,31051056,31052735,31052809,31055142,31058548,31063380,31063769,31064025,31065838,31066082,31069059,31073586,31074032,31075323,31075960,31078391,31078757,31081558,31087361,31087679,31088115,31088341,31089270,31090262,31091868,31092233,31092581,31092921,31094183,31094228,31096846,31097961,31101386,31106140,31107577,31112530,31112972,31114265,31114671,31115201,31119846,31120361,31122876,31124363,31125773,31126053,31126058,31127043,31127457,31127969,31130156,31132732,31138106,31139643,31142749,31145403,31145804,31158341,31158380,31159382,31162711,31162915,31165038,31165577,31165722,31168440,31171096,31171631,31172642,31175365,31177204,31177221,31181380,31182756,31185224,31188398,31190624,31193292,31195090,31195430,31195838,31201366,31204412,31204878,31213034,31215422,31216995,31218837,31219047,31220549,31220881,31226448,31230775,31233170,31234790,31235797,31240626,31244968,31249008,31249696,31254929,31255369,31255869,31257740,31258995,31260692,31261641,31265651,31268557,31270711,31271032,31287871,31289115,31290300,31293484,31298871,31303032,31304573,31305114,31306867,31306927,31309379,31310564,31310624,31311830,31312450,31313117,31313444,31314885,31315495,31316250,31322720,31326977,31326998,31327259,31327278,31327349,31327391,31327896,31331372,31333156,31334961,31336298,31338769,31339457,31339643,31339744,31343110,31344046,31348711,31350348,31353610,31356601,31357581,31357737,31358308,31359366,31360146,31360323,31360469,31360529,31366716,31367188,31367364,31369444,31372498,31373825,31373837,31373843,31376708,31377129,31377487,31377808,31380443,31381701,31383464,31383814,31387426,31388288,31390936,31391991,31394341,31394347,31395247,31396027,31396695,31398663,31399131,31402078,31403177,31403565,31404014,31404130,31404263,31408636,31409483,31411163,31421316,31422620,31424838,31425167,31425761,31429501,31429590,31433579,31434805,31434870,31437030,31440426,31440813,31442332,31442714,31444353,31444516,31446431,31447733,31448680,31449354,31450392,31450653,31454972,31458049,31466433,31468060,31476093,31476736,31477695,31479272,31479772,31483949,31484385,31484603,31485386,31485507,31487441,31487491,31489137,31490604,31491634,31493840,31494264,31496174,31498559,31499370,31499700,31501139,31503349,31507107,31508712,31510891,31512044,31525783,31526903,31527199,31528962,31533274,31533817,31533833,31535955,31536401,31539566,31541864,31545477,31546864,31547220,31548675,31549221,31553674,31553813,31555539,31557663,31559085,31560592,31561886,31567124,31567441,31570054,31572006,31572267,31574244,31574267,31576738,31577569,31578994,31581627,31585351,31585789,31586381,31591421,31595632,31597727,31600894,31601385,31603199,31605119,31607937,31616104,31620748,31625579,31626572,31627587,31628311,31630551,31633224,31637607,31637680,31640240,31644775,31648120,31649819,31650202,31652641,31653080,31655807,31658943,31661865,31663189,31663788,31668694,31670014,31670353,31674380,31675568,31676941,31677460,31682766,31684494,31686979,31688978,31691030,31695062,31696577,31697741,31700234,31701910,31706595,31707190,31708133,31709647,31709739,31709777,31711889,31711997,31715935,31721863,31721880,31722646,31723651,31727560,31728160,31734583,31735662,31743771,31747935,31748000,31748944,31752502,31753202,31753425,31753692,31754887,31755245,31756415,31757357,31757775,31757824,31758083,31760592,31763707,31764866,31765257,31765296,31766696,31767237,31769373,31770289,31771370,31771410,31771468,31775101,31776994,31783451,31783782,31785445,31786838,31787655,31788704,31788761,31790500,31792465,31793713,31796882,31798742,31800757,31807516,31815099,31816158,31816631,31820632,31823051,31827605,31827912,31829617,31829639,31833948,31835854,31836454,31839779,31842545,31843462,31847489,31849859,31851383,31852574,31854692,31855526,31860193,31862359,31863118,31866141,31869601,31871692,31872230,31878314,31880154,31881527,31883124,31886695,31887130,31888731,31889222,31895670,31897854,31900585,31903523,31904933,31907137,31907565,31909295,31913650,31921267,31927930,31942144,31943497,31952052,31953989,31958958,31961940,31965542,31974597,31974693,31986836,31988079,31991705,31996264,32002411,32003551,32005048,32007698,32008586,32010707,32017301,32032887,32048412,32050048,32057639,32061648,32069834,32079739,32082098,32089820,32097882,32101305,32113113,32118727,32121326,32129659,32130083,32130504,32150818,32169151,32172777,32174571,32207088,32212635,32221141,32234161,32290399,32296941,32165759,32069696,32032733,30889443,30674373" which are present in the source Oracle home "/u01/app/oracle/product/19.10.0/db_1".

分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

沙发
 楼主| 发表于 2021-4-5 23:30:41 | 只看该作者
加一个  -ignorewcpatches 选项,即可回退到以前版本HOME.

[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 ###
回复 支持 反对

使用道具 举报

板凳
 楼主| 发表于 2021-4-5 23:31:22 | 只看该作者
SQL> select ACTION,STATUS,SOURCE_VERSION,TARGET_VERSION,TARGET_BUILD_DESCRIPTION from dba_registry_sqlpatch;

ACTION          STATUS                    SOURCE_VERSION  TARGET_VERSION
--------------- ------------------------- --------------- ---------------
TARGET_BUILD_DESCRIPTION
--------------------------------------------------------------------------------
APPLY           SUCCESS                   19.1.0.0.0      19.1.0.0.0
Feature Release

APPLY           SUCCESS                   19.1.0.0.0      19.9.0.0.0
Release_Update

ROLLBACK        SUCCESS                   19.10.0.0.0     19.10.0.0.0
Release_Update


ACTION          STATUS                    SOURCE_VERSION  TARGET_VERSION
--------------- ------------------------- --------------- ---------------
TARGET_BUILD_DESCRIPTION
--------------------------------------------------------------------------------
APPLY           SUCCESS                   19.9.0.0.0      19.9.0.0.0
Release_Update

APPLY           WITH ERRORS               19.9.0.0.0      19.10.0.0.0
Release_Update

APPLY           SUCCESS                   19.9.0.0.0      19.10.0.0.0
Release_Update


ACTION          STATUS                    SOURCE_VERSION  TARGET_VERSION
--------------- ------------------------- --------------- ---------------
TARGET_BUILD_DESCRIPTION
--------------------------------------------------------------------------------
ROLLBACK        SUCCESS                   19.9.0.0.0      19.9.0.0.0
Release_Update

APPLY           SUCCESS                   19.10.0.0.0     19.10.0.0.0
Release_Update

ROLLBACK        SUCCESS                   19.10.0.0.0     19.9.0.0.0
Release_Update


9 rows selected.
回复 支持 反对

使用道具 举报

地板
 楼主| 发表于 2021-4-5 23:32:07 | 只看该作者
发现datapatch 也从 19.10.0,后退到 19.9.0
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-28 13:34 , Processed in 0.088948 second(s), 18 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表