我申请这个blog是为了督促自己，把自己平时的一些想法和思考结果保留下来。 本博客所有内容均为原创，如有转载请注明作者和出处

ORA-7445(krdsodrf)错误

上一篇 / 下一篇  2008-04-27 23:58:23 / 个人分类：Bug

查看( 209 ) / 评论( 1 ) / 评分( 5 / 0 )

协助别人解决问题时，在一个9201的数据库服务器上的alert文件中发现了这个错误。

 

 

错误信息如下：

Errors in file /oracle/admin/orcl/udump/orcl_ora_18127.trc:ITPUB个人空间 C'E f#x1V"@C
ORA-07445:出现异常:核心转储[krdsodrf()+16] [SIGSEGV] [Address not mapped to object] [0x50] [] []

检查对应的trace文件，却发现没有产生对应的trace文件。根据metalink上查询的结果，感觉和Doc ID: Note:362286.1的描述比较接近，这个应该是Oracle的一个bug。不过根据给出的文档的描述，这个错误发生在数据文件的恢复过程中，为了可以正确的执行恢复操作，需要通过重建控制文件来解决。不过从alert文件中的信息来分析，这里没有重建控制文件，也成功的恢复了控制文件。

下面还是看看alert文件中的记录，这个错误是怎么产生和消失的。

