ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 用老控制文件恢复数据库

用老控制文件恢复数据库

原创 Linux操作系统 作者:kevinhong1986 时间:2012-05-08 23:04:39 0 删除 编辑

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.

SQL> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------

           4711164
           4711164
           4711164
           4711164
           4711164
           4711164
           4711164
           4711164
           4664735

9 rows selected.


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/10.2.0/ORADATA/ORC2/ARCHIVEARC00007_0641832494.001
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/10.2.0/ORADATA/ORC2/SYSTEM01.DBF'


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/10.2.0/ORADATA/ORC2/SYSTEM01.DBF'



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/10.2.0/ORADATA/ORC2/ARCHIVEARC00007_0641832494.001
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/10.2.0/ORADATA/ORC2/SYSTEM01.DBF'


ORA-01112: media recovery not started

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL> startup force;
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.
Database opened.


SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------

           4717118

SQL> select checkpoint_change# from v$datafile;

CHECKPOINT_CHANGE#
------------------

           4717118
           4717118
           4717118
           4717118
           4717118
           4717118
           4717118
           4717118
           4664735

9 rows selected.

SQL> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------

           4717118
           4717118
           4717118
           4717118
           4717118
           4717118
           4717118
           4717118
                 0

9 rows selected.

SQL> select last_change# from v$datafile;

LAST_CHANGE#
------------









     4664735

9 rows selected.
具体步骤如下:
startup force;
alter system set "_allow_resetlogs_corruption"=true scope=spfile;
recover database using backup controlfile until cancel;
alter databse open resetlogs;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26912144/viewspace-723091/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oralce-参数
请登录后发表评论 登录
全部评论

注册时间:2012-04-23

  • 博文量
    16
  • 访问量
    21607