数据库不正常,应用连接不上。
执行shutdown immediate,数据库报错,并且数据库无法挺下来
alert中报错信息:
Errors in file /oracle/admin/sid/bdump/sid_j002_8233.trc:
ORA-12012: error on auto execute of job 42781
ORA-27468: "EXFSYS.RLM$SCHDNEGACTION" is locked by another process
Fri Nov 6 09:32:12 2009
shutdow abort
发现有有类似instance can not allocate archive ,redo have archive require
startup
alter system switch logfile; ###hang住了
dd if=/dev/zero f=aaa.txt bs=1024k count=1000
shutdown immediate
startup mount
alter database noarchivelog;
alter database open;
alter system switch logfile ; ##正常了
shutdown immediate
startup mount
alter database archivelog;
alter database open;
alter system switch logfile ; ##正常了
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22698/viewspace-619503/ ,如需转载,请注明出处,否则将追究法律责任。