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

最新推荐文章于 2024-06-17 22:30:26 发布

weixin_33694172

最新推荐文章于 2024-06-17 22:30:26 发布

阅读量475

点赞数

文章标签：数据库

原文链接：http://blog.51cto.com/12015549/2165927

版权

出现问题：
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.
最后打开数据库就可以了

转载于:https://blog.51cto.com/12015549/2165927