ORA-01113和ORA-01113的问题处理

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.