文档介绍:ORA-01152错误解决方法 用老的备份controlfile 2010-01-26 14:10 SQL> startup; ORA-32004: obsolete and/or deprecated parameter(s) sp controlfile until cancel; ORA-00279: change 4697108 generated at 12/24/2007 11:48:57 needed for thread 1 ORA-00289: suggestion : L:\ORACLE\PRODUCT\\ORADATA\ORC2\ ORA-00280: change 4697108 for thread 1 is in sequence #7 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cancel ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'L:\ORACLE\PRODUCT\\ORADATA\ORC2\' ORA-01112: media recovery not started SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'L:\ORACLE\PRODUCT\\ORADATA\ORC2\' SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile; System altered. SQL> recover database using backup controlfile until cancel;ORA-00279: change 4697108 generated at 12/24/2007 11:48:57 needed for thread 1 ORA-00289: suggestion : L:\ORACLE\PRODUCT\\ORADATA\ORC2\ ORA-00280: change 4697108 for thread 1 is in sequence #7 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cance