husthxd - by - 25 三月, 2006 21:02
平台: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!
记得以前有这样的案例,结果一试即中,可怜我同事在现场呆了一整天:(
最新回复