葡京在线开户小结Oracle8i 的UNDO表空间损坏(ORA-01092及ORA-00600【4193】)情状下的数据库不完全苏醒的经历

Less is more,我爱不释手极简主义。

服务器断电重启导致备份生产环境的复原目录库不能展开启动,提醒Ora-01092例程终止。强行断开连接

大(大数据)云(云服务)平(平台化)移(移动化)的互联网时代,信息膨胀,沙海淘金,近期偶有所获,记录收藏和享用。涨姿势,走起!

翻看跟踪日志:

有关产品首席营业官

http://www.woshipm.com/足矣

Wed Jan 10 08:41:37 2018

至于配色

http://www.peise.net/tools/web/足矣

Errors in file d:\Oracle\admin\l3bckdb\bdump\l3bckdbSMON.TRC:

关于在线作图

https://www.processon.com/i/559231a0e4b05cfbd62a0b2e足矣,思维导图、流程图、UML图、原型图神马的,妥妥的

ORA-00600: internal error code, arguments: [4193], [1836], [1844],
[]葡京在线开户,, [], [], [], []

关于大数额

http://www.199it.com/足矣

 

有关社会化媒体

http://www.socialbeta.com/足矣

Wed Jan 10 08:41:39 2018

至于思维导图

http://www.mindmap.com.cn/足矣

Errors in file d:\Oracle\admin\l3bckdb\bdump\l3bckdbSNP1.TRC:

关于PMP

PMBOK知识入门,先看这一本书不懂项目管理,别想当主持:从造船案例轻松学会PMP管理的实践》,图文并茂

ORA-00600: internal error code, arguments: [4193], [1926], [1934],
[], [], [], [], []

有关在线写作分享

简书http://www.jianshu.com/足矣,点自己的邀请链接:http://www.jianshu.com/ui?t=02ed94e09dff

 

Recovery of Online Redo Log: Thread 1 Group 3 Seq 15 Reading mem 0

  Mem# 0 errs 0: D:\ORACLE\ORADATA\L3BCKDB\REDO01.LOG

Wed Jan 10 08:41:42 2018

Recovery of Online Redo Log: Thread 1 Group 3 Seq 15 Reading mem 0

  Mem# 0 errs 0: D:\ORACLE\ORADATA\L3BCKDB\REDO01.LOG

Wed Jan 10 08:41:42 2018

SMON: terminating instance due to error 600

Instance terminated by SMON, pid = 2744

 葡京在线开户 1

 

追寻有关资料,发现RA-600[4913]错误的2个argument的含义,
该ORA-600[4913]属于内核undo事务模块

[1836] Undo record seq number

[1844] Redo record seq number

出于UNDO系列和REDO体系不一样引发错误。

解决办法:重建UNDO表空间,步骤如下:

C:/>set nls_lang=american_america.zhs16gbk

C:/>sqlplus “/ as sysdba”

SQL*Plus: Release 8.1.7.0.0 – Production on 星期三 1月 10 11:28:47 2018

(c) Copyright 2000 Oracle Corporation. All rights reserved.

 

连接到:

 Oracle8i Enterprise Edition Release 8.1.7.0.0  – Production

With the Partitioning option

JServer Release 8.1.7.0.0 – Production

 葡京在线开户 2

SQL> select file#,name from v$datafile where file#=2;

FILE# NAME


2 D:/ORACLE/ORADATA/BCCHECK/RBS01.DBF

SQL> shutdown immediate

ORA-01109: 数据库未打开。

 

一度卸载数据库。

ORACLE例程已关闭。

 

将init.ora文件中的ROLLBACK_SEGMENTS先导化参数设置注释后以Restricted情势MOUNT数据库。

#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )

SQL> startup restrict mount

ORACLE例程已开行。

Total System Global Area 219895052 bytes

Fixed Size 70924 bytes

Variable Size 75116544 bytes

Database Buffers 144629760 bytes

Redo Buffers 77824 bytes

数据库装载完毕。

 

在线drop损坏的rbs数据文件,然后重试打开数据库

 葡京在线开户 3

 

 

 

SQL> drop tablespace rbs including contents;

drop tablespace rbs including contents

*

ERROR 在行 1:

ORA-01548: active rollback segment ‘RBS0’ found, terminate dropping
tablespace

— 报错ORA-01548,注明有运动回滚段

 

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

SEGMENT_NAME TABLESPACE_NAME STATUS



SYSTEM SYSTEM ONLINE

RBS0 RBS NEEDS RECOVERY

RBS1 RBS NEEDS RECOVERY

RBS2 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

RBS4 RBS NEEDS RECOVERY

RBS5 RBS NEEDS RECOVERY

RBS6 RBS NEEDS RECOVERY

已选择8 行

SQL> shutdown immediate


正常关闭数据库参加富含函数_corrupted_rollback_segments,修改参数文件出席富含参数

_corrupted_rollback_segments=(RBS0,RBS1,RBS2,RBS3,RBS4,RBS5,RBS6)后以restricted情势打开数据库

SQL> startup restrict

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

SEGMENT_NAME TABLESPACE_NAME STATUS



SYSTEM SYSTEM ONLINE

RBS0 RBS NEEDS RECOVERY

RBS1 RBS NEEDS RECOVERY

RBS2 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

RBS4 RBS NEEDS RECOVERY

RBS5 RBS NEEDS RECOVERY

RBS6 RBS NEEDS RECOVERY

已选择 8 行

SQL> drop tablespace rbs including contents;

drop tablespace rbs including contents

*

ERROR 在行 1:

ORA-01548: active rollback segment ‘RBS0’ found, terminate dropping
tablespace

强制删除所急需的回滚段

 葡京在线开户 4

 

 

除去包含损坏回滚段表空间后,并初步建立回滚段表空间

 葡京在线开户 5

 

 

询问回滚段状态

 葡京在线开户 6

 

常规关闭数据库,并将参数文件中的隐含参数_corrupted_rollback_segments注释,并将ROLLBACK_SEGMENTS参加所有的回滚段。

 葡京在线开户 7

 

正常启动数据库

 葡京在线开户 8