Using the RMAN Recovery Catalog - OCP: Oracle Database 12c Administrator Certified Professional - page 183

RMAN>Revoke register database from rcat_002;
Finally, you can drop the RVPC with the DROP CATALOG command, as shown in this
example:
RMAN>connect catalog rcat_001/rcat001@rcat;
RMAN> drop catalog;
RMAN> drop catalog;
recovery catalog owner is RVPC
enter DROP CATALOG command again to confirm catalog removal
RMAN> drop catalog;
virtual catalog dropped]
After using the DROP CATALOG command, it's safe to drop the RVPC catalog user with
the DROP USER SQL command:
SQL> drop user rcat_001;
Summary
The recovery catalog is an optional but very powerful tool in your RMAN arsenal. It
can make your life as a DBA easier by providing a centralized repository for all your
RMAN-related data. The recovery catalog is easy to create and maintain. Oracle's new
virtual private catalog features make the recovery catalog even more powerful, increas-
ing the security within the catalog.
Exam Essentials
Identify situations that will require the RMAN recovery catalog. Understand that the
recovery catalog is largely optional. A recovery catalog will be needed for storing scripts,
and it will be required if you want to store backup records longer than one year or beyond
the setting of CONTROL_FILE_RECORD_KEEP_TIME .