1.1 在wwl表空间上创建5张表,并添加数据。$ \+ @, z& k" A% B" p# M1 c$ g- ?
8 }: [$ z+ T8 {: h, i, ~
SQL> create table wwl01 (id number(3),namevarchar2(10));" ~3 [/ z8 }4 t! ~1 [: H7 u# Q
' O: O2 x* n: n7 a6 z" o Table created.
" t, w- v7 `! F+ d8 H
0 I$ h& B' F! z% \& Y SQL> insert into wwl01 values(1,'wwl');
' j* _; ^" Z3 b/ Z+ u9 i 5 i4 `" E2 \" r& X5 Y: ^3 k R
1 row created.
* ]8 I# f) f+ C. V3 _. W: p . Z4 ~2 o+ L, o7 X
SQL> insert into wwl01 values(2,'wm');
3 j% t& m; x5 Q6 _+ W, I/ K( G - d5 w2 s7 J3 i, x, T
1 row created.1 i) L- J1 a# _2 N7 s
" p# x! S8 U/ l8 |5 l. } SQL> insert into wwl01 values(3,'zq');2 n. x! \5 }! V. A
. n& ~* P6 w/ x
1 row created.9 p0 M# N* m8 t
& l' D4 ]6 l; F) Z U3 V& n4 W
SQL> insert into wwl01 values(4,'wbq');
% }1 Q9 l: i, Y' U; ]! ~$ A ) e+ ^, g- A$ Q; z+ M% n+ K7 @: j
1 row created., x* D0 j! u3 M/ g0 U* i# W3 N
& d+ B1 W2 W1 c" L' {- G
SQL> insert into wwl01 values(5,'wq');& j- d! o5 Q1 z( X' K$ n9 G
& o3 _( b( M! n. h& ~" Y! I* g# c 1 row created.
1 x# W1 |. s2 V/ E; w! G% k / D% d$ g* P. ~' ?4 i, @2 O- X
SQL> create table wwl02 as select * from wwl01;9 W3 X* \! E7 _1 {1 R3 G
( p& ?$ h! G: n% [/ g6 @( N. F
Table created.
4 F1 t& n' a" g ; p3 R. v" @, t2 H5 ]! h* s
SQL> create table wwl03 as select * from wwl01;
0 I7 v: B3 Z% H0 O# ?
" U" \2 }% x& {, w: N" Z1 k a6 { Table created.3 t* W' U4 \: |0 C, m( w
' D$ o1 C- r: M9 @/ b
SQL> create table wwl04 as select * from wwl01;
C7 a |7 m! T: {8 i& f 4 J* V: \0 s" C c3 i0 Y
Table created.
! J8 ] f e# s8 H7 P
: E3 m& p: M7 F. K5 I SQL> create table wwl05 as select * from wwl01;0 ~- a' |6 W9 b, E4 k0 S
. h& }- e! N/ e' C1 g. Z" Q- X1 a
Table created.
0 u1 {8 A& U0 x1 {' W+ U) O2 ~! R
; z6 Q+ V6 t$ m* U3 i7 A5 L 查看表中的数据:3 t8 c4 j# ?9 _1 I2 M% A
. @( a9 J- W7 `7 n# f0 t6 p! s7 s: _
SQL> select * from tab;0 ^" `& Y8 H2 Q9 Q& X$ H
% {4 Q1 s% h5 `$ b
TNAME TABTYPE CLUSTERID
# z* v" @3 X6 F# W 0 f$ R( c, b) D" J' h
---------- ------- ----------
4 {4 @% Z5 K k7 `2 R6 A 9 W% a# G2 W( k; g- i+ @! w4 q. X
WWL01 TABLE
7 P( T, w( e: M) D - v4 q4 y& i) f0 }* c! `* z
WWL02 TABLE' z) N2 x1 w2 s {: T
: N. p) B5 a2 g
WWL03 TABLE
4 U8 G r2 H# w/ s# M
* `! D. {5 `$ X WWL04 TABLE
3 o' u7 o; Y# c& ?* j1 D8 E ' ]( i5 O& h- W' N/ d( h
WWL05 TABLE6 \- {' B8 E9 f+ {5 P+ y
$ z9 X7 L8 k$ C O. R% d 1.2 执行全库备份( f! J; A | w7 ^; F: b
j: ^& M+ W4 t: E& p! T
[oracle@wwldb ~]$ rman target /( i9 w7 P5 N: `& k+ w4 o4 W
; a6 v, T% m- Z7 k x/ C
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jun 2200:59:59 2012- X0 a& V, K: Z6 @# C( d
, _' P# k1 T2 f* G% [8 X# S6 [
Copyright (c) 1982, 2005, Oracle. All rights reserved." y- w3 v, S% s6 b' F
6 a4 Q; d/ B: }; e0 @$ D5 _: U$ Y* O
connected to target database: WWL (DBID=5520179)
! C6 F( C" J% ?
7 s; o3 }4 k# K! t, d+ O2 i* e RMAN> backup database;' ^3 [9 f. |. ~7 p; y. ^
% w' e* l5 P" V' [1 I
1.3 模拟数据丢失,手动删除数据文件wwl001.dbf
- L* k: t9 y, l9 V 2 Y c5 r' _% W; ]
[oracle@wwldb WWL]$ rm -rfwwl001.dbf
6 |$ X v' ~" i9 j+ T5 `, C% u7 j
) B' S" P% f5 a" f' C 1.4 再次启动数据库,无法启动并报错不能锁定数据文件5,查看dbwr的跟踪文件。. O# o4 N, h( c( f5 x
# W. p5 }- r9 s2 F, ]" N
SQL>startup force;
( Y- Z4 q5 [6 Z# {. k% V 4 q: u. @' Y! ?* P. v
ORACLEinstance started." X) K% _4 ]7 T( ^) X
' B/ {; N$ P8 i# D# t3 Y
TotalSystem Global Area 285212672 bytes2 I: H2 W# I" K( ^
0 S0 {; L6 k Z, r FixedSize 1218968 bytes2 N1 n+ H" R! |) _" [- N' U
( f& j" t. T: }/ s9 F. O: U
VariableSize 92276328 bytes
6 E E/ w$ A* t0 c6 v% ^
, w& o' k0 S+ N4 [1 b- [0 [ DatabaseBuffers 184549376 bytes8 Y" A# i9 f7 s$ r. w
3 ^+ m! m7 P6 u5 L9 p/ g6 h& W5 u
RedoBuffers 7168000 bytes% A5 M( Q, N6 W# f2 k' r ?
0 a2 e" a- v# y( x, {6 o) a
Databasemounted.% O% I# L1 O! `& a! H3 s1 Y8 Q2 r: m
7 w- K1 r! o [0 r* t$ Q
ORA-01157:cannot identify/lock data file 5 - see DBWR trace file. ?$ _; p" Z6 R; y; q) {, E
* v; }5 f8 L2 X/ Y
ORA-01110: data file 5:'/DBData/WWL/wwl001.dbf'
8 ^- m6 ]9 f5 A1 J$ i" ^: v
7 j7 `4 r' f0 w/ n( u 1.5 检查跟踪文件,报如下错误,非常的清楚的告诉了找不到的文件:
) `9 ~1 d0 [; b+ B* g : e8 p- R" X; A& m
Errors in file /DBSoft/admin/WWL/bdump/wwl_dbw0_29185.trc:
+ P7 S$ B L* w1 |! h , l( w6 s- F/ _$ x! Z
ORA-01157: Message 1157 not found; No messagefile for product=RDBMS, facility=ORA; arguments: [5]
0 L Z3 A. J2 n" ?
1 u) U, F+ o( K; v. G ORA-01110: Message 1110 not found; No messagefile for product=RDBMS, facility=ORA; arguments: [5] [/DBData/WWL/wwl001.dbf]6 Q8 b4 h/ ?8 H( d9 }: b% v$ z
: i6 A: @/ O8 J ORA-27037: Message 27037 not found; No messagefile for product=RDBMS, facility=ORA
0 s+ A# `- B V% y, c s
) B1 R, x$ l% S Linux Error: 2: No such file or directory7 s# Z3 U, U6 }
$ H1 [" J" b9 n; ~& v
Additional information: 37 x" z, L8 J T4 x+ @* ~
' I. a+ H* a$ i) ] ORA-1157 signalled during: ALTER DATABASEOPEN… |