如何恢复表空间

白鹭

hanvey,DUL不是Oracle的官方产品，是Oracle公司的一个荷兰员工开发的，如果是产品数据库，数据很重要的话，联系广州Oracle Support,他们有这个工具，北京Oracle Support据说没有DUL工具。

yanwang

The tablespace is already gone, I am thinking whether the following steps will work.

1.  Rename the datafiles with OS, such as from aaa.dbf to aaa1.dbf
2.  Create the tablespace with the same old name, such as aaa.dbf
3.  shutdown database, delete empty datafile aaa.dbf
4.  Rename aaa1.dbf to aaa.dbf
5.  startup database, do recovery, may need resetlogs.

Just thinking, never try.

白鹭

yanwang,当drop tablespace后，该tablespace里的对象已经从数据字典base table中删除了，简单的重命名是不能恢复的。

Cluster

荷兰员工?  Netherland.
I don't think DUL (Data Unloader) can help in this case.
the table or database objects information in the data dictionary, then
you can apply the DUL to unload the data out of the crashed database or segments.
But I suggest you create other instance, use recreate controlfile method to add on that
Datafile to the new database,  it was work for me two years ago.