ora-01157 处理过程

    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  系统，系统正常