The drop command has to be run twice to drop RMAN catalog, i.e. (replace RMANDB with the
database where you have RMAN schema installed):
rman catalog rman/rman@RMANDB
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Oct 7 13:55:42 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> drop catalog;
recovery catalog owner is RMAN
enter DROP CATALOG command again to confirm catalog removal
RMAN> drop catalog;
recovery catalog dropped
|