我察看alert.log文件,发现提示如下SMON: about to recover undo segment 1 SMON: undo segment 1 as needs recovery SMON: about to recover undo segment 2 SMON: undo segment 2 as needs recovery SMON: about to recover undo segment 3 SMON: undo segment 3 as needs recovery SMON: about to recover undo segment 4 SMON: undo segment 4 as needs recovery SMON: about to recover undo segment 5 SMON: undo segment 5 as needs recovery SMON: about to recover undo segment 6 SMON: undo segment 6 as needs recovery SMON: about to recover undo segment 7 SMON: undo segment 7 as needs recovery SMON: about to recover undo segment 8 SMON: undo segment 8 as needs recovery SMON: about to recover undo segment 9 SMON: undo segment 9 as needs recovery SMON: about to recover undo segment 10 SMON: undo segment 10 as needs recovery Wed Dec 28 16:19:27 2005 SMON: about to recover undo segment 1 SMON: undo segment 1 as needs recovery SMON: about to recover undo segment 2 SMON: undo segment 2 as needs recovery SMON: about to recover undo segment 3 SMON: undo segment 3 as needs recovery SMON: about to recover undo segment 4 SMON: undo segment 4 as needs recovery SMON: about to recover undo segment 5 SMON: undo segment 5 as needs recovery SMON: about to recover undo segment 6 SMON: undo segment 6 as needs recovery SMON: about to recover undo segment 7 SMON: undo segment 7 as needs recovery SMON: about to recover undo segment 8 SMON: undo segment 8 as needs recovery SMON: about to recover undo segment 9 SMON: undo segment 9 as needs recovery SMON: about to recover undo segment 10 SMON: undo segment 10 as needs recovery Wed Dec 28 16:19:27 2005 Errors in file f:\oracle\admin\ghjsvr\bdump\ghjsvr_smon_2036.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: 'F:\ORACLE\ORADATA\GHJSVR\UNDOTBS01.DBF'
你改的是init.ora还是pfile文件?最好通过alter system来改一下
已经执行alter system set undo_tablespace=新的undotablespace了
标准的处理流程应该是怎么样的?
http://www.chinaitlab.com/www/news/article_show.asp?id=38449这个文章我看了,还不错。
你可以重新创建spfilestartup pfile='f:\oracle\admin\ghjsvr\pfile\init.ora.9292005225041'
Create spfile from pfile='f:\oracle\admin\ghjsvr\pfile\init.ora.9292005225041';
SMON: undo segment 1 as needs recovery
SMON: about to recover undo segment 2
SMON: undo segment 2 as needs recovery
SMON: about to recover undo segment 3
SMON: undo segment 3 as needs recovery
SMON: about to recover undo segment 4
SMON: undo segment 4 as needs recovery
SMON: about to recover undo segment 5
SMON: undo segment 5 as needs recovery
SMON: about to recover undo segment 6
SMON: undo segment 6 as needs recovery
SMON: about to recover undo segment 7
SMON: undo segment 7 as needs recovery
SMON: about to recover undo segment 8
SMON: undo segment 8 as needs recovery
SMON: about to recover undo segment 9
SMON: undo segment 9 as needs recovery
SMON: about to recover undo segment 10
SMON: undo segment 10 as needs recovery
Wed Dec 28 16:19:27 2005
SMON: about to recover undo segment 1
SMON: undo segment 1 as needs recovery
SMON: about to recover undo segment 2
SMON: undo segment 2 as needs recovery
SMON: about to recover undo segment 3
SMON: undo segment 3 as needs recovery
SMON: about to recover undo segment 4
SMON: undo segment 4 as needs recovery
SMON: about to recover undo segment 5
SMON: undo segment 5 as needs recovery
SMON: about to recover undo segment 6
SMON: undo segment 6 as needs recovery
SMON: about to recover undo segment 7
SMON: undo segment 7 as needs recovery
SMON: about to recover undo segment 8
SMON: undo segment 8 as needs recovery
SMON: about to recover undo segment 9
SMON: undo segment 9 as needs recovery
SMON: about to recover undo segment 10
SMON: undo segment 10 as needs recovery
Wed Dec 28 16:19:27 2005
Errors in file f:\oracle\admin\ghjsvr\bdump\ghjsvr_smon_2036.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'F:\ORACLE\ORADATA\GHJSVR\UNDOTBS01.DBF'
ORA-00279: 更改 21813100 (在 12/05/2005 08:31:03 生成) 对于线程 1 是必需的
ORA-00289: 建议: F:\ORACLE\ORA90\RDBMS\ARC00538.001
ORA-00280: 更改 21813100 对于线程 1 是按序列 # 538 进行的
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}后面该如何操作,指定日志后面的参数怎么处理,指定日志后是不是还要设定其他参数,请有经验的人多赐教。