How to solve of ORA-04063 and RMAN-06429 IN 19C
--导读:19.9的rac在执行rman target /时报错,提示"SYS.DBMS_RCVMAN"有错误,这样的报错一般是因为升级后导致一些body失效导致,我们可用采取重建的方式解决。
--版本
[oracle@rac1:/u01/app/oracle/product/19.0.0/db_1/OPatch]$./opatch lspatches 31771877;Database Release Update : 19.9.0.0.201020 (31771877) 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) OPatch succeeded.
--问题
[oracle@rac1:/home/oracle]$rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Sun Jul 10 21:47:59 2022 Version 19.9.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Oracle error from target database: ORA-04063: package body "SYS.DBMS_RCVMAN" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_RCVMAN" error executing package DBMS_RCVMAN in TARGET database RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-06429: TARGET database is not compatible with this version of RMAN
--参考
Connect to target in RMAN fails with RMAN-03010 RMAN-10015 (Doc ID 1592098.1) - Recompile the rman packages and procedures: Recreate DBMS_RCVMAN: @$ORACLE_HOME/rdbms/admin/dbmsrman.sql @$ORACLE_HOME/rdbms/admin/prvtrmns.plb Recreate DBMS_BACKUP_RESTORE @$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql @$ORACLE_HOME/rdbms/admin/prvtbkrs.plb
--解决办法
SQL> @?/rdbms/admin/dbmsrman.sql SQL> @?/rdbms/admin/prvtrmns.plb
--反思
以后遇到package body的错误,均可采用重建的方式进行。然后通过mos确定可行性。