事情的经过:最开始是我的数据库undotbs2表空间满了,设置了32G,还是满了。然后就想到了重建一个undotbs1表空间。
创建很顺利,切换过来也很顺利。查看了一下 v$datafile表里的运行状态,看到新建的
undotbs1也运行正常。就把原来的undotbs2表空间删除了,删除了发现undotbs2的数据文件undotbs2-2.dbf还在磁盘里,就用rm命令把这个文件删除了。这事过去了几个月后,今天我无聊看alrter.log日志,发现一直在提示如下警告:HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
Thu Dec 4 07:21:07 2014
Errors in file /oracle/OraHome_1/admin/nc/bdump/nc_dbw0_2865.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/oradata/nc/undotbs2_02.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
Thu Dec 4 07:21:07 2014
Errors in file /oracle/OraHome_1/admin/nc/bdump/nc_dbw0_2865.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/oradata/nc/undotbs2_02.dbf'
ORA-27037: unable to obtain file
这种情况下我要怎么办?
是不是要在数据库里drop一下这个数据文件?
收起