小结Oracle8i 的UNDO表空间损坏(ORA-01092及ORA-00600【4193】)情状下的数据库不完全恢复生机的经验

ORA-01109: 数据库未打开。

 图片 1

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

ORA-00600: internal error code, arguments: [4193], [1836], [1844],
[], [], [], [], []

 图片 2

SQL> shutdown immediate


 

 

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

RBS6 RBS NEEDS RECOVERY

SEGMENT_NAME TABLESPACE_NAME STATUS

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

C:/>set nls_lang=american_america.zhs16gbk

SEGMENT_NAME TABLESPACE_NAME STATUS

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

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

已选择 8 行

RBS4 RBS NEEDS RECOVERY

 

RBS2 RBS NEEDS RECOVERY

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

 

 

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

RBS3 RBS NEEDS RECOVERY

Wed Jan 10 08:41:42 2018

[1844] Redo record seq number

*

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


翻开跟踪日志:

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

RBS4 RBS NEEDS RECOVERY

FILE# NAME

RBS5 RBS NEEDS RECOVERY

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

drop tablespace rbs including contents


SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

JServer Release 8.1.7.0.0 – Production

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

With the Partitioning option

Wed Jan 10 08:41:42 2018

 

 

SYSTEM SYSTEM ONLINE

[1836] Undo record seq number

SQL> startup restrict mount

RBS6 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

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

 Oracle8i Enterprise Edition Release 8.1.7.0.0  – Production

RBS1 RBS NEEDS RECOVERY

 图片 3

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

 

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

 

SMON: terminating instance due to error 600

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


RBS2 RBS NEEDS RECOVERY

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

 

 

好端端启动数据库

Wed Jan 10 08:41:39 2018

业已卸载数据库。

SQL> drop tablespace rbs including contents;

数据库装载完毕。

Wed Jan 10 08:41:37 2018

Variable Size 75116544 bytes

ORACLE例程已关闭。

连接到:

RBS0 RBS NEEDS RECOVERY

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

ORACLE例程已开行。

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

 图片 4

C:/>sqlplus “/ as sysdba”

*

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

Instance terminated by SMON, pid = 2744

已选择8 行

 

Total System Global Area 219895052 bytes

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

 

RBS0 RBS NEEDS RECOVERY

SQL> shutdown immediate

 图片 5

 

ERROR 在行 1:

 

Database Buffers 144629760 bytes

 图片 6

出于UNDO系列和REDO类别不一致引发错误。

除去包含损坏回滚段表空间后,并开头树立回滚段表空间

RBS1 RBS NEEDS RECOVERY

SYSTEM SYSTEM ONLINE

drop tablespace rbs including contents

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

 图片 7

 

Redo Buffers 77824 bytes

强制删除所需要的回滚段

RBS5 RBS NEEDS RECOVERY

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



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

ERROR 在行 1:

SQL> startup restrict

Fixed Size 70924 bytes

 图片 8

SQL> drop tablespace rbs including contents;

 

询问回滚段状态

将init.ora文件中的ROLLBACK_SEGMENTS初阶化参数设置注释后以Restricted形式MOUNT数据库。

相关文章