Trying to learn about managing rman Virtual Private Catalog, following the 18c Backup and Recovery User's Guide. Starting at section 13.5, "Creating and Managing Virtual Private Catalogs".
The first step is to run dbmsrmanvpc.sql, " after upgrading the base catalog schema" Here, my base catalog schema is 'rman' (yeah, not a real good name. My predecessor created it and I've never bothered to create something better). So, executing that script:
oracle:rmcatvb$ rman catalog rman/pswd
Recovery Manager: Release 18.0.0.0.0 - Production on Tue Sep 22 11:18:30 2020
Version 18.8.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> upgrade catalog
recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog
recovery catalog upgraded to version 18.08.00.00.00
DBMS_RCVMAN package upgraded to version 18.08.00.00
DBMS_RCVCAT package upgraded to version 18.08.00.00.
RMAN>exit
oracle:rmcatvb$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Sep 22 11:22:06 2020
Version 18.8.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.8.0.0.0
SQL> @?/rdbms/admin/dbmsrmanvpc.sql -vpd rman
Checking the operating user... Passed
Granting VPD privileges to the owner of the base catalog schema RMAN
========================================
VPD SETUP STATUS:
VPD privileges granted successfully!
Connect to RMAN base catalog and perform UPGRADE CATALOG.
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.8.0.0.0
The script tells me to upgrade the catalog – again! Oh well.
oracle:rmcatvb$ rman catalog rman/pswd
Recovery Manager: Release 18.0.0.0.0 - Production on Tue Sep 22 11:24:41 2020
Version 18.8.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> upgrade catalog
recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog
recovery catalog upgraded to version 18.08.00.00.00
DBMS_RCVMAN package upgraded to version 18.08.00.00
DBMS_RCVCAT package upgraded to version 18.08.00.00.
RMAN> exit
The next step is to create the VPC user, giving it unlimited quota on its default TS, and grant it CREATE SESSION. I actually granted it DBA. VPC owner is 'localdba'.
After creating the VPC owner, the next step is to connect to the catalog as the catalog owner and grant privs to the VPC owner:
oracle:rmcatvb$ rman
Recovery Manager: Release 18.0.0.0.0 - Production on Tue Sep 22 11:38:26 2020
Version 18.8.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
RMAN> connect catalog rman/pswd
connected to recovery catalog database
RMAN> grant catalog for database mydb to localdba;
Grant succeeded.
RMAN> grant register database to localdba;
Grant succeeded
Next step is to start RMAN and connect to the recovery catalog database as the virtual private catalog owner (not the base recovery catalog owner). Connect to the database that you want to register as TARGET
oracle:mydb$ rman
Recovery Manager: Release 18.0.0.0.0 - Production on Tue Sep 22 11:48:05 2020
Version 18.8.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /
connected to target database: MYDB (DBID=170785252)
RMAN> connect catalog localdba/pswd@rmcat
connected to recovery catalog database
RMAN-07540: Cleanup is required for the VPC user schema
RMAN>
Looking up the error on MOS, it says to run dbmsrmanvpc (again ?!?!) , this time on the vpc owner – localdba
oracle:rmcatvb$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Sep 22 11:55:40 2020
Version 18.8.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.8.0.0.0
SQL> @?/rdbms/admin/dbmsrmanvpc.sql -vpd localdba
Checking the operating user... Passed
Granting VPD privileges to the owner of the base catalog schema LOCALDBA
========================================
No eligible RMAN catalogs have been found!
So, now I'm at a dead-end. I strongly suspect this is yet another "disconnect" in the docs. Whatever, I'm failing to see it.