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博客 ” ，链接：https://blog.itpub.net/21416913/viewspace-745917/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
sybase迁移oracle的一些注意点
下一篇：
ora-12537ora-12537
请登录后发表评论
登录
全部评论
