oracle补丁升级回退方案

<h2>简介：</h2> <p>数据库在做变更或者升级时，需要考虑回退方案，接下来介绍如何回退数据库补丁</p> <h2>准备工作：</h2> <ul> <li>备份数据库</li> <li>关闭数据库监听、数据库服务</li> <li>查看数据库已升级补丁情况</li> </ul> <h3>备份数据库</h3> <h3>关闭数据库监听、数据库服务</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/2cc2b9d4c2d7191d3839262d2b34e5ef" alt="" /></p> <h3>查看数据库已升级补丁情况</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/e131f0e21f5760e19f4a82f35e7f4c61" alt="" /> <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/e23e8cc579ea6b740a6e2b716b2cf180" alt="" /></p> <h2>回退补丁</h2> <p>%ORACLE_HOME%/OPatch/opatch rollback -id 31659823 id后面代表你之前升级补丁包的补丁集id <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/edd349f248edbdb025d954656ac0e797" alt="" /> <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/135d39f43c3ac178de66a7998d60148e" alt="" /> <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/a4377aa0af490cc350635c8bcf6b61f1" alt="" /> 回退过程比较耗时，需耐心等待</p> <h2>检查回退情况</h2> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/9f94a88e4d917b16521145edf5574a0f" alt="" /> <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/a4881255c6ccc409ae36c390ab72c232" alt="" /> 可以看到，补丁已经被卸载了</p> <h2>启动监听、数据库服务</h2> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/5a83dcb1e2dfa10dec3202df95a84869" alt="" /> 补丁回退就结束了</p> <h2>测试应用系统、数据库是否正常</h2>