Tuesday, June 14, 2022

PL/SQL package DBNAME.DBMS_RCVCAT version 19.06.00.00. in RCVCAT database is not current

 
 
 
When trying to connect to catalog database from rman I am getting below error
 
 
HOSTNAME:dbname:/home/oracle $ rman target /
 
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 14 11:50:16 2022
Version 19.9.0.0.0
 
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: DBNAME (DBID=3401445687)
 
 
RMAN> connect catalog user/pass@catalogdb
 
connected to recovery catalog database
PL/SQL package DBNAME_EXA_RMAN.DBMS_RCVCAT version 19.06.00.00. in RCVCAT database is not current
PL/SQL package DBNAME_EXA_RMAN.DBMS_RCVMAN version 19.06.00.00 in RCVCAT database is not current
 
 

Reason :

 There is a version mismatch between the RMAN-executable and the RMAN-catalog SCHEMA


Solution :
 
HOSTNAME:dbname:/home/oracle $ rman target /
 
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 14 11:50:16 2022
Version 19.9.0.0.0
 
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: DBNAME (DBID=3401445687)
 
 
RMAN> connect catalog user/pass@catalogdb
 
connected to recovery catalog database
PL/SQL package DBNAME_EXA_RMAN.DBMS_RCVCAT version 19.06.00.00. in RCVCAT database is not current
PL/SQL package DBNAME_EXA_RMAN.DBMS_RCVMAN version 19.06.00.00 in RCVCAT database is not current
 
RMAN>
 
RMAN> upgrade catalog;
 
recovery catalog owner is DBNAME_EXA_RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
 
-- give same command again
 
RMAN> upgrade catalog;
 
recovery catalog upgraded to version 19.09.00.00.00
DBMS_RCVMAN package upgraded to version 19.09.00.00
DBMS_RCVCAT package upgraded to version 19.09.00.00.
 
RMAN> exit
 
 
Refer:
 
Pl/Sql Package Rman.Dbms_rcvcat Version xxxxx In Rcvcat Database Is Not Current (Doc ID 1365435.1)

0 comments:

Post a Comment

Auto Scroll Stop Scroll