linux oracle ora-01157,Oracle数据库启动时出现ORA-01157和ORA-01110问题

Oracle数据库启动时出现ORA-01157和ORA-01110问题

发布时间：2020-08-13 22:40:15

来源：51CTO

阅读：2620

作者：欲黄大帝

出现问题：

SQL> startup;

ORACLE instance started.

Total System Global Area 2371719168 bytes

Fixed Size 2215624 bytes

Variable Size 1342177592 bytes

Database Buffers 1023410176 bytes

Redo Buffers 3915776 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

ORA-01110: data file 6: '/opt/oracle/oradata/orcl/srcmsg.dbf'

解决办法：

1.关库

SQL> shutdown immediate;

alter database open

ORA-01157: cannot identify/lock data file 10 - see DBWR trace file

ORA-01110: data file 12: '/oradata/orcldata/sacproduce02.dbf'

报错信息为不能进行读写操作，挂载的硬盘不能进行读写操作了。要打开数据库，只能将该文件进行离线操作了。

SQL> archive log list; //查一下数据库的归档模式，

Database log mode No Archive Mode //非归档模式

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 4

Current log sequence 6

若归档模式下，则：

alter database datafile '/oradata/orcldata/sacproduce02.dbf' offline

非归档模式下(现在情况)

alter database datafile '/oradata/orcldata/sacproduce02.dbf'offline drop

SQL> alter database datafile '/opt/oracle/oradata/orcl/srcmsg.dbf' offline drop;

Database altered.

SQL> alter database datafile '/opt/oracle/oradata/orcl/srcmsg.dbf' offline;

Database altered.

最后打开数据库就可以了