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

服务器断电重启发引导致备份生产环境的上升目录库不能进行运营,提醒Ora-01092例程终止。强行断开连接

服务器断电重启发引导致备份生产条件的还原目录库不大概进展运转,提示Ora-01092例程终止。强行断开连接

查阅跟踪日志:

查看跟踪日志:

Wed Jan 10 08:41:37 2018

Wed Jan 10 08:41:37 2018

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

Errors in file d:\Oracle\皇冠现金app,admin\l3bckdb\bdump\l3bckdbSMON.TRC:

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

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

 

 

Wed Jan 10 08:41:39 2018

Wed Jan 10 08:41:39 2018

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

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

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

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

 

 

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

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

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

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

Wed Jan 10 08:41:42 2018

Wed Jan 10 08:41:42 2018

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

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

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

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

Wed Jan 10 08:41:42 2018

Wed Jan 10 08:41:42 2018

SMON: terminating instance due to error 600

SMON: terminating instance due to error 600

Instance terminated by SMON, pid = 2744

Instance terminated by SMON, pid = 2744

 皇冠现金app 1

 皇冠现金app 2

 

 

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

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

[1836] Undo record seq number

[1836] Undo record seq number

[1844] Redo record seq number

[1844] Redo record seq number

出于UNDO种类和REDO体系不平等引发错误。

鉴于UNDO系列和REDO类别不雷同引发错误。

消除办法:重建UNDO表空间,步骤如下:

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

C:/>set nls_lang=american_america.zhs16gbk

C:/>set nls_lang=american_america.zhs16gbk

C:/>sqlplus “/ as sysdba”

C:/>sqlplus “/ as sysdba”

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

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

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

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

 

 

连接到:

连接到:

 Oracle8i Enterprise Edition Release 8.1.7.0.0  – Production

 Oracle8i Enterprise Edition Release 8.1.7.0.0  – Production

With the Partitioning option

With the Partitioning option

JServer Release 8.1.7.0.0 – Production

JServer Release 8.1.7.0.0 – Production

 皇冠现金app 3

 皇冠现金app 4

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

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

FILE# NAME

FILE# NAME



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

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

SQL> shutdown immediate

SQL> shutdown immediate

ORA-01109: 数据库未打开。

ORA-01109: 数据库未打开。

 

 

曾经卸载数据库。

业已卸载数据库。

ORACLE例程已关门。

ORACLE例程已关闭。

 

 

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

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

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

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

SQL> startup restrict mount

SQL> startup restrict mount

ORACLE例程已开发银行。

ORACLE例程已开行。

Total System Global Area 219895052 bytes

Total System Global Area 219895052 bytes

Fixed Size 70924 bytes

Fixed Size 70924 bytes

Variable Size 75116544 bytes

Variable Size 75116544 bytes

Database Buffers 144629760 bytes

Database Buffers 144629760 bytes

Redo Buffers 77824 bytes

Redo Buffers 77824 bytes

数据库装载完毕。

数据库装载实现。

 

 

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

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

 皇冠现金app 5

 皇冠现金app 6

 

 

 

 

 

 

SQL> drop tablespace rbs including contents;

SQL> drop tablespace rbs including contents;

drop tablespace rbs including contents

drop tablespace rbs including contents

*

*

ERROR 在行 1:

ERROR 在行 1:

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

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

— 报错ORA-01548,注脚有活动回滚段

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

 

 

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

SEGMENT_NAME TABLESPACE_NAME STATUS

SEGMENT_NAME TABLESPACE_NAME STATUS





SYSTEM SYSTEM ONLINE

SYSTEM SYSTEM ONLINE

RBS0 RBS NEEDS RECOVERY

RBS0 RBS NEEDS RECOVERY

RBS1 RBS NEEDS RECOVERY

RBS1 RBS NEEDS RECOVERY

RBS2 RBS NEEDS RECOVERY

RBS2 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

RBS4 RBS NEEDS RECOVERY

RBS4 RBS NEEDS RECOVERY

RBS5 RBS NEEDS RECOVERY

RBS5 RBS NEEDS RECOVERY

RBS6 RBS NEEDS RECOVERY

RBS6 RBS NEEDS RECOVERY

已选择8 行

已选择8 行

SQL> shutdown immediate

SQL> shutdown immediate


平常关闭数据库参加富含函数_corrupted_rollback_segments,修改参数文件参与富含参数


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

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

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

SQL> startup restrict

SQL> startup restrict

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

SQL> select segment_name,tablespace_name,status from
dba_rollback_segs;

SEGMENT_NAME TABLESPACE_NAME STATUS

SEGMENT_NAME TABLESPACE_NAME STATUS





SYSTEM SYSTEM ONLINE

SYSTEM SYSTEM ONLINE

RBS0 RBS NEEDS RECOVERY

RBS0 RBS NEEDS RECOVERY

RBS1 RBS NEEDS RECOVERY

RBS1 RBS NEEDS RECOVERY

RBS2 RBS NEEDS RECOVERY

RBS2 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

RBS4 RBS NEEDS RECOVERY

RBS4 RBS NEEDS RECOVERY

RBS5 RBS NEEDS RECOVERY

RBS5 RBS NEEDS RECOVERY

RBS6 RBS NEEDS RECOVERY

RBS6 RBS NEEDS RECOVERY

已选择 8 行

已选择 8 行

SQL> drop tablespace rbs including contents;

SQL> drop tablespace rbs including contents;

drop tablespace rbs including contents

drop tablespace rbs including contents

*

*

ERROR 在行 1:

ERROR 在行 1:

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

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

强制删除所急需的回滚段

强制删除所急需的回滚段

 皇冠现金app 7

 皇冠现金app 8

 

 

 

 

剔除包涵损坏回滚段表空间后,并初叶建立回滚段表空间

删去包罗损坏回滚段表空间后,并开头另起炉灶回滚段表空间

 皇冠现金app 9

 皇冠现金app 10

 

 

 

 

询问回滚段状态

询问回滚段状态

 皇冠现金app 11

 皇冠现金app 12

 

 

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

例行关闭数据库,并将参数文件中的隐含参数_corrupted_rollback_segments注释,并将ROLLBACK_SEGMENTS参预全数的回滚段。

 皇冠现金app 13

 皇冠现金app 14

 

 

常规运行数据库

例行运转数据库

 皇冠现金app 15

 皇冠现金app 16