ORA-1113 signalled during: alter database open...

平台:windows 2000 server

Oracle 9.2.0.4

使用了Windows的HA组件,在双机手工切换后打不开数据库,alert.log中出现

ORA-1113 signalled during: alter database open...错误.

alter database open
ORA-1113 signalled during: alter database open...
Fri Mar 24 16:07:21 2006
alter database open
ORA-1113 signalled during: alter database open...
Shutting down instance: further logons disabled
Shutting down instance (immediate)

由于不在现场,原来是用Veritas的备份去恢复的,结果发现Veritas没有备份Undo数据文件,s活不行.

到了现场后,首先把当时现场的备份恢复,然后执行以下步骤:

SQL>startup mount

SQL>recover database;

SQL>alter database open;

It works!

记得以前有这样的案例,结果一试即中,可怜我同事在现场呆了一整天:(