删除数据文件oracle,oracle误用操作系统命令删除数据文件的恢复方法

事故原因:

1.由于误操作用hp unix 命令 rm -f datafilename 删除表空间的数据文件

2.alter tablespace tablespacenaem drop datafile datafile ;

3.drop tablespace tablespacename including content and datafiles;

上述两个步骤我用了近三个小时都没有执行完，最后导致数据库宕机。下面把我当时启动数据的后台页面展现给大家，为以后出现同样的问题，提供一个参照的作用.

SP2-0734: unknown command beginning "sqlplus /n..." - rest of line ignored.

SQL> conn sys/passwd as sysdba;

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 3.2212E+10 bytes

Fixed Size                  2115136 bytes

Variable Size            3204450752 bytes

Database Buffers         2.8991E+10 bytes

Redo Buffers               14659584 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 39 - see DBWR trace file

ORA-01110: data file 39: '/data/tbs_db_bas2.dbf'

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 3.2212E+10 bytes

Fixed Size                  2115136 bytes

Variable Size            3204450752 bytes

Database Buffers         2.8991E+10 bytes

Redo Buffers               14659584 bytes

Database mounted.

SQL> recover datafile tbs_db_bas2.dbf;

ORA-02236: invalid file name

SQL> recover datafile '/data/tbs_db_bas2.dbf';

ORA-00283: recovery session canceled due to errors

ORA-01110: data file 39: '/data/t