RMAN> backup database;/ p- m$ u" v. ^" O
Starting backup at 30-OCT-08: Z3 I9 r$ M/ |: I2 g
allocated channel: ORA_DISK_1
/ x6 A8 G% z8 I5 |6 L! }& ` channel ORA_DISK_1: sid=1620 devtype=DISK
0 ~8 s$ Z3 }$ X& q file 4 is excluded from whole database backup
0 ]) f$ H9 P+ _& | channel ORA_DISK_1: starting full datafile backupset- e1 P/ L7 \4 D
channel ORA_DISK_1: specifying datafile(s) in backupset5 }, o* ?' ^" D1 H. S4 E
input datafile fno=00008 name=/opt/oracle/oradata/STAPLES/datafiledaimin01.dbf
! ?0 N* o2 ?+ G, R! P7 G. { input datafile fno=00001 name=/opt/oracle/oradata/STAPLES/datafile/o1_mf_system_40n25j1h_.dbf
( v" s( l }2 ?# m input datafile fno=00003 name=/opt/oracle/oradata/STAPLES/datafile/o1_mf_sysaux_40n25j2m_.dbf6 c; P+ g Z" d5 t, S3 i: x
input datafile fno=00002 name=/opt/oracle/oradata/STAPLES/datafile/o1_mf_undotbs1_40n25j77_.dbf2 R, F* f7 _4 v/ Y) N+ c
input datafile fno=00007 name=/opt/oracle/oradata/STAPLES/datafile/perfstat.dbf: ?& }/ U% a7 q0 N; y
input datafile fno=00005 name=/opt/oracle/oradata/STAPLES/datafile/MYDB
/ k8 }. ~) y3 m) T input datafile fno=00006 name=/opt/oracle/oradata/STAPLES/datafile/test02.dbf
0 U) _( X7 a( f1 H5 ~# c channel ORA_DISK_1: starting piece 1 at 30-OCT-08. `0 V+ z1 ~# o
RMAN-00571: ===========================================================! p; T! D1 a' r( w$ K3 a/ E
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
" ^8 X I& u' U RMAN-00571: ===========================================================! O$ G( h2 e! L( g' N2 L5 ?6 r
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/30/2008 15:28:48
* ]6 G+ N% o2 L ~% G$ g! l6 }- e ORA-19914: unable to encrypt backup8 C" ~+ c6 u- p; J1 O
ORA-28365: wallet is not open9 p9 T4 {) v$ M" G7 ?
解决:
3 n3 g6 _% ?5 v* S+ [; n' j 执行语句
7 ]' q+ O, N. R3 N1 T) B' u 1、创建wallet
5 z: z. J' ]$ p* N c SQL> alter system set encryption key authenticated by "111111";
6 W* R z2 e& }- ]/ L- s! i 2、open wallet --创建wallet之后自动打开了wallet
. F# N9 ~0 Y# m6 v: k3 g SQL> alter system set wallet open identified by "111111";
7 j$ \7 S. ]% k% X% o! W5 i alter system set wallet open identified by "111111";2 {7 k! q. M( M$ E
SQL> connect / as sysdba. P" R2 C; e0 M3 N+ F
Connected.
( Z+ k j4 D0 h0 U- U+ W N SQL> alter system set encryption key authenticated by "111111";8 r$ O7 }' {! r7 b& B
alter system set encryption key authenticated by "111111"2 Y( h: d7 Y+ }9 G- k3 K! |
*
* h3 w! P; K0 s4 b" M- c) { ERROR at line 1:
9 C2 o6 x- m! V; L6 l ORA-28368: cannot auto-create wallet |