PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current
安装完19.3后,然后打完补丁35042068(19.19),使用rman有如下的提示报错误:
[oracle@slnngk ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Apr 25 20:39:46 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 in TARGET database is not current
connected to target database: SLNNGK (DBID=3553282077)
解决办法:
connect / as sysdba
@$ORACLE_HOME/rdbms/admin/dbmsrman.sql
@$ORACLE_HOME/rdbms/admin/prvtrmns.plb
@$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
@$ORACLE_HOME/rdbms/admin/prvtbkrs.plb
rman重新登录
[oracle@slnngk ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Apr 25 20:42:41 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SLNNGK (DBID=3553282077)