Oracle 19c Database RMAN error, post patching upgrade catalog failed with RMAN-00571, RMAN-00569, RMAN-06004, ORA-20153
Error Details:
RMAN> upgrade catalog;
upgrade catalog;
recovery catalog owner is PRODEBS_RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog;
upgrade catalog;
error creating dbmsunsetvpc_sql
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: Oracle error from recovery catalog database: ORA-20153: Unable to drop the VPD protection policies!
This recovery catalog does not have VPD support enabled! Exit this RMAN session.
Execute '?/rdbms/admin/dbmsrmanvpc.sql -vpd PRODEBS_RMAN' after connecting
to a catalog database as SYS. Then perform the UPGRADE catalog.
RMAN Client Diagnostic Trace file : /prodebs/diag/clients/user_crmuat/RMAN_180761528_110/trace/ora_rman_18118_0.trc
RMAN>
Fix:
First you need to connect to RMAN catalog database and run below steps and then come back to your 19c database instance and try "upgrade catalog" again:
rmancatalogdatabase$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 13 09:41:44 2026
Version 19.32.0.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.32.0.0.0
SQL>
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
RMAN_CATALOG.database
SQL> @?/rdbms/admin/dbmsrmanvpc.sql -vpd PRODEBS_RMAN
Checking the operating user... Passed
Granting VPD privileges to the owner of the base catalog schema PRODEBS_RMAN
========================================
VPD SETUP STATUS:
VPD privileges granted successfully!
Connect to RMAN base catalog and perform UPGRADE CATALOG.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.32.0.0.0
Connect to 19c Database instance and run upgrade catalog:
prodebs19cdb $ rman target / catalog PRODEBS_RMAN/password@rmancatalogdb;
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Aug 13 09:44:45 2026
Version 19.32.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CRMUATC (DBID=914028276)
connected to recovery catalog database
PL/SQL package PRODEBS_RMAN.DBMS_RCVCAT version 19.20.00.00. in RCVCAT database is not current
PL/SQL package PRODEBS_RMAN.DBMS_RCVMAN version 19.20.00.00 in RCVCAT database is not current
RMAN> upgrade catalog;
upgrade catalog;
recovery catalog owner is PRODEBS_RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog;
upgrade catalog;
recovery catalog upgraded to version 19.32.00.00.00
DBMS_RCVMAN package upgraded to version 19.32.00.00
DBMS_RCVCAT package upgraded to version 19.32.00.00.
RMAN>
0 Comments