DROP CATALOG

Syntax

dropCatalog::=

Description of dropcatalog.gif follows
Description of the illustration dropcatalog.gif

Purpose

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

Restrictions and Usage Notes

  • 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.

Example

Deleting the Catalog: Example This example drops the schema from the recovery catalog (you must enter the command twice to confirm):

RMAN> DROP CATALOG

recovery catalog owner is RMAN
enter DROP CATALOG command again to confirm catalog removal
RMAN> DROP CATALOG