3471
社区成员
等待高手解决------100分
我在启动数据库时遇到了这样的问题，应当怎么解决？
/dev/raw4 作的裸设备用来做undotablespace
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: '/dev/raw/raw4'
ORA-01203: wrong incarnation of this file - wrong creation SCN
/dev/raw4 作的裸设备用来做undotablespace
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: '/dev/raw/raw4'
ORA-01203: wrong incarnation of this file - wrong creation SCN
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
ojaoja 2004-11-11
- 打赏
- 举报
数据文件损坏。
这个问题比较麻烦，只能做数据库的介质恢复了，苦啊！
这个问题比较麻烦，只能做数据库的介质恢复了，苦啊！
newsjb 2004-11-08
- 打赏
- 举报
database file 2 failed verification check
ORA-01110: data file 2: '/dev/raw/raw4'
ORA-01203: wrong incarnation of this file - wrong creation SCN
检查下参数文件所指定的数据文件
ORA-01110: data file 2: '/dev/raw/raw4'
ORA-01203: wrong incarnation of this file - wrong creation SCN
检查下参数文件所指定的数据文件
GerryYang 2004-11-08
- 打赏
- 举报
alter database recover.
试一下.
试一下.
zhaokeke2004 2004-11-08
- 打赏
- 举报
ORA-01203 wrong incarnation of this file - wrong creation SCN
Cause: The creation SCN in the file header is not the same as the creation SCN in the control file. This is probably a copy of a file that was dropped.
Action: Restore a current copy of the datafile and do recovery as needed
Cause: The creation SCN in the file header is not the same as the creation SCN in the control file. This is probably a copy of a file that was dropped.
Action: Restore a current copy of the datafile and do recovery as needed
kmwy 2004-11-02
- 打赏
- 举报
startup recover
liujiasheng 2004-11-02
- 打赏
- 举报
好象是你的数据文件出现了问题，删除有此文件后，再建立一个相同文件的文件，重新启动数据库，为什么？我也不知道，但是好用就行.
hzf005 2004-11-02
- 打赏
- 举报
http://dev.csdn.net/article/42/42995.shtm 到这里去看看!
lialin 2004-11-01
- 打赏
- 举报
是不是这个设置出了问题，不能写？
没有遇到这种情况，看错误猜想的！
没有遇到这种情况，看错误猜想的！
zhihaitao 2004-11-01
- 打赏
- 举报
上次关闭是用的shutdown abort...
zhaokeke2004 2004-11-01
- 打赏
- 举报
你的数据库上次正常关闭了吗？
zhihaitao 2004-11-01
- 打赏
- 举报
数据库启动不了了。
startup nomount --OK
alter database mount --OK
alter database open --Fail
ERROR at line 1:
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: '/dev/raw/raw4'
ORA-01203: wrong incarnation of this file - wrong creation SCN
startup nomount --OK
alter database mount --OK
alter database open --Fail
ERROR at line 1:
ORA-01122: database file 2 failed verification check
ORA-01110: data file 2: '/dev/raw/raw4'
ORA-01203: wrong incarnation of this file - wrong creation SCN
zhihaitao 2004-11-01
- 打赏
- 举报
anybody here?