SQL> startup
ORACLE instance started.
Total System Global Area 6680915968 bytes
Fixed Size 2213936 bytes
Variable Size 5234493392 bytes
Database Buffers 1409286144 bytes
Redo Buffers 34922496 bytes
Database mounted.
ORA-01113: 文件 11 需要介质恢复
ORA-01110: 数据文件 11: '/home/oracle/abc/abc.dbf'
SQL> shutdown immediate;
ORA-01109: 数据库未打开
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 6680915968 bytes
Fixed Size 2213936 bytes
Variable Size 5234493392 bytes
Database Buffers 1409286144 bytes
Redo Buffers 34922496 bytes
Database mounted.
SQL> alter database datafile '/home/oracle/abc/abc.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 6680915968 bytes
Fixed Size 2213936 bytes
Variable Size 5234493392 bytes
Database Buffers 1409286144 bytes
Redo Buffers 34922496 bytes
Database mounted.
Database opened.
SQL> drop tablespace BKJ including contents;
Tablespace dropped.