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

ORA-01157通常由后台进程DBWR锁定而产生。
如果在恢复期间，如数据库已经mount，而一个或多个数据文件不能打开导致数据库不能open时会出现该提示。
数据文件丢失，数据文件的许可问题，如数据文件Oracle用户没有写权限等都会产生ORA-01157。
如果open状态的情形下，ORA-01157未列出的数据文件不会受到影响。

1. [oracle@m1 ~]$ oerr ora 01157
   
2. 01157, 00000, "cannot identify/lock data file %s - see DBWR trace file"
   
3. // *Cause:  The background process was either unable to find one of the data
   
4. //         files or failed to lock it because the file was already in use.
   
5. //         The database will prohibit access to this file but other files will
   
6. //         be unaffected. However the first instance to open the database will
   
7. //         need to access all online data files. Accompanying error from the
   
8. //         operating system describes why the file could not be identified.
   
9. // *Action: Have operating system make file available to database. Then either
   
10. //         open the database or do ALTER SYSTEM CHECK DATAFILES.

复制代码