ORA-01157、01110问题解决

ORA-01157、01110问题解决

 

 

SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              75499764 bytes
Database Buffers           88080384 bytes
Redo Buffers                2973696 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/u01/oradata/example/test.dbf'

归档模式：
SQL>alter database datafile '/u01/oradata/example/test.dbf' offline;
非归档模式：
SQL>alter database datafile '/u01/oradata/example/test.dbf' offline drop;
然后在

SQL>alter database open;