SQL> startup
ORACLE instance started.Total System Global Area 3154116608 bytes
Fixed Size 2059856 bytes
Variable Size 1929384368 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14712832 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 19 - see DBWR trace file
ORA-01110: data file 19: '/dev/raw/raw214
raw216'
ORACLE instance started.Total System Global Area 3154116608 bytes
Fixed Size 2059856 bytes
Variable Size 1929384368 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14712832 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 19 - see DBWR trace file
ORA-01110: data file 19: '/dev/raw/raw214
raw216'
Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.
Action: Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.
之前做过什么操作? 是否对数据文件 19 做过修改?
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
可能数据文件有损坏,有备份就恢复一下吧。 ------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
--估计你没备份 参考下这吧