请问~~~ora-01207:file is more recent than controlfile - old controlfile??

long_ling 2002-08-27 09:36:19
请问~~~ora-01207:file is more recent than controlfile - old controlfile??
我的数据库
shutdown后再startup / force 出错:
ora-01122:database file string failed verification check
ora-01110:datfile string 'd:\oracle\oradata\blzgc\system01.dbf'
ora-01207:file is more recent than controlfile - old controlfile

bin2bb说要create new controlfile如下:
Create controlfile by yourself
Run the follow command in svrmgrl:
svrmgrl> alter database backup controlfile to trace;
Then find this trace file and edit it:
--Create_controlfile.sql
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "PROD" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 (
'/u8/orauat/uatdata/log01a.dbf',
'/u8/orauat/uatdata/log01b.dbf'
) SIZE 10M,
GROUP 2 (
'/u8/orauat/uatdata/log02a.dbf',
'/u8/orauat/uatdata/log02b.dbf'
) SIZE 10M
DATAFILE
'/u6/orauat/uatdata/system01.dbf',
'/u6/orauat/uatdata/system02.dbf',
......
......
......
'/u10/orauat/uatdata/xtrd01.dbf',
'/u6/orauat/uatdata/xtrx01.dbf'
CHARACTER SET WE8ISO8859P15
;
RECOVER DATABASE until cancel using backup controlfile
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE '/u6/orauat/uatdata/temp01.dbf' REUSE

可是:
当我运行recover database util cancel using backup controlfile后ora让我指定日志,我的数据库是非归档模式的,三个redo.log都试过,出两种错
(1):ora-00310:archived log contains sequence string(69456);sequence string(69454) required
ora-00334:archived log:'......*.log(my logfile)'
ora-01547:waring:recover succedded but open resetlogs would get error below
ora-01194:file '......\system01.dbf' needs more recovery to be consistent
好像看ora doc 上说要先检查Are All Data Files and Redo Logs OK? 大家是怎么检查的?ora doc:“First, look at the data files. Each of the data files probably has the same modification time, or there might be a group of them with one modification time and another group with a different modification time. The main thing to look for is a missing file or a zero length file. Something else to look for is one or more files that have a modification time that is newer than the newest online redo log file. If a data file meets any one of these conditions, it must be restored from backup. ”如果我的datafile比redo.log新,要先recover datafile后才能重建ctlfile,但当我recover tablespace system时就报
ora-00283:
ora-01610:recovery using the backup controlfile option must be done
(2):ora-00283:recovery session canceled due to errors
ora-00600:internal error code,arguments:[][][]....................
好像是redo.log损坏了
我该怎么办?
...全文
331 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

17,377

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