问题:
SQL> startup
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 281021520 bytes
Database Buffers 549453824 bytes
Redo Buffers 2371584 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u01/app/datafile/orcl/test1.dbf'
1:首先将对应报错的数据文件脱机
SQL
>
alter
database
datafile '/u01/app/datafile/orcl/test1.dbf'
offline;
Database
altered.
2:其次recover这个数据文件
SQL
>
alter
database
recover datafile '/u01/app/datafile/orcl/test1.dbf'
;
Database
altered.
3:然后将该数据文件联机上线
SQL
>
alter
database
datafile '/u01/app/datafile/orcl/test1.dbf'
online;
Database
altered.
4:最后将该表空间test1联机上线。
SQL
>
ALTER
TABLESPACE test1 ONLINE ;