案例解决：一次oracle掉电的处理过程资源-CSDN文库

版权申诉

5星 · 超过95%的资源 35 浏览量 2023-04-22 10:28:29 上传评论收藏 528KB PDF 举报

资源推荐

资源详情

资源评论

年关事情多，最近设备运行极度不正常，好像是过年了，也想罢工休息一样！昨

日一台 oracle db 主板坏掉，数据库也随之崩溃，oracle 服务器重启后，无法 open，

以下是恢复过程！

/home/oracle$sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 1 月 18 15:50:26 2008

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

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 616562688 bytes

Fixed Size 1220868 bytes

IXDBA.NET 技术社区

Variable Size 167775996 bytes

Database Buffers 440401920 bytes

Redo Buffers 7163904 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL>

检查 alter 日志，发现如下错误：

Fri Jan 18 09:57:19 2008

ALTER DATABASE RECOVER LOGFILE '/opt/oracle/oradata/oradb/redo03.log'

Fri Jan 18 09:57:19 2008

Media Recovery Log /opt/oracle/oradata/oradb/redo03.log

Fri Jan 18 09:57:19 2008

Errors in file /opt/oracle/admin/oradb/bdump/oradb_p002_6556.trc:

ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [4099],

[6101], [], [], [], []

Fri Jan 18 09:57:19 2008

Errors in file /opt/oracle/admin/oradb/bdump/oradb_p000_6552.trc:

ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [3770],

[6255], [], [], [], []

Fri Jan 18 09:57:19 2008

Errors in file /opt/oracle/admin/oradb/bdump/oradb_p002_6556.trc:

ORA-10562: Error occurred while applying redo to data block (file# 1, block# 4099)

ORA-10564: tablespace SYSTEM

ORA-01110: data file 1: '/opt/oracle/oradata/oradb/bak/system01.dbf'

ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 517

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [4099],

[6101], [], [], [], []

Fri Jan 18 09:57:20 2008

Errors in file /opt/oracle/admin/oradb/bdump/oradb_p000_6552.trc:

ORA-10562: Error occurred while applying redo to data block (file# 1, block# 3770)

ORA-10564: tablespace SYSTEM

ORA-01110: data file 1: '/opt/oracle/oradata/oradb/bak/system01.dbf'

ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 482

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [3770],

[6255], [], [], [], []

Recovery interrupted!

Recovered data files to a consistent state at change 2433115

Fri Jan 18 09:57:24 2008

Media Recovery failed with error 12801

ORA-283 signalled during: ALTER DATABASE RECOVER LOGFILE

'/opt/oracle/oradata/oradb/redo03.log' ...

Fri Jan 18 09:57:24 2008

ALTER DATABASE RECOVER CANCEL

ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...

Shutting down instance: further logons disabled

初步断定是当前 redo 由于突然断电造成损坏，重启 db 后，造成系统表空间不一致，db 无法起

动。

经过询问和检查，数据库没有备份，并且处于非归档模式。

解决办法只有一个加上隐含参数起动试试！

_ALLOW_RESETLOGS_CORRUPTION = TRUE

SQL> show parameter spfile

NAME TYPE VALUE

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

spfile string /opt/oracle/product/10.2.0.1/d

b_1/dbs/spfileoradb.ora

SQL> show parameter '_all'*

NAME TYPE

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

剩余15页未读，继续阅读

内容反馈

版权申诉

Chris_in_Shanghai

2023-07-10

简直是宝藏资源，实用价值很高，支持！

CodeGolang

粉丝: 56
资源: 1100

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈

feedback-tip