出现问题:sql> startup; oracle instance started. Total System Global Area 2371719168 bytesFixed Size
出现问题:
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;
Database altered.
SQL> alter database datafile '/opt/oracle/oradata/orcl/srcmsg.dbf' offline;
Database altered.
最后打开数据库就可以了
--结束END--
本文标题: Oracle数据库启动时出现ORA-01157和ORA-01110问题
本文链接: https://lsjlt.com/news/49322.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-10-23
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0