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’
怎么办???
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’
怎么办???