oracle数据库ORA0115201110错误的解决办法.doc

文档介绍：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