Fri Mar  7 14:14:36 2008
4rY$t5E7`{|p4lf3XK0/* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" OFFLINE NORMAL
e2T Xc/r:|6b0Fri Mar  7 14:14:37 2008ITPUB个人空间 rO` pU.P(E2{
Completed: /* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" OFFLITPUB个人空间"ZfXr~ d b
Fri Mar  7 14:15:11 2008
9^:` v2sV6V_(`*T&Pg0/* OracleOEM */ ALTER DATABASE RENAME FILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' TO '/data1/oracledata/NNC_DATA011.dbf'ITPUB个人空间i TL&^Ax%zVe fq
Fri Mar  7 14:15:11 2008
0eMg_Q$_]w0Completed: /* OracleOEM */ ALTER DATABASE RENAME FILE '/oracl

从上面的内容已经可以看出，用户在OEM对数据库进行管理操作，目标是将表空间NNC_DATA01的数据文件迁移到一个新的存储位置。

Fri Mar  7 14:15:15 2008ITPUB个人空间,TS I/oU
/* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLINEITPUB个人空间!~A&N,AF
ORA-1122 signalled during: /* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLI...
O@n5o xr[ H#v0Fri Mar  7 14:17:30 2008ITPUB个人空间D#F;`Rro AG
/* OracleOEM */ ALTER DATABASE DATAFILE '/data1/oracledata/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间hu D6F!i)WGmS
Fri Mar  7 14:17:30 2008ITPUB个人空间-y%o6\aW3q
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/data1/or...
?1AS Eb;{ O0Fri Mar  7 14:17:58 2008ITPUB个人空间8b/f*V+CSl_8J
/* OracleOEM */ ALTER DATABASE RENAME FILE '/data1/oracledata/NNC_DATA011.dbf' TO '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'ITPUB个人空间-IZ)V-{"s&xtK&P
Fri Mar  7 14:17:59 2008ITPUB个人空间"rS8A|*no@EF
Completed: /* OracleOEM */ ALTER DATABASE RENAME FILE '/data1ITPUB个人空间,_3K,H9f0D`+bL JM+V
Fri Mar  7 14:17:59 2008
6R6g9e,}J+AH"\0/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000M
8S `:Ji o0ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间J+@*^.u4I%b'}3MY
Fri Mar  7 14:18:18 2008
"jYBu m*r vF!S0/* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLINE
8hL ~1}5b5cJm&l0Fri Mar  7 14:18:18 2008
2J+t h(zT1\&t5p0Completed: /* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLI
']q'BR` LUiH0l0Fri Mar  7 14:18:18 2008ITPUB个人空间'zYTI'R$?:S
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间 B8W+` ~ ]*wb
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a

这里可以看到，用户试图将表空间置于ONLINE状态，但是怀疑由于用户并没有手工将数据文件拷贝到目标位置，因此这里报错ORA-1122，而后用户试图在OFFLINE的情况下，修改数据文件的大小，因此报错ORA-376，最后用户将数据文件重命名为原来的名称，修改为ONLINE状态，并最终修改了文件的大小。

其实从上面的一系列步骤可以看出，执行上面一系列操作的用户，对Oracle数据文件的一系列基本操作并不了解。

Fri Mar  7 14:23:46 2008ITPUB个人空间1`4P5FC!z g S
/* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" OFFLINE NORMAL
Z G(p"i&Z s4q0Completed: /* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" OFFL
?5]LAl-\7v"z0Fri Mar  7 14:24:03 2008ITPUB个人空间(~_ k5m5`3Dl.g
/* OracleOEM */ ALTER DATABASE RENAME FILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' TO '/data1/oracledata/NNC_DATA011.dbf'ITPUB个人空间Iys/pi5uF.i'|$TU
Fri Mar  7 14:24:03 2008ITPUB个人空间x3i r NX r
Completed: /* OracleOEM */ ALTER DATABASE RENAME FILE '/oraclITPUB个人空间O!R)I,DG1P
Fri Mar  7 14:24:03 2008ITPUB个人空间4V N@3ur4UFi
/* OracleOEM */ ALTER DATABASE DATAFILE '/data1/oracledata/NNC_DATA011.dbf' RESIZE 1000M
*H I'@G5{E4u0ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/data1/or...
:i W)i3RV?.ON4_0Fri Mar  7 14:24:22 2008
wZ!\u H"|0/* OracleOEM */ ALTER DATABASE DATAFILE '/data1/oracledata/NNC_DATA011.dbf' ONLINE
r7|KBM;o#A0Fri Mar  7 14:24:22 2008ITPUB个人空间+k${3?e#h!V\e g
ORA-1113 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/data1/or...ITPUB个人空间.Mi#_GZ9Y%O
Fri Mar  7 14:24:38 2008ITPUB个人空间6Z btz8b(va
/* OracleOEM */ ALTER DATABASE RENAME FILE '/data1/oracledata/NNC_DATA011.dbf' TO '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'ITPUB个人空间C/Fd K u%oc
Fri Mar  7 14:24:38 2008ITPUB个人空间6A$n }9Zv8I4~j
Completed: /* OracleOEM */ ALTER DATABASE RENAME FILE '/data1ITPUB个人空间%ccv~!~U+M
Fri Mar  7 14:24:38 2008ITPUB个人空间Pk!j:z8XwtMTA]
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间|P2dq4m_)Z
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...
Q$Wh@9q;Br[3n0Fri Mar  7 14:24:47 2008ITPUB个人空间 ZX7c'k-K;[*T
/* OracleOEM */ ALTER DATABASE RENAME FILE '/data1/oracledata/NNC_DATA011.dbf' TO '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'ITPUB个人空间r \Gj o7a4B3h]K q
ORA-1511 signalled during: /* OracleOEM */ ALTER DATABASE RENAME FILE '/data1...ITPUB个人空间^/oeD&OW,n
Fri Mar  7 14:25:01 2008ITPUB个人空间/s#^.dM!kh
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' ONLINE
(YzBV ^&F0Fri Mar  7 14:25:01 2008
`N-ac"Z2Yt+|0Completed: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a
hH6V|hz%D,~p0Fri Mar  7 14:25:02 2008ITPUB个人空间g(u6u4Og/e;N+L
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间(xx'^]i;M]
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间IXTB4yH.u9I3`l-si6C
Fri Mar  7 14:25:06 2008ITPUB个人空间2{4F-M'wUQ8dbo
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' ONLINE
4\6I6c0cC0Completed: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a
2i4@kEu$p0F ~0Fri Mar  7 14:25:06 2008ITPUB个人空间 T2Nu b`&k3`H)T2_
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间4z9{,r/Qp
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间+C2b"L9MW|to7U
Fri Mar  7 14:25:46 2008
Y/^J4~XV3^Gq0/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' OFFLINE
}7i/e']1tw l!|9k&B0Completed: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/aITPUB个人空间m$v{/` Zo J^2o;O
Fri Mar  7 14:25:46 2008ITPUB个人空间Y0s~ y;i"A Cy!^.v/[
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000M
#|p"pVn\D0ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...
d%Mf8a)o7M0Fri Mar  7 14:26:37 2008ITPUB个人空间|a1ky$kVB:W
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' ONLINE
Tc'K0p Q2Sim h(x,{0Fri Mar  7 14:26:37 2008
4sVZu.z0ORA-1113 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...
"tk%nXv&Mi0Fri Mar  7 14:28:06 2008
2{ Ny[?#aG0/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间mv8\ c9gR5[
Fri Mar  7 14:28:06 2008ITPUB个人空间m4Z%Ldv{c8y
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间K TYAbCk
Fri Mar  7 14:28:14 2008ITPUB个人空间0` BCYN[(pT:{
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' ONLINEITPUB个人空间zC7A`fX9c;vp
Fri Mar  7 14:28:14 2008
"c(?#u3Dm0Errors in file /oracle/admin/orcl/bdump/orcl_dbw0_16176.trc:ITPUB个人空间eKSZvfG cj @
ORA-01157: cannot identify/lock data file 10 - see DBWR trace fileITPUB个人空间?V V4C`Gm'~ S
ORA-01110: data file 10: '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'
`hHq&U0ORA-27041: unable to open fileITPUB个人空间I&dyx@ p3e-D
SVR4 Error: 13: Permission deniedITPUB个人空间tn.jIU
Additional information: 2ITPUB个人空间Fsa1~~)Qy x
ORA-1157 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间g7S O`0E%PH
Fri Mar  7 14:28:30 2008ITPUB个人空间4tZR!Z)l]5b&RM`4R
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' ONLINE
t&{/W-\s%Q)Er:N0Fri Mar  7 14:28:30 2008ITPUB个人空间p7t}z R"O/l7T(q9K$KUU
Errors in file /oracle/admin/orcl/bdump/orcl_dbw0_16176.trc:
'H T)} ]$y4]0ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
:M(ei s:K1p0ORA-01110: data file 10: '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'
)n'Y!NM/q`6g[0ORA-27041: unable to open fileITPUB个人空间Na*BZV-q
SVR4 Error: 13: Permission denied
X8C9z3ufKd|0Additional information: 2ITPUB个人空间[(d h3bHJ
ORA-1157 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...

从上面的一系列操作可以看到，由于用户对于Oracle文件操作的不理解，因此重复了多次类似的错误操作，终于在后来导致了ORA-1157错误的方式，这时Oracle已经无法读取表空间NNC_DATA11的数据文件了。

Fri Mar  7 14:30:21 2008ITPUB个人空间E8pZqo
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间w{n v*e
Fri Mar  7 14:30:21 2008ITPUB个人空间-a%q.}6j&t-n)v(M,V
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间I8Z8HR-lpL.HYx
Fri Mar  7 14:30:57 2008
qw&e1^1g B0/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000M
%o3km$gwu4wE0Fri Mar  7 14:30:57 2008ITPUB个人空间6T `1|cYV8A
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间3j1c,CJy0]s#rH6r
Fri Mar  7 14:31:53 2008
kp A(VOI1]N0/* OracleOEM */ ALTER DATABASE RENAME FILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' TO '/data1/oracledata/NNC_DATA011.dbf'
*s2B${` HAp0Fri Mar  7 14:31:53 2008
h+m@DkH2e:Yw0Completed: /* OracleOEM */ ALTER DATABASE RENAME FILE '/oracl
E1s` C9E0Fri Mar  7 14:31:54 2008ITPUB个人空间g_f;V_-FnXK
/* OracleOEM */ ALTER DATABASE DATAFILE '/data1/oracledata/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间^^-j }HS'C
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/data1/or...ITPUB个人空间c!w eN7jTm g!p9?
Fri Mar  7 14:32:25 2008ITPUB个人空间'PjMT"^"S6i,P
Shutting down instance: further logons disabled
a ]P4DY$Th0Shutting down instance (immediate)
,e(F#brv.htA~0License high water mark = 34
f4H V0G0q&T"u0Fri Mar  7 14:32:32 2008
7\J CH!y&z:~"^ L0ALTER DATABASE CLOSE NORMAL
4H \|)q tH0Fri Mar  7 14:32:32 2008
XIJ.T6i0CW9x$xHV W0SMON: disabling tx recovery
7|s$h:i'\HoEw0SMON: disabling cache recovery
4m#wa9[+A{$Pl+t,k-b0Fri Mar  7 14:32:32 2008ITPUB个人空间 l pDQ m0eN#RwME
Shutting down archive processes
\ L@p!A rn7@[0Archiving is disabledITPUB个人空间(v@oVSP v
Archive process shutdown avoided: 0 active
(MS}(o{3Vf0Thread 1 closed at log sequence 930
b/S bo*|Yf0Successful close of redo thread 1.ITPUB个人空间*} {,H$mo6J Hx J ` I:dK
Fri Mar  7 14:32:33 2008ITPUB个人空间3Qlu4mQ ` O
Completed: ALTER DATABASE CLOSE NORMAL
$s@8g:FbNaX&e0Fri Mar  7 14:32:33 2008
@+Aj"ud{ p&l0ALTER DATABASE DISMOUNTITPUB个人空间}`u~ \wm0~t
Completed: ALTER DATABASE DISMOUNTITPUB个人空间#K)d&Uzz3Hi
ARCH: Archiving is disabled
z/Jf)o"o{&L)Q @ }0Shutting down archive processesITPUB个人空间6W,o"y)@{!Nyg_
Archiving is disabledITPUB个人空间` @o9iz$f$i
Archive process shutdown avoided: 0 activeITPUB个人空间4K`0\%p!O7H+A6J
ARCH: Archiving is disabled
\%RA ldJH0Shutting down archive processesITPUB个人空间p8a+pe9Y+X[^H
Archiving is disabledITPUB个人空间D+l,@U{
Archive process shutdown avoided: 0 active
!Q8d oO~0Fri Mar  7 14:32:54 2008
\+YIDMw0Q)K0Starting ORACLE instance (normal)
v;eSNm0LICENSE_MAX_SESSION = 0ITPUB个人空间q A-n}1IuKN$a
LICENSE_SESSIONS_WARNING = 0
jl&V6a k0SCN scheme 2
)~ Fy,U7PmtrlV0Using log_archive_dest parameter default value
L5CmL.sy!|$Y0LICENSE_MAX_USERS = 0
Rp3O g#Mqcg0n\v0SYS auditing is disabled
?7P g"SW(|_ ]2Dp0Starting up ORACLE RDBMS Version: 9.2.0.1.0.ITPUB个人空间 Vg#spQ'|0I/X
System parameters with non-default values:
@b4sK9D:ur]0  processes                = 1000
8Pi3G"I c:dm0  timed_statistics         = TRUE
c,@ QU0N,B%L1Z0.ITPUB个人空间6C wKMg
.
/^E i ~ Up0.ITPUB个人空间z z DiHk'j
  query_rewrite_enabled    = FALSEITPUB个人空间@c w-DW
  pga_aggregate_target     = 1073741824
