Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
|
|
View PDF |
Syntax
dropCatalog::=
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 schemaRestrictions 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