ORA-00354: 损坏重做日志块标头恢复-20190110 | ORACLE非常规恢复 | ORACLE技术论坛

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS Related Topics
ORA-00354: 损坏重做日志块标头恢复-20190110
2019 年 01 月 10 日
22:21
惜分飞
Admin
Forum Posts: 369
Member Since:
2010 年 07 月 31 日
Offline

数据库无法正常recover

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 1月 4 10:00:43 2019

Copyright (c) 1982, 2010, Oracle. All rights reserved.

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> RECOVER DATAFILE 4;
完成介质恢复。
SQL> RECOVER DATAFILE 5;
完成介质恢复。
SQL> RECOVER DATAFILE 6;
ORA-00283: 恢复会话因错误而取消
ORA-00354: 损坏重做日志块标头
ORA-00353: 日志损坏接近块 41452 更改 39161267 时间 01/03/2019 10:01:38
ORA-00312: 联机日志 1 线程 1: 'F:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG'

SQL> RECOVER DATAFILE 7;
完成介质恢复。
SQL> RECOVER DATAFILE 8;
ORA-00283: 恢复会话因错误而取消
ORA-00354: 损坏重做日志块标头
ORA-00353: 日志损坏接近块 41452 更改 39161267 时间 01/03/2019 10:01:38
ORA-00312: 联机日志 1 线程 1: 'F:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG'

SQL> SELECT GROUP#,status from v$log;

GROUP# STATUS
———- —————-
1 INACTIVE
3 INACTIVE
2 CURRENT

SQL> recover database until cancel;
ORA-00279: 更改 39139738 (在 01/03/2019 09:21:33 生成) 对于线程 1 是必需的
ORA-00289: 建议:
F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2019_01_04\O1_MF_1_2051

_%U_.ARC
ORA-00280: 更改 39139738 (用于线程 1) 在序列 #2051 中

指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-10879: error signaled in parallel recovery slave
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: 'F:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF'

 

通过屏蔽数据库一致性,强制open库

SQL> alter database open resetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [2662], [0], [39139746], [0],
[39167700], [4194545], [], [], [], [], [], []
进程 ID: 5544
会话 ID: 177 序列号: 5

 

修改数据库scn,数据库open成功,导出数据恢复完成

Q Q:107644445  

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

    

       
   

评论功能已关闭。