-
编辑 删除
Oracle Hang Analysis
Oracle Hang Analysis发表人:rainnyzhong | 发表时间: 2010年一月18日, 10:03Author: rainnyzhongDate:2010-1-151． 症状描述：FALB12从EXCEL IMPORT DATA到DB，预计事务会运行1个多小时，在开始操作后40分钟左右，ORACLE挂死，任何用户都不可以再登陆了。2． 分析（1） 下面是挂死时OS的资源状况：09:37:54 up 73 days, 23:31, 1 user, load average: 0.11, 0.24, 0.18194 processes: 191 sleeping, 3 running, 0 zombie, 0 stoppedCPU states: cpu user nice system irq softirq iowait idletotal 6.7% 0.0% 0.3% 0.3% 0.0% 1.9% 90.4%M
-
编辑 删除
虎年初十ORACLE数据库恢复案例
Author: RainnyDate: 2010-2-23虎年刚过，就接手了一个非常困难的ORACLE数据库恢复的CASE。数据库经历了不正常断电，STARTUP ORACLE时报：ORA-01172: recovery of thread 1 stuck at block 3859656 of file 6ORA-01151: use media recovery to recover block, restore backup if needed查看ALERTLOG，发现前面已经有几个错误了：ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], []Hex dump of (file 3, block 30968) in trace file /data/app/oracle/admin/ora33/bdump/ora33_p003_6219
