RMAN Commands , 26 of 59

DROP CATALOG

Syntax

Text description of the illustration dropCatalog.gif

Purpose

To remove the schema from the recovery catalog.

Caution:

This command deletes all metadata 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:

Oracle9i Recovery Manager 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