当前位置:Oracle研究中心 > 故障案例 >
时间:2016-06-29 13:20 来源:Oracle研究中心 作者:惜分飞 点击: 次
在处理的众多undo问题的数据库中,这个是第一例遇到因为undo出现坏块导致数据库自动down案例
Fri Jun 1 00:45:13 2012 Successfully onlined Undo Tablespace 1. Fri Jun 1 00:45:13 2012 SMON: enabling tx recovery Fri Jun 1 00:45:13 2012 Database Characterset is ZHS16GBK Fri Jun 1 00:45:13 2012 SMON: about to recover undo segment 52 SMON: about to recover undo segment 52 SMON: mark undo segment 52 as available SMON: Restarting fast_start parallel rollback SMON: about to recover undo segment 52 SMON: mark undo segment 52 as available SMON: ignoring slave err,downgrading to serial rollback SMON: about to recover undo segment 52 ORACLE Instance acc1 (pid = 9) - Error 1578 encountered while recovering transaction (52, 29). Fri Jun 1 00:45:14 2012 Errors in file /oraacc/app/admin/acc/bdump/acc1_smon_734734.trc: ORA-01578: ORACLE data block corrupted (file # 169, block # 55887) ORA-01110: data file 169: '/dev/raccount07_01lv' Fri Jun 1 00:45:15 2012 replication_dependency_tracking turned off (no async multimaster replication found) Completed: alter database open Fri Jun 1 00:45:16 2012 Errors in file /oraacc/app/admin/acc/bdump/acc1_pmon_766940.trc: ORA-00474: SMON process terminated with error Fri Jun 1 00:45:16 2012 PMON: terminating instance due to error 474 Instance terminated by PMON, pid = 766940
这里可以看出数据库因为回滚段52出现坏块导致回滚的时候smon终止,数据库down
$ dbv file='/dev/raccount07_01lv' blocksize=8192 DBVERIFY: Release 9.2.0.8.0 - Production on Fri Jun 1 01:25:10 2012 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. DBVERIFY - Verification starting : FILE = /dev/raccount07_01lv DBV-00200: Block, dba 708893135, already marked corrupted DBV-00200: Block, dba 708893151, already marked corrupted DBV-00200: Block, dba 708893263, already marked corrupted DBVERIFY - Verification complete Total Pages Examined : 1048320 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 0 Total Pages Failing (Index): 0 Total Pages Processed (Other): 1048320 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 0 Total Pages Marked Corrupt : 3 Total Pages Influx : 0 Highest block SCN : 12843497215383 (2990.1545000343)
SQL> select DBMS_UTILITY.data_block_address_file(708893135) file#, 2 DBMS_UTILITY.data_block_address_block(708893135) block# from dual; FILE# BLOCK# ---------- ---------- 169 55759 SQL> select DBMS_UTILITY.data_block_address_file(708893151) file#, 2 DBMS_UTILITY.data_block_address_block(708893151) block# from dual; FILE# BLOCK# ---------- ---------- 169 55775 SQL> select DBMS_UTILITY.data_block_address_file(708893263) file#, 2 DBMS_UTILITY.data_block_address_block(708893263) block# from dual; FILE# BLOCK# ---------- ---------- 169 55887
--隐含参数 _corrupted_rollback_segments= _SYSSMU52$ --open库后 alter session set "_smu_debug_mode"=4; drop rollback segment "_SYSSMU52$";
--------------------------------------ORACLE-DBA----------------------------------------
最权威、专业的Oracle案例资源汇总之【案例】Oracle报错ORA-01578 ORA-01110 处理undo文件坏块数据库宕掉案例
本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/623.html
Powered by Oracle研究中心 OraclePlus Inc.
BY DedeCMS 京ICP备14022373号-5
声明:Oracle研究中心部分文章源自互联网,转载均按原文作者要求转载,如有疑问联系QQ:1026002015,协商未果24小时删除。