Hello Friend's,
In this post will see steps to upgrade Rman catalog after 19c upgrade and some issue related to upgrade.
So lets get started .
Step 1 : Will check the error in upgrading the catalog.
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: FINDB (DBID=2239803282, not open)
connected to recovery catalog database
PL/SQL package RCATALOG.DBMS_RCVCAT version 19.07.00.00. in RCVCAT database is not current
PL/SQL package RCATALOG.DBMS_RCVMAN version 19.07.00.00 in RCVCAT database is not current
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-07539: INSUFFICIENT PRIVILEGES TO UPGRADE THE CATALOG SCHEMA
SOLUTION:
connect to Recovery Catalog Database, and grant recovery catalog user the following permissions :
SQL> grant CREATE ANY CONTEXT to catalog_user;
SQL> grant drop ANY CONTEXT to catalog_user;
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL> @?/rdbms/admin/dbmsrmansys.sql
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
PL/SQL procedure successfully completed.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
Start with the Upgrade of catalog , Connect the Rman with the catalog option and do the below steps.
RMAN> upgrade catalog;
recovery catalog owner is RCATALOG
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog;
recovery catalog upgraded to version 19.10.00.00.00
DBMS_RCVMAN package upgraded to version 19.10.00.00
DBMS_RCVCAT package upgraded to version 19.10.00.00.
ConversionConversion EmoticonEmoticon