计算Oracle8i 的UNDO表空间损坏(ORA-01092及ORA-00600【4193】)情况下的数据库不完全复苏的阅历

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

Wed Jan 10 08:41:42 2018


ERROR 在行 1:

询问回滚段状态

Database Buffers 144629760 bytes


Wed Jan 10 08:41:39 2018

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

FILE# NAME

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

 图片 1

SQL> startup restrict mount

 

ORACLE例程已关门。

RBS4 RBS NEEDS RECOVERY

RBS4 RBS NEEDS RECOVERY

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

drop tablespace rbs including contents

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

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



SEGMENT_NAME TABLESPACE_NAME STATUS

RBS4 RBS NEEDS RECOVERY

 

强制删除所急需的回滚段

Fixed Size 70924 bytes

SMON: terminating instance due to error 600

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

RBS3 RBS NEEDS RECOVERY

 


SEGMENT_NAME TABLESPACE_NAME STATUS

Fixed Size 70924 bytes

已选择 8 行

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

SQL> shutdown immediate


符合规律关闭数据库插足富含函数_corrupted_rollback_segments,修改参数文件到场富含参数

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

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

drop tablespace rbs including contents

曾经卸载数据库。

SQL> drop tablespace rbs including contents;

RBS2 RBS NEEDS RECOVERY

Instance terminated by SMON, pid = 2744

C:/>sqlplus “/ as sysdba”

SQL> startup restrict

SEGMENT_NAME TABLESPACE_NAME STATUS

Redo Buffers 77824 bytes

Wed Jan 10 08:41:39 2018

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

RBS2 RBS NEEDS RECOVERY

ORA-01109: 数据库未打开。

RBS1 RBS NEEDS RECOVERY

 图片 2

C:/>set nls_lang=american_america.zhs16gbk

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

With the Partitioning option

SYSTEM SYSTEM ONLINE

RBS0 RBS NEEDS RECOVERY

RBS5 RBS NEEDS RECOVERY

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

Wed Jan 10 08:41:37 2018

ERROR 在行 1:

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

 图片 3

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

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

*

 

强制删除所急需的回滚段

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

ERROR 在行 1:

 

连接到:


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

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

ORACLE例程已关闭。

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

服务器断电重启导致备份生产条件的回复目录库不可能进行运营,提醒Ora-01092例程终止。强行断开连接

常规关闭数据库,并将参数文件中的隐含参数_corrupted_rollback_segments注释,并将ROLLBACK_SE培洛霉素ENTS参加全体的回滚段。

 图片 4

RBS6 RBS NEEDS RECOVERY

数据库装载完结。

SQL> shutdown immediate

 

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

 

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

SQL> startup restrict mount

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

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

 

SYSTEM SYSTEM ONLINE

 

 

drop tablespace rbs including contents

Wed Jan 10 08:41:42 2018

SQL> startup restrict

Total System Global Area 219895052 bytes

 

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

去除包涵损坏回滚段表空间后,并开首另起炉灶回滚段表空间

RBS3 RBS NEEDS RECOVERY

 图片 5


[1844] Redo record seq number

 图片 6

SYSTEM SYSTEM ONLINE


不奇怪关闭数据库参预富含函数_corrupted_rollback_segments,修改参数文件参预富含参数

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

RBS2 RBS NEEDS RECOVERY

 

 

 图片 7


[1836] Undo record seq number

RBS3 RBS NEEDS RECOVERY

 

RBS0 RBS NEEDS RECOVERY

 

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

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

JServer Release 8.1.7.0.0 – Production

RBS0 RBS NEEDS RECOVERY

 

 

With the Partitioning option

RBS5 RBS NEEDS RECOVERY

 

 图片 8

 图片 9

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

将init.ora文件中的ROLLBACK_SE丙胺搏来霉素ENTS开首化参数设置注释后以Restricted形式MOUNT数据库。

翻看跟踪日志:


 图片 10

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

 

ORACLE例程已运转。

— 报错ORA-01548,申明有活动回滚段

SQL> shutdown immediate

SYSTEM SYSTEM ONLINE

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

Database Buffers 144629760 bytes

已选择8 行

鉴于UNDO类别和REDO连串不雷同引发错误。

 

 图片 11

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

RBS5 RBS NEEDS RECOVERY

好端端运营数据库

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

RBS4 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

 

 

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

*

删除包罗损坏回滚段表空间后,并开始建立回滚段表空间

Variable Size 75116544 bytes

询问回滚段状态

Wed Jan 10 08:41:37 2018

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

FILE# NAME

已经卸载数据库。

SEGMENT_NAME TABLESPACE_NAME STATUS

RBS2 RBS NEEDS RECOVERY

健康运转数据库

 

 

SQL> drop tablespace rbs including contents;

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

 图片 12

Wed Jan 10 08:41:42 2018

C:/>sqlplus “/ as sysdba”

SQL> drop tablespace rbs including contents;

查看跟踪日志:

 Oracle8i Enterprise Edition Release 8.1.7.0.0  – Production

RBS5 RBS NEEDS RECOVERY

SQL> drop tablespace rbs including contents;

例行关闭数据库,并将参数文件中的隐含参数_corrupted_rollback_segments注释,并将ROLLBACK_SE威斯他霉素ENTS加入全体的回滚段。

 

RBS1 RBS NEEDS RECOVERY

RBS1 RBS NEEDS RECOVERY

drop tablespace rbs including contents

JServer Release 8.1.7.0.0 – Production

 

ERROR 在行 1:

 

 

[1836] Undo record seq number

已选择 8 行


 图片 13

 图片 14

Total System Global Area 219895052 bytes

 

Instance terminated by SMON, pid = 2744

[1844] Redo record seq number

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

Variable Size 75116544 bytes

 图片 15

*

SQL> shutdown immediate

 Oracle8i Enterprise Edition Release 8.1.7.0.0  – Production

数据库装载实现。

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

ORACLE例程已运维。

 

RBS6 RBS NEEDS RECOVERY

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

连接到:

 

 

C:/>set nls_lang=american_america.zhs16gbk

已选择8 行

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

*

RBS0 RBS NEEDS RECOVERY

ORA-01109: 数据库未打开。

SMON: terminating instance due to error 600

 

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

Wed Jan 10 08:41:42 2018

由于UNDO种类和REDO体系不等同引发错误。

 

RBS6 RBS NEEDS RECOVERY

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

RBS1 RBS NEEDS RECOVERY

将init.ora文件中的ROLLBACK_SE放线菌壮观素ENTS开始化参数设置注释后以Restricted形式MOUNT数据库。

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

Redo Buffers 77824 bytes

 图片 16

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

RBS6 RBS NEEDS RECOVERY

相关文章