Recovery after data files are lost

Recovery | Data sql> Startup
ORACLE instance started.

Total System Global area 73109664 bytes
Fixed Size 73888 bytes
Variable Size 56086528 bytes
Database buffers 16777216 bytes
Redo buffers 172032 bytes
Database mounted.
Ora-03113:end-of-file on communication channel



My environment is linux9 Oracle 8.1.7.4
The problem was when a machine connected to the insert into operation, the data is about 630,000.
In the process of executing because to the time of work, the server sets the timer automatic shutdown function, the server
Shut down at 5:30, cause insert into operation interrupt, wait for server up, hint a table data file has problem, I executed
Shutdown immediate
Startup Mount
Recover datafile '/datafile.dbf '
Prompt for successful recovery
Startup
The above error message appears

Finally done, take the steps to put, the affected table space what data file drop off
Sql> Startup
ORACLE instance started.

Total System Global area 73109664 bytes
Fixed Size 73888 bytes
Variable Size 56086528 bytes
Database buffers 16777216 bytes
Redo buffers 172032 bytes
Database mounted.
Ora-03113:end-of-file on communication channel


Sql> Conn System/manager as Sysdba
Connected.
Sql> select name from Datafiles
2;
Select name from Datafiles
*
ERROR at line 1:
Ora-01219:database not open:queries allowed on fixed tables/views only


Sql> select name from V$datafile
2;

NAME
--------------------------------------------------------------------------------
/u01/oradata/emcdb/system01.dbf
/u01/oradata/emcdb/tools01.dbf
/u01/oradata/emcdb/rbs01.dbf
/u01/oradata/emcdb/temp01.dbf
/u01/oradata/emcdb/users01.dbf
/u01/oradata/emcdb/indx01.dbf
/u01/oradata/emcdb/drsys01.dbf
/u01/oradata/emcdb/emcbase.dbf
/home/oracle/test.dbf
/home/adonis/dwbx_wmstat.dbf
Home/adonis/iwbx_wmindx.dbf

Rows selected.

sql> ALTER DATABASE datafile '//HOME/ADONIS/IWBX_WMINDX.DBF ' offline
2;
ALTER DATABASE datafile '//HOME/ADONIS/IWBX_WMINDX.DBF ' offline
*
ERROR at line 1:
Ora-01145:offline immediate disallowed unless media recovery enabled


sql> ALTER DATABASE datafile '//HOME/ADONIS/IWBX_WMINDX.DBF ' offline drop;

Database altered.

sql> ALTER DATABASE datafile '/HOME/ADONIS/DWBX_WMSTAT.DBF ' offline drop;

Database altered.

sql> ALTER DATABASE open;
ALTER DATABASE Open
*
ERROR at line 1:
Ora-03113:end-of-file on communication channel


Sql> select name from V$tablespace;
Select name from V$tablespace
*
ERROR at line 1:
Ora-03114:not connected to ORACLE


Sql> connect System/manager as SYSDBA;
Connected.
Sql> select name from V$tablespace;

NAME
------------------------------
SYSTEM
TEMP
Rbs
INDX
USERS
Drsys
TOOLS
Emcbase
Test_user
Dwbx_wmstat
Iwbx_wmindx

Rows selected.

sql> ALTER DATABASE tablespace ' Dwbx_wmstat ' offline;
ALTER DATABASE tablespace ' Dwbx_wmstat ' offline
*
ERROR at line 1:
ora-02231:missing or invalid option to ALTER DATABASE


sql> drop tablespace Dwbx_wmstat;
Drop Tablespace Dwbx_wmstat
*
ERROR at line 1:
Ora-01549:tablespace not empty, use including CONTENTS option


Sql> drop tablespace dwbx_wmstat including CONTENTS;

Tablespace dropped.


Sql> drop tablespace iwbx_wmindx including CONTENTS;

Tablespace dropped.

Sql> ALTER DATABASE Open
2;
ALTER DATABASE Open
*
ERROR at line 1:
ORA-01531:A database already open by the instance


Database Open success!!!!!