?高分紧急求救:ORACLE瘫了,哪位大虾能救?小弟先谢了……(200分)

L

longwx

Unregistered / Unconfirmed
GUEST, unregistred user!
我的数据库是非归档方式的,UPS坏导致掉电,打开服务器,启动ORACLE数据库提示
ora-01122: datafile 1 - failed verification check
ora-01110: datafile 1:’d:/orant/database/sys1orcl.ora’
ora-01207: file is more recent than control file - old control file
认为控制文件与数据文件时间不匹配,于是重建控制文件:
1.用internal登录instance manager,shutdown数据库

2.
删除D:/ORANT/DATABASE/下的CTL1ORCL.ORA、CTL2ORCL.ORA

3.
打开MSDOS方式,执行SVRMGR30,出现SVRMGR>
然后执行以下命令:
SVRMGR>CONNECT INTERNAL/oracle
SVRMGR>STARTUP NOMOUNT
SVRMGR>CREATE CONTROLFILE
DATABASE ORCL
LOGFILE 'E:/ORANT/DATABASE/LOGORCL1.ORA' SIZE 1M,
'E:/ORANT/DATABASE/LOGORCL2.ORA' SIZE 1M
RESETLOGS
DATAFILE 'E:/ORANT/DATABASE/SYS1ORCL.ORA' SIZE 50M,
'E:/ORANT/DATABASE/USR1ORCL.ORA' SIZE 3M,
'E:/ORANT/DATABASE/RBS1ORCL.ORA' SIZE 10M,
'E:/ORANT/DATABASE/TMP1ORCL.ORA' SIZE 10M,
'E:/ORANT/DATABASE/INDX1ORCL.ORA' SIZE 10M,
' E:/ORANT/DATABASE/DATA.ORA' SIZE 380M;
重建后发生:
ORA-01152: file 1 was not restored from a sufficiently old backup
ora-01110: datafile 1:’d:/orant/database/sys1orcl.ora’
怎么办???
 
>>,oracle for linux倒是玩过
 
你这是Oracle DBA的问题,还是到Oracle的网站去看看吧
 
http://godbless.easthome.net/
 
我已经解决了,使用recover automatic database.虽说不属于Delphi问题,但我想对大家
还是有帮助的。
 
厉害,要多向你学习。
 
多人接受答案了。
 
顶部