PL/SQL package SYS.DBMS_BACKUP_RESTORE version in TARGET database is not current
19c Patch 작업후에 rman 접속할 때 아래와 같은 메세지 발생할 때 조치!!
[gtexa1]oracle@gtexadb01:/home/oracle$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Mar 7 16:21:03 2024
Version 19.22.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.20.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.20.00.00 in TARGET database is not current
--------------------------------------------------------------------------------------------------------------------------------
PL/SQL package SYS.DBMS_BACKUP_RESTORE Version is Not Current (Doc ID 2741760.1)
- 해당 Package Compile 수행
@?/rdbms/admin/dbmsrman.sql
@?/rdbms/admin/dbmsbkrs.sql
@?/rdbms/admin/prvtrmns.plb
@?/rdbms/admin/prvtbkrs.plb
완료후 재접속 정상!!
[gtexa1]oracle@gtexadb01:/home/oracle$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Mar 7 16:59:45 2024
Version 19.22.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: GTEXA (DBID=2412954275)