一次oracle数据库数据块损坏的处理过程 - 数据库编程

1. If you could restore your StorageEnvironment and the Online RedoLogs from the Time of the crash you can try amanual Recovery followed by a RESETLOGS: SQL> startup mount; SQL> recover database until cancel usingbackup controlfile; -> manually provide Online RedoLogcontaining the last (current) Sequence when asked, eg. ORA-00279: change 100000 generated atxx/xx/xxxx xx:xx:xx needed for thread 1 ORA-00289: suggestion : /flash_recovery/archivelog/xxxx_xx_xx/o1_mf_1_100_%u_.arc ORA-00280: change 100000 for thread 1 is insequence #100 Specify log: {=suggested |filename | AUTO | CANCEL} /ora/oradata/dbtest/redo04_1.rdo Log applied. Media recovery complete. SQL> alter database open resetlogs;

5,通过metalink上的解决方法，根据提示输入在线日志文件名，数据库却再次报错ORA-00600 [2662] [2139]: internal errorcode, arguments: [2662], [2139], [791626372], [2139],

[oracle@localhost oradata]$ sqlplus"/as sysdba"

 SQL*Plus: Release 11.2.0.1.0 Production onThu Feb 6 17:53:47 2014

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

Connected to an idle instance.

SQL> startup mount;

ORACLE instance started.

 Total System Global Area 6714322944 bytes

Fixed Size                  2226056 bytes

Variable Size            5033166968 bytes

Database Buffers         1660944384 bytes

Redo Buffers               17985536 bytes

Database mounted.

SQL> recover database until cancel usingbackup controlfile;

ORA-00279: change 9187726668895 generatedat 02/05/2014 01:00:04 needed for

thread 1

ORA-00289: suggestion :/app/archive_log/1_2022_804560942.dbf

ORA-00280: change 9187726668895 for thread1 is in sequence #2022


Specify log: {




=suggested |filename | AUTO | CANCEL}

/app/oracle/oradata/epm/redo03.log

Log applied.

Media recovery complete.

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-00603: ORACLE server session terminatedby fatal error

ORA-00600: internal error code, arguments:[2662], [2139], [791626372], [2139],

[791626610], [12583120], [], [], [], [],[], []

ORA-00600: internal error code, arguments:[2662], [2139], [791626371], [2139],

[791626610], [12583120], [], [], [], [],[], []

ORA-01092: ORACLE instance terminated.Disconnection forced

ORA-00600: internal error code, arguments:[2662], [2139], [791626368], [2139],

[791626610], [12583120], [], [], [], [],[], []

Process ID: 9658

Session ID: 1705 Serial number: 5

6，再次查看alert日志，报错基本和上述相同，并提示，生成了一个trc文件，网上查询，确定为resetlogs仍然存在数据库坏块

[oracle@localhost trace]$ tail -falert_epm1.log

ORA-00600: internal error code, arguments:[2662], [2139], [791626371], [2139], [791626610], [12583120], [], [], [], [],[], []

ORA-01092: ORACLE instance terminated.Disconnection forced

ORA-00600: internal error code, arguments:[2662], [2139], [791626368], [2139], [791626610], [12583120], [], [], [], [],[], []

Incident details in:/app/oracle/diag/rdbms/epm/epm1/incident/incdir_411735/epm1_ora_9658_i411735.trc

Errors in file/app/oracle/diag/rdbms/epm/epm1/incident/incdir_411735/epm1_ora_9658_i411735.trc:

ORA-00603: ORACLE server session terminatedby fatal error

ORA-00600: internal error code, arguments:[2662], [2139], [791626372], [2139], [791626610], [12583120], [], [], [], [],[], []

ORA-00600: internal error code, argu

一次oracle数据库数据块损坏的处理过程(二)