rman的tablespace删除了怎么办?

comerliang

在OEM里把rman_ts表空间删除了,数据文件也删了

然后:
SQL> create tablespace rman_ts
  2  datafile '/u01/app/oracle/oradata/test/rman_ts.dbf' size 20m;

SQL> grant recovery_catalog_owner to rman;


[oracle@localhost ~]$ rman catalog rman/rman

Recovery Manager: Release 10.2.0.1.0 - Production on 星期二 12月 8 09:00:57 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog tablespace rman_ts;

ORACLE error from recovery catalog database: ORA-00955: name is already used by an existing object

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog


如何处理?

meilixueshan

先drop catalog处理一下

renxiao2003

重新处理创建一个。

htyro

貌似物理上删除了，逻辑上还存在，drop tablespace ....including contents and datafiles试试看。