To remove the schema from the recovery catalog.
Caution:This command deletes all RMAN repository data from the recovery catalog. If you have no backups of the catalog, then all backups of all databases managed by this recovery catalog become unusable.
See Also:Oracle Database Backup and Recovery Advanced User's Guide to learn how to drop the recovery catalog schema
Execute this command only at the RMAN prompt.
You must be connected to the recovery catalog database through the
CATALOG command-line option or the CONNECT
CATALOG command. The catalog database must be open. You do not have to be connected to the target database.
Enter the command twice to confirm that you want to drop the schema.
RMAN> DROP CATALOG recovery catalog owner is RMAN enter DROP CATALOG command again to confirm catalog removal RMAN> DROP CATALOG