ORA-01157 cannot identify/lock data file 10
数据库报错：
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_STD01.dbf'
解决办法：
SQL> alter database datafile '/u01/app/oracle/oradata/orcl/TEST_STD01.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL> 数据库成功open！
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_STD01.dbf'
解决办法：
SQL> alter database datafile '/u01/app/oracle/oradata/orcl/TEST_STD01.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL> 数据库成功open！
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25174901/viewspace-1101293/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
