进行测试之前先将数据库做全备: 引用
9 i: D7 N+ W i' F* |$ R- ? RMAN> run {
0 v( Q% U! V% f/ ~# b. Q 2> allocate channel ch00 device type disk;
8 B5 V! i, _5 p- A" r0 \ 3> backup database include current controlfile format ‘/backup/full%t’ tag=’FULLDB’;; Q1 |; W) s- {! u5 m% L, t Y5 e
4> sql ‘alter system archive log current’;
" u) }# M- H9 y- `* k; t$ V 5> backup archivelog all format ‘/backup/arch%t’ tag=’ARCHIVELOG’;9 e, o7 k! ]- {: p7 n" r& N8 t7 o
6> release channel ch00;
) C7 H0 l( L& v6 @# M1 W 7> }
0 u+ ]/ G, h ?, ~. z4 X: P& g0 M allocated channel: ch00
& G' x5 B c. [$ q" }6 S, G channel ch00: sid=17 devtype=DISK
: J, u3 f3 X7 t# o* w% |; { Starting backup at 20-JAN-10
6 {; F3 \- U) o channel ch00: starting full datafile backupset
+ S/ a, A1 _# O" ^$ j$ `; [8 D" i channel ch00: specifying datafile(s) in backupset
1 Z* e+ g/ Z' u8 z including current controlfile in backupset
% L1 \5 _, M+ V$ f input datafile fno=00001 name=/app/oracle/oradata/ora9i/system01.dbf
. F5 w$ {) {2 T+ f& c input datafile fno=00002 name=/app/oracle/oradata/ora9i/undotbs01.dbf$ b& W$ O( }1 O6 t
input datafile fno=00005 name=/app/oracle/oradata/ora9i/example01.dbf- _' b8 b) |% s T3 ]
input datafile fno=00011 name=/app/oracle/oradata/ora9i/STREAM01.dbf/ P8 z, U) t" W- Z; p, f: L
input datafile fno=00010 name=/app/oracle/oradata/ora9i/xdb01.dbf
# N" D6 M+ E6 O; I' u input datafile fno=00006 name=/app/oracle/oradata/ora9i/indx01.dbf7 b4 T A* R4 C, P: z
input datafile fno=00009 name=/app/oracle/oradata/ora9i/users01.dbf0 d" A8 p2 q6 f# c7 o$ I. h, A
input datafile fno=00003 name=/app/oracle/oradata/ora9i/cwmlite01.dbf
: K/ g- {) E+ I+ t9 O* V input datafile fno=00004 name=/app/oracle/oradata/ora9i/drsys01.dbf% z7 t9 G, P: d: i- Y$ u4 F
input datafile fno=00007 name=/app/oracle/oradata/ora9i/odm01.dbf
9 _ @% `: ^- j$ e input datafile fno=00008 name=/app/oracle/oradata/ora9i/tools01.dbf
$ V* g; ^7 }; ~/ D/ j0 ]3 g channel ch00: starting piece 1 at 20-JAN-10* Q9 Q5 Y! T& R }
channel ch00: finished piece 1 at 20-JAN-10$ I( _7 j8 Y n
piece handle=/backup/full708756233 comment=NONE. Q( E5 D5 Y( i X3 d
channel ch00: backup set complete, elapsed time: 00:02:26
7 E( k; Z5 a1 i- E4 y& E2 K Finished backup at 20-JAN-10
8 O2 M! W9 |2 P Starting Control File and SPFILE Autobackup at 20-JAN-10: K: K, X+ o; D# u* }/ E' U+ l7 ~' x) ?
piece handle=/app/oracle/product/9.0.2/dbs/c-2494723682-20100120-00 comment=NONE4 C; p4 L6 l+ ~
Finished Control File and SPFILE Autobackup at 20-JAN-10" q; G3 {- X1 H/ A" ?6 _
sql statement: alter system archive log current! X, T9 F" S* U8 Z5 \8 y
Starting backup at 20-JAN-10
1 z& E) O5 f, p current log archived
3 |/ K8 W7 C6 L channel ch00: starting archive log backupset( b- Y7 t6 W5 c
channel ch00: specifying archive log(s) in backup set
2 R- p. o- `3 w8 Z4 p$ _8 H input archive log thread=1 sequence=1 recid=254 stamp=708756150" q+ G1 a. E& a. Z; ]9 z' i" W* R
input archive log thread=1 sequence=2 recid=255 stamp=708756383* @* }' \/ T8 H/ \9 ]! A8 D
8 }+ Z7 I/ X( ] input archive log thread=1 sequence=3 recid=256 stamp=708756383 |