Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

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'

 

archive模式：
SQL>alter database datafile '/u01/oradata/example/test.dbf' offline;

noarchive模式：
SQL>alter database datafile '/u01/oradata/example/test.dbf' offline drop;
然後

SQL>alter database open;