oracle误删system数据文件
我菜鸟一枚，把system01.dbf给删除了，把原来的备份的system01.dbf拷贝过去了，
结果数据库只能启动懂mount阶段
open的时候 报错误
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf' 本帖最后由 biotwang 于 2017-8-3 11:59 编辑
ORA-01157通常由后台进程DBWR锁定而产生。
如果在恢复期间，如数据库已经mount，而一个或多个数据文件不能打开导致数据库不能open时会出现该提示。
数据文件丢失，数据文件的许可问题，如数据文件Oracle用户没有写权限等都会产生ORA-01157。
如果open状态的情形下，ORA-01157未列出的数据文件不会受到影响。$ oerr ora 01157
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.
页:
[1]