/u3_dj?(J'E e `zz0PMON started with pid=2
0px\.C]0DBW0 started with pid=3
$O;bBa:Ta4K.TZ@E0DBW1 started with pid=4ITPUB个人空间/G _s0E[
LGWR started with pid=5ITPUB个人空间x*HLl1?
CKPT started with pid=6ITPUB个人空间V:aD9b5{E
SMON started with pid=7ITPUB个人空间I(N oR[Il5X
RECO started with pid=8ITPUB个人空间Whu:oev&h8H-c
CJQ0 started with pid=9
:A4\%\'p9Q H-Et0Fri Mar  7 14:32:56 2008
*Su9a Q dsFw"z a0ALTER DATABASE   MOUNTITPUB个人空间&U2IF$JM&^ A
Fri Mar  7 14:33:00 2008
+~Y+m#QXm]0Successful mount of redo thread 1, with mount id 1176534552.ITPUB个人空间{sA+o}3MjSY L
Fri Mar  7 14:33:00 2008
+{fe X3^l ?Ql+{0Database mounted in Exclusive Mode.ITPUB个人空间] c |T o+G].B,x$\+v
Completed: ALTER DATABASE   MOUNTITPUB个人空间B EWf|;C(Mf
Fri Mar  7 14:33:00 2008ITPUB个人空间b7FsP)`8l3Y)|Y
ALTER DATABASE OPENITPUB个人空间*wo3K2~*L^
Fri Mar  7 14:33:00 2008
bG,kL[d0Thread 1 opened at log sequence 930
]FQ1ke3`t0  Current log# 1 seq# 930 mem# 0: /oracle/app/product/9.2.0/oradata/orcl/redo01.log
QBcRjc0Successful open of redo thread 1.
e&C)u2g+@$},z Ln@(W0Fri Mar  7 14:33:00 2008
x~$ZP!~G%A$b-@0SMON: enabling cache recoveryITPUB个人空间R,~ f*b;\@ yyg4J
Fri Mar  7 14:33:01 2008
$Vb!{j!u0Undo Segment 1 OnlinedITPUB个人空间QiB I @r3i cE
Undo Segment 2 Onlined
4}%Yf5F?'Cw6[{:_0Undo Segment 3 Onlined
e/Z(XLu0H%u5O0Undo Segment 4 OnlinedITPUB个人空间5S j7U8_Hw lf8[
Undo Segment 5 OnlinedITPUB个人空间1x)}f*o f~1l$uU^
Undo Segment 6 OnlinedITPUB个人空间g/b*^s7N3YmW
Undo Segment 7 Onlined
.K:P[i4L3t0Undo Segment 8 OnlinedITPUB个人空间T\@meu$} P;y'{#Y
Undo Segment 9 Onlined
0Z"l`w6X4?0Undo Segment 10 Onlined
.X8q3y#W&bp#w0Successfully onlined Undo Tablespace 1.
1F&Vn*_|0Fri Mar  7 14:33:01 2008ITPUB个人空间'|.r vA_9B0K:T?j#|
SMON: enabling tx recoveryITPUB个人空间LW+\HC.]
Fri Mar  7 14:33:01 2008ITPUB个人空间*c*Kb;|.X(XJ
Database Characterset is ZHS16GBK
"[? Xs;xBD0replication_dependency_tracking turned off (no async multimaster replication found)
8Nbs"H(X9q,Qy%[0Completed: ALTER DATABASE OPENITPUB个人空间o j@ e!tMs
Fri Mar  7 14:33:31 2008ITPUB个人空间r B[C8_,TH.R
Starting ORACLE instance (normal)

用户在继续尝试错误的操作后，重启了数据库。

Fri Mar  7 14:34:31 2008
\9f @.Qs0/* OracleOEM */ ALTER DATABASE DATAFILE '/data1/oracledata/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间%kh? un;?q
Fri Mar  7 14:34:31 2008ITPUB个人空间:Zv%sX*\?s
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/data1/or...ITPUB个人空间W Th,f*yPzOL
Fri Mar  7 14:34:51 2008ITPUB个人空间$qAQA;]z6s
/* OracleOEM */ ALTER DATABASE DATAFILE '/data1/oracledata/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间6e5~m:TK7_-J7Es,]3S
Fri Mar  7 14:34:51 2008
\9OW;W t#Y"B5w8Fh0ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/data1/or...
#a!e a+c8L } N3h0Fri Mar  7 14:35:15 2008
'iG0k B F1R0/* OracleOEM */ ALTER DATABASE RENAME FILE '/data1/oracledata/NNC_DATA011.dbf' TO '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'ITPUB个人空间J X4t|b/d
Fri Mar  7 14:35:15 2008
F'q#z FLvg)n0Completed: /* OracleOEM */ ALTER DATABASE RENAME FILE '/data1
1mp/I4MM(gS xv0Fri Mar  7 14:35:15 2008ITPUB个人空间9@3[4TM;J#P'Y
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间0yGQ#GwW*~x
ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间(T#_Z;Nl:E
Fri Mar  7 14:35:18 2008
WhUV-]9n Z'p"|'lj0/* OracleOEM */ ALTER DATABASE RENAME FILE '/data1/oracledata/NNC_DATA011.dbf' TO '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'ITPUB个人空间5\ NRf1Hn
ORA-1511 signalled during: /* OracleOEM */ ALTER DATABASE RENAME FILE '/data1...
G)jKQq am0Fri Mar  7 14:35:20 2008ITPUB个人空间.V,` ?7XKf
/* OracleOEM */ ALTER DATABASE RENAME FILE '/data1/oracledata/NNC_DATA011.dbf' TO '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'ITPUB个人空间K:Nll,U5lt~O
ORA-1511 signalled during: /* OracleOEM */ ALTER DATABASE RENAME FILE '/data1...ITPUB个人空间@*PxB{n"k
Fri Mar  7 14:42:54 2008ITPUB个人空间)c%A5Ugxv8D
ALTER DATABASE RECOVER  tablespace nnc_data01 ITPUB个人空间:g^`n:E C6Y @m8D
Fri Mar  7 14:42:54 2008ITPUB个人空间 k A0Q {s'L+t/z&F
Media Recovery Tablespace: NNC_DATA01
wvUy|0Media Recovery StartITPUB个人空间&mR-ZV"dj.|t
Starting datafile 10 recovery in thread 1 sequence 930
9M'K m3}@0Datafile 10: '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'
$?]`PU[n0Media Recovery LogITPUB个人空间tr;r#FH
Recovery of Online Redo Log: Thread 1 Group 1 Seq 930 Reading mem 0
s_f"lW8S vS0  Mem# 0 errs 0: /oracle/app/product/9.2.0/oradata/orcl/redo01.logITPUB个人空间[ _ k p c*MW a
Media Recovery CompleteITPUB个人空间w5d/zq/Kj\
Completed: ALTER DATABASE RECOVER  tablespace nnc_data01 ITPUB个人空间Ck#_7P2v`E jy2a&?
Fri Mar  7 14:44:19 2008
a2x&\ G"g _ bQ0ALTER DATABASE RECOVER  datafile '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' 
Qv7CT3f0Fri Mar  7 14:44:19 2008ITPUB个人空间c dfS:D*Us0d
Media Recovery Datafile: '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'ITPUB个人空间 })K!X4gg6e1S+G&KOM/s
Media Recovery Start
@8\#b q,{J v5s0Starting datafile 10 recovery in thread 1 sequence 930ITPUB个人空间+w wM,s2}*l&^
Datafile 10: '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'ITPUB个人空间t-u Z'Y^ ] i
Media Recovery LogITPUB个人空间*BL#~HBm8y2K[5u^
Fri Mar  7 14:44:19 2008
!_(C5^DC8vg0Errors in file /oracle/admin/orcl/udump/orcl_ora_17783.trc:
,@/C^7p4Bp*u0ORA-07445:出现异常:核心转储[krdsodrf()+16] [SIGSEGV] [Address not mapped to object] [0x50] [] []

用户在继续的重复错误，直到最后，用户开始尝试恢复表空间和数据文件。在表空间恢复成功后，用户又尝试单独恢复数据文件，并最终引发了错误。

从上面的所有操作可以推断，执行这一系列操作的用户，对数据库缺乏基本的了解。而bug的产生也是由于用户大量错误操作过程中所导致的偶然现象。

Fri Mar  7 14:45:06 2008ITPUB个人空间4_9K5{(i0CA;G`
/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000M
k+sE#Z2Jr R&H?#XN o0Fri Mar  7 14:45:06 2008
2^2B'a'B"e@2Y D[0ORA-376 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间6pX)Ncg
Fri Mar  7 14:47:55 2008
*`:@ Rc*U(A v0/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' ONLINEITPUB个人空间 ?#Z&l0ZG
Fri Mar  7 14:47:55 2008ITPUB个人空间Y%](H0J+Ro4~B
ORA-1113 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...
*}2c3u8DvIG\0Fri Mar  7 14:48:13 2008ITPUB个人空间CcGXdh
ALTER DATABASE RECOVER  tablespace nnc_data01 
:r? kN TrF5V6T0Fri Mar  7 14:48:13 2008ITPUB个人空间^2_ LvI7TP|5ti
Media Recovery Tablespace: NNC_DATA01ITPUB个人空间G0P?h2x1q
Media Recovery Start
Z!wjKbUi a1O0Starting datafile 10 recovery in thread 1 sequence 930ITPUB个人空间GJO g\"Dt
Datafile 10: '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'ITPUB个人空间y4i&Ytk ^LP3R b
Media Recovery LogITPUB个人空间)],g HJZ:}_U/r6V
Fri Mar  7 14:48:13 2008ITPUB个人空间KfXEuw
Errors in file /oracle/admin/orcl/udump/orcl_ora_17951.trc:ITPUB个人空间.[#r y/\ _Ew,qu
ORA-07445:出现异常:核心转储[krdsodrf()+16] [SIGSEGV] [Address not mapped to object] [0x50] [] []
.BU\B x[ex~0Fri Mar  7 14:50:05 2008
r+_j.oSX8]-Nl"c$t#a0/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' ONLINE
'Y-Ln.M'`"d0Fri Mar  7 14:50:50 2008
4Y-o {3I6K!v0ORA-1113 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a...ITPUB个人空间X/zoaL/|rZ
Fri Mar  7 14:51:44 2008ITPUB个人空间5l}6_Y7e!Z%Y%v
alter tablespace nnc_data01 offline
O!HA{1R0Fri Mar  7 14:51:44 2008ITPUB个人空间/sjO;j^ R3f Cnv/L
ORA-1539 signalled during: alter tablespace nnc_data01 offline...ITPUB个人空间/Cu*IT2uSW0g2dS}
Fri Mar  7 14:52:46 2008ITPUB个人空间!f9}GN-[
ALTER DATABASE RECOVER  tablespace nnc_data01 ITPUB个人空间 r6P x[w0y Y;b*j'^
Fri Mar  7 14:52:46 2008
V|4L%N-R\1^0Media Recovery Tablespace: NNC_DATA01ITPUB个人空间V8t2z4a'v0M
Media Recovery Start
t?{2m$O/Z0Starting datafile 10 recovery in thread 1 sequence 930
1L }$O7eVT$Q5F0Datafile 10: '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf'
chA(\ b8sK5yx0_U0Media Recovery Log
NTJc|S'y0Fri Mar  7 14:52:46 2008
:]S+sCG8cT!@0Errors in file /oracle/admin/orcl/udump/orcl_ora_18167.trc:
_l\~k0ORA-07445:出现异常:核心转储[krdsodrf()+16] [SIGSEGV] [Address not mapped to object] [0x50] [] []ITPUB个人空间 `}g%jI3|3M\y
Fri Mar  7 14:53:35 2008ITPUB个人空间M {.QQt
/* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLINE
/E.D8pbzb9z0Fri Mar  7 14:54:00 2008
3b%e5z r6_C9v&x2Qm#{0ORA-1113 signalled during: /* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLI...
Qo:]8P/F8Hm0Fri Mar  7 14:55:38 2008
C4P s2p@ r0/* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLINE
a2?YU"LZb0Fri Mar  7 14:55:38 2008
e9ALi+J X,b0Completed: /* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLIITPUB个人空间#`0dvFO1^M$q
Fri Mar  7 14:55:38 2008
e q)]zp7XK/E%U0/* OracleOEM */ ALTER DATABASE RENAME FILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' TO '/data1/oracledata/NNC_DATA01
~4a}u ?w,Oi01.dbf'ITPUB个人空间&U%F)f1WQ.z
ORA-1511 signalled during: /* OracleOEM */ ALTER DATABASE RENAME FILE '/oracl...
)b @f.K7Ei0\p-Y0Fri Mar  7 14:55:48 2008
)Cm,[4O5l:L:e1U0/* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLINE
Dr3Y5T1Qg:M6p?q6I0Completed: /* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ONLI
7^;Z#~ch0Fri Mar  7 14:55:48 2008ITPUB个人空间:iV(`V9m%R\5u-Io
/* OracleOEM */ ALTER DATABASE RENAME FILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' TO '/data1/oracledata/NNC_DATA01ITPUB个人空间4i8s9iE6F ^2{t&bp
1.dbf'
k"{pt@ dg0ORA-1511 signalled during: /* OracleOEM */ ALTER DATABASE RENAME FILE '/oracl...ITPUB个人空间9]}f9g&O1c%WM+h
Fri Mar  7 14:57:18 2008
FH5E B s M(i\0/* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/app/product/9.2.0/oradata/orcl/NNC_DATA011.dbf' RESIZE 1000MITPUB个人空间*]Nt[)JK,v
Fri Mar  7 14:57:18 2008
;RhlJT b0Completed: /* OracleOEM */ ALTER DATABASE DATAFILE '/oracle/a
xgs/u9N#v0Fri Mar  7 14:59:56 2008
:J7j4a7wVw W0/* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ADD DATAFILE '/data1/oracledata/NNC_DATA011_2.dbf' SIZE1000MITPUB个人空间~^$L j-q4\"f(eRE
Fri Mar  7 15:00:11 2008
u(GC(Hr{7cN(i"l0Completed: /* OracleOEM */ ALTER TABLESPACE "NNC_DATA01" ADD

可以看到，用户尝试多次恢复未果后，尝试直接ONLINE表空间，在第一次ONLINE失败后，第二次ONLINE却神奇的成功了。有可能是由于前面TABLESPACE RECOVER成功，所以表空间本身处于一致性的状态，不过由于后面直接恢复该数据文件是碰到bug，导致第一次ONLINE表空间报错。

总而言之，这个bug的产生和解决都发生在一个不了解数据库的用户的胡乱的操作中，不仅偶然性的成分很大，而且也没有太多的可参考价值，只不过现象本身比较奇怪。

 


导入论坛 引用链接 收藏 分享给好友 推荐到圈子 管理 举报

TAG:

引用 删除 Guest   /   2008-06-03 14:47:32
评 5 分
 

评分：0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

Open Toolbar