这样就可以了 先mount数据库,然后再目录下建同名文件redo01.log、redo02.log、redo03.log 然后执行alter databse clear logfile group n 对于current的group,执行alter databse clear unarchived logfile group n 然后,再open,就ok了
其实你自己的方法就可以。 recover database using backup controlfile until cancel ORA-00279: change 9374248 generated at 10/24/2002 16:43:04 needed for thread 1 ORA-00289: suggestion : /opt/oracle/app/oracle/product/8.1.7/dbs/arch1_40865.dbf ORA-00280: change 9374248 for thread 1 is in sequence #40865 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} 这里选择CANCEL,回车alter database open resetlogs; OK
先mount数据库,然后再目录下建同名文件redo01.log、redo02.log、redo03.log
然后执行alter databse clear logfile group n
对于current的group,执行alter databse clear unarchived logfile group n
然后,再open,就ok了
recover database using backup controlfile until cancel
ORA-00279: change 9374248 generated at 10/24/2002 16:43:04 needed for thread 1
ORA-00289: suggestion : /opt/oracle/app/oracle/product/8.1.7/dbs/arch1_40865.dbf
ORA-00280: change 9374248 for thread 1 is in sequence #40865
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
这里选择CANCEL,回车alter database open resetlogs;
OK