ORA-01207 file is more recent than controlfile - old controlfileCause: The control file change sequence number in the datafile is greater than the number in the control file. This implies that the wrong control file is being used. Note that repeatedly causing this error can make it stop happening without correcting the real problem. Every attempt to open the database will advance the control file change sequence number until it is great enough.Action: Use the current control file or do BACKUP CONTROLFILE RECOVERY to make the control file current. Be sure to follow all restrictions on doing a BACKUP CONTROLFILE RECOVERY.
用internal/oracle以sysdba登录
选择database
在右边的点击Open
最后Apply即可
Logfile
group 1 ('/oracle/app/oracle/oradata/ora817/redo01.log'),
group 2 ('/oracle/app/oracle/oradata/ora817/redo02.log'),
group 3 ('/oracle/app/oracle/oradata/ora817/redo03.log'),
group 4 ('/oracle/app/oracle/oradata/ora817/redo04.log'),
group 5 ('/oracle/app/oracle/oradata/ora817/redo05.log'),
datafile '/oracle/app/oracle/oradata/ora817/system01.dbf',
'/oracle/app/oracle/oradata/ora817/users01.dbf',
'/oracle/app/oracle/oradata/ora817/temp01.dbf',
'/oracle/app/oracle/oradata/ora817/tools01.dbf',
'/oracle/app/oracle/oradata/ora817/indx01.dbf',
'/oracle/app/oracle/oradata/ora817/rbs01.dbf';datafile '/oracle/app/oracle/oradata/ora817/system01.dbf',
*
ORA-02236: invalid file name
这句话那个地方有问题吗?请高手指点
这样重新创建数据库有没有问题?
SVRMGR> startup mount
SVRMGR> recover database using backup controlfile
SVRMGR> alter database open
不会影响原有数据库。
报错:ORA-00279: change 1799716 generated at 02/24/2003 08:45:26 needed for thread 1
ORA-00289: suggestion : /archivelog/arch_1_55.arc
ORA-00280: change 1799716 for thread 1 is in sequence #55
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}ORA-00308: cannot open archived log '/archivelog/arch_1_55.arc'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
输入CANCEL。
ORA-00274: illegal recovery option CANCEL
SVRMGR> recover database using backup controlfile
ORA-00279: change 1799716 generated at 02/24/2003 08:45:26 needed for thread 1
ORA-00289: suggestion : /archivelog/arch_1_55.arc
ORA-00280: change 1799716 for thread 1 is in sequence #55
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SVRMGR> alter database open
2> ;
alter database open
*
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open还是报错!请教……,急急
试试
alter database open RESETLOGS
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/app/oracle/oradata/ora817/system01.dbf'
SVRMGR> recover datafile '/oracle/app/oracle/oradata/ora817/system01.dbf';
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SELECT * FROM v$recover_file; --确定那些数据文件需要恢复
SELECT * FROM v$recovery_log; --确定需要那些归档日志文件
/archivelog/arch_1_53.arc
recover database until '????';
recover database until 'Feb 12 2003 09:39:53';
ORA-00277: illegal option to the UNTIL recovery flag Feb 12 2003 09:39:53
recover database until time '2003-02-12:09:39:53' using backup controlfile;
时间格式是:“YYYY-MM-DD:HH:MI:SS”