对应报错的数据文件脱机导致数据库无法开启

问题：

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 ;