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

显示全部楼层 · 2005-2-28 12:57:00

我的数据库
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
查了ora doc 说要BACKUP CONTROLFILE RECOVERY
请问怎样做？
一般是不是最好建多个控制文件，一个坏了，如何用另一个？
怎样知道哪个是好的？

千问 · 2005-2-28 12:57:00

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;

千问 · 2005-2-28 12:57:00

THANKS ，我回去试试

千问 · 2005-2-28 12:57:00

dear bin2bb:
当我运行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 上说，“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损坏了
我该怎么办？

千问 · 2005-2-28 12:57:00

数据库是非归档的，那怎么能usingbackup controlfile呢？

千问 · 2005-2-28 12:57:00

请问ZALBB：数据库应该配成什么样的模式有利于BACKUP,RECOVER？