oracle数据恢复报01152错误,oracle数据库ORA-01152-01110错误的解决办法

ORA-01152错误解决方法用老的备份controlfile

2010-01-26 14:10

SQL> startup;

ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started.

Total System Global Area 293601280 bytes

Fixed Size 1248600 bytes

Variable Size 96469672 bytes

Database Buffers 188743680 bytes

Redo Buffers 7139328 bytes

Database mounted.

ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1:

'L:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC2\SYSTEM01.DBF'

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#

------------------

4532411

SQL> select checkpoint_change# from v$datafile;

CHECKPOINT_CHANGE#

------------------

4532411

4532411

4532411

4532411

4532411

4532411

4532411

4532411

4664735

9 rows selected.