2013年6月23 日 南非某运营商数据库,因为磁盘空间爆满,前线运维同事,进行了一些数据文件的移动引发数据库不能startup,
在alter 日志也无相关的错误。
有时会报
并出现 ora-01157错误。
oracle@mos5200db1:~> oerr ora 1157
01157, 00000, "cannot identify/lock data file %s - see DBWR trace file"
// *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.
这说明有文件已经在使用了。
再次shutdown 数据库。查看oracle 的进程,还存在几个进程。
尝试kill -9 来杀掉进程。但是还kill 不掉。
reboot 系统,系统正常