今天做测试,删除了物理文件。想关闭实例报错,下面是错误:
SYS@orcl>shutdown immediate;
ORA-01116: error in opening database file 4
ORA-01110: data file 4: '/u01/app/oracle/oradata/orcl/disk1/build01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
最简单的 决方法:
SYS@orcl>alter database datafile '/u01/app/oracle/oradata/orcl/disk1/build01.dbf' offline drop;
SYS@orcl>shutdown immediate;
ORA-01116: error in opening database file 4
ORA-01110: data file 4: '/u01/app/oracle/oradata/orcl/disk1/build01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
最简单的 决方法:
SYS@orcl>alter database datafile '/u01/app/oracle/oradata/orcl/disk1/build01.dbf' offline drop;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28743704/viewspace-1140060/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28743704/viewspace-1140060/