ORA-01157

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01157: cannot identify/lock data file 228 - see DBWR trace file

ORA-01110: data file 228: '/datavg02/dev4/data/pax01.dbf'

查看dbwr trace file 报错如下：

*** SESSION ID:(2.1) 2012-10-08 15:28:26.512

ORA-01157: cannot identify/lock data file 228 - see DBWR trace file

ORA-01110: data file 228: '/datavg02/dev4/data/pax01.dbf'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

ORA-01157: cannot identify/lock data file 513 - see DBWR trace file

ORA-01110: data file 513: '/datavg02/dev4/data/temp01.dbf'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

*** 2012-10-08 15:32:58.621

ORA-01157: cannot identify/lock data file 228 - see DBWR trace file

ORA-01110: data file 228: '/datavg02/dev4/data/pax01.dbf'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

ORA-01157: cannot identify/lock data file 513 - see DBWR trace file

ORA-01110: data file 513: '/datavg02/dev4/data/temp01.dbf'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

~

到相应的目录下找不到文件，看来是clone没有完成，可以考虑重建临时文件并且offline掉pax01.dbf文件

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21416913/viewspace-745917/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21416913/viewspace-745917/