数据库报错:admin管理员组文章数量:1654283
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '/u01/app/oracle/oradata/orcl/TEST_STD01.dbf'
ORA-1157 signalled during: alter database open...
数据库启动报错:
Database mounted.
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10:
'/u01/app/oracle/oradata/orcl/ TEST_ST D01.dbf'
解决办法:
SQL> alter database datafile '/u01/app/oracle/oradata/orcl/ TEST_ST D01.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL> 数据库成功open!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub/25174901/viewspace-1101293/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub/25174901/viewspace-1101293/
版权声明:本文标题:ORA-01157 cannot identifylock data file 10 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/xitong/1729650700a1209004.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论