Chinaunix

标题: rman的tablespace删除了怎么办? [打印本页]

作者: comerliang 时间: 2009-12-08 09:17
标题: rman的tablespace删除了怎么办?
在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 时间: 2009-12-08 10:08
先drop catalog处理一下

作者: renxiao2003 时间: 2009-12-08 12:53
重新处理创建一个。

作者: htyro 时间: 2009-12-09 23:03
貌似物理上删除了，逻辑上还存在，drop tablespace ....including contents and datafiles试试看。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)