----删除前最好rman冷备份一次,controlfile要单独备份 alter database backup controlfile to '/oradata/controlfile.bak'; 如果不备份控制文件也可以在备份的ramn恢复控制文件,下面是我做的实验:
1、第一种恢复方法SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
ECOLOGY
SQL> drop tablespace ecology including contents and datafiles;
SQL>shutdown immediate;
SQL>startup nomount;
RMAN>restore controlfile from '/oradata/controlfile.bak'; (控制文件需要在nomount状态下转储)
RMAN>alter database mount;
RMAN>report schema;
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -----