ORA-01157: cannot identify/lock data file 8 - see DBWR trace file,数据恢复技术服务-->解决方法-->霍工-->13301272832(微信同号)
SQL> select count(*) from test;
select count(*) from test
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 7: '+TESTDG/test/datafile/test.156.58163100'
SQL>
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '+TESTDG/test/datafile/test.156.58163100'
ORA-17503: ksfdopn:2 Failed to open file'+TESTDG/test/datafile/test.156.58163100'
ORA-15001: diskgroup "TESTDG" does not exist or is not mounted
ORA-15001: diskgroup "TESTDG" does not exist or is not mounted