数据库打不开了

[复制链接]
查看11 | 回复9 | 2010-3-1 11:08:29 | 显示全部楼层 |阅读模式
1.alert_oracle01.log
Fri Jul 15 09:19:13 2011
alter database open
2.10046 trace
PARSING IN CURSOR #1 len=20 dep=0 uid=0 oct=35 lid=0 tim=1996856932 hv=1361353028 ad='33ecfc5c'
alter database open
END OF STMT
PARSE #1:c=0,e=55194,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=1996856924
BINDS #1:
WAIT #1: nam='enq: IS - contention' ela= 2999928 name|mode=1230176262 0=0 type=1 obj#=-1 tim=1999862398
WAIT #1: nam='enq: IS - contention' ela= 3000194 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2002886571
WAIT #1: nam='enq: IS - contention' ela= 3000147 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2005887755
*** 2011-07-15 09:19:25.797
WAIT #1: nam='enq: IS - contention' ela= 3000175 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2008888928
WAIT #1: nam='enq: IS - contention' ela= 2999845 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2011890945
WAIT #1: nam='enq: IS - contention' ela= 2999919 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2014892245
WAIT #1: nam='enq: IS - contention' ela= 3000160 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2017893430
*** 2011-07-15 09:19:37.803
WAIT #1: nam='enq: IS - contention' ela= 3000097 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2020894541
WAIT #1: nam='enq: IS - contention' ela= 2999605 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2023895772
WAIT #1: nam='enq: IS - contention' ela= 3000207 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2026896973
WAIT #1: nam='enq: IS - contention' ela= 3000061 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2029898088
*** 2011-07-15 09:19:49.806
WAIT #1: nam='enq: IS - contention' ela= 2999260 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2032898062
WAIT #1: nam='enq: IS - contention' ela= 2999582 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2035899453
WAIT #1: nam='enq: IS - contention' ela= 3000204 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2038900628
WAIT #1: nam='enq: IS - contention' ela= 2999892 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2041901560
*** 2011-07-15 09:20:01.810
WAIT #1: nam='enq: IS - contention' ela= 2999756 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2044901965
WAIT #1: nam='enq: IS - contention' ela= 2999542 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2047903157
WAIT #1: nam='enq: IS - contention' ela= 2999925 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2050904083
WAIT #1: nam='enq: IS - contention' ela= 2999642 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2053904482
*** 2011-07-15 09:20:13.814
WAIT #1: nam='enq: IS - contention' ela= 3000183 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2056905665
WAIT #1: nam='enq: IS - contention' ela= 3000285 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2059907826
WAIT #1: nam='enq: IS - contention' ela= 3000156 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2062909018
WAIT #1: nam='enq: IS - contention' ela= 3000022 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2065910157
*** 2011-07-15 09:20:25.819
WAIT #1: nam='enq: IS - contention' ela= 3000214 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2068911352
WAIT #1: nam='enq: IS - contention' ela= 2999477 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2071912524
WAIT #1: nam='enq: IS - contention' ela= 3000146 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2074913702
WAIT #1: nam='enq: IS - contention' ela= 3000164 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2077914861
*** 2011-07-15 09:20:37.824
WAIT #1: nam='enq: IS - contention' ela= 3000178 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2080916047
WAIT #1: nam='enq: IS - contention' ela= 3000384 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2083918201
WAIT #1: nam='enq: IS - contention' ela= 3000338 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2086919546
WAIT #1: nam='enq: IS - contention' ela= 2999986 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2089920553
*** 2011-07-15 09:20:49.830
WAIT #1: nam='enq: IS - contention' ela= 3000166 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2092921723
WAIT #1: nam='enq: IS - contention' ela= 2999505 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2095922956
WAIT #1: nam='enq: IS - contention' ela= 3000009 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2098924065
WAIT #1: nam='enq: IS - contention' ela= 3000119 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2101925221
*** 2011-07-15 09:21:01.834
WAIT #1: nam='enq: IS - contention' ela= 3000152 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2104926396
WAIT #1: nam='enq: IS - contention' ela= 2999497 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2107927574
WAIT #1: nam='enq: IS - contention' ela= 3000191 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2110928753
WAIT #1: nam='enq: IS - contention' ela= 3000144 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2113929927
*** 2011-07-15 09:21:13.839
WAIT #1: nam='enq: IS - contention' ela= 3000166 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2116931096
WAIT #1: nam='enq: IS - contention' ela= 2999473 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2119932250
WAIT #1: nam='enq: IS - contention' ela= 3000182 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2122933446
WAIT #1: nam='enq: IS - contention' ela= 3000118 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2125934617
*** 2011-07-15 09:21:25.844
WAIT #1: nam='enq: IS - contention' ela= 3000145 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2128935787
WAIT #1: nam='enq: IS - contention' ela= 3000353 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2131937960
WAIT #1: nam='enq: IS - contention' ela= 3000309 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2134939307
WAIT #1: nam='enq: IS - contention' ela= 3000011 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2137940318
*** 2011-07-15 09:21:37.850
WAIT #1: nam='enq: IS - contention' ela= 2999922 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2140941251
WAIT #1: nam='enq: IS - contention' ela= 2999600 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2143942427
WAIT #1: nam='enq: IS - contention' ela= 2999410 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2146942735
WAIT #1: nam='enq: IS - contention' ela= 3000307 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2149943981
*** 2011-07-15 09:21:49.853
WAIT #1: nam='enq: IS - contention' ela= 3000141 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2152945117
WAIT #1: nam='enq: IS - contention' ela= 3000139 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2155947130
WAIT #1: nam='enq: IS - contention' ela= 3000234 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2158948488
WAIT #1: nam='enq: IS - contention' ela= 3000205 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2161949704
回复

使用道具 举报

千问 | 2010-3-1 11:08:29 | 显示全部楼层
WAIT是关键,帮顶~~
回复

使用道具 举报

千问 | 2010-3-1 11:08:29 | 显示全部楼层
你把alert.log贴全一些
回复

使用道具 举报

千问 | 2010-3-1 11:08:29 | 显示全部楼层
IS: Instance State
没遇到过这个ENQ。。好像和实例的状态有关。
METALINK去查一下
回复

使用道具 举报

千问 | 2010-3-1 11:08:29 | 显示全部楼层
看不出来!一大早的数据库就起不来了?悲剧的星期五
回复

使用道具 举报

千问 | 2010-3-1 11:08:29 | 显示全部楼层
数据库在Open阶段被阻塞,无法完成从Mount 到 Open 的instance state change.
你的10046 Level不够,用level 12,再给我看看跟踪文件,完整的.
回复

使用道具 举报

千问 | 2010-3-1 11:08:29 | 显示全部楼层
关注一下
回复

使用道具 举报

千问 | 2010-3-1 11:08:29 | 显示全部楼层
已经是level 12了,
回复

使用道具 举报

千问 | 2010-3-1 11:08:29 | 显示全部楼层
把alert 和 10046 的文件都发上来.
回复

使用道具 举报

千问 | 2010-3-1 11:08:29 | 显示全部楼层
老大出现!
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行