Oracle Database Discussions

HI,

database: 10.2.0.4.0
OS: AIX

SQL> startup mount exclusive;
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size 2084336 bytes
Variable Size 385876496 bytes
Database Buffers 1174405120 bytes
Redo Buffers 48246784 bytes
Database mounted.
SQL> alter system enable restricted session;
sql> exit

rman target / catalog rman@rmancatalog


RMAN> drop database including backups;

starting full resync of recovery catalog
full resync complete
database name is "xxxx" and DBID is xxxxx

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of drop db & bck command at 09/28/2012 15:40:12
RMAN-06941: Database must be closed and mounted EXCLUSIVE and RESTRICTED.

RMAN> sql 'alter system enable restricted session';


sql statement: alter system enable restricted session

RMAN>
RMAN> drop database including backups;

database name is "xxxxx" and DBID is xxxxx

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of drop db & bck command at 09/28/2012 15:41:37
RMAN-06941: Database must be closed and mounted EXCLUSIVE and RESTRICTED.


what is wrong?


thank you

Edited by: 951932 on Sep 28, 2012 1:49 PM