Oracle辅导：ORA-28365:walletisnotopen
RMAN> backup database;Starting backup at 30-OCT-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1620 devtype=DISK
file 4 is excluded from whole database backup
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00008 name=/opt/oracle/oradata/STAPLES/datafiledaimin01.dbf
input datafile fno=00001 name=/opt/oracle/oradata/STAPLES/datafile/o1_mf_system_40n25j1h_.dbf
input datafile fno=00003 name=/opt/oracle/oradata/STAPLES/datafile/o1_mf_sysaux_40n25j2m_.dbf
input datafile fno=00002 name=/opt/oracle/oradata/STAPLES/datafile/o1_mf_undotbs1_40n25j77_.dbf
input datafile fno=00007 name=/opt/oracle/oradata/STAPLES/datafile/perfstat.dbf
input datafile fno=00005 name=/opt/oracle/oradata/STAPLES/datafile/MYDB
input datafile fno=00006 name=/opt/oracle/oradata/STAPLES/datafile/test02.dbf
channel ORA_DISK_1: starting piece 1 at 30-OCT-08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/30/2008 15:28:48
ORA-19914: unable to encrypt backup
ORA-28365: wallet is not open
解决:
执行语句
1、创建wallet
SQL> alter system set encryption key authenticated by "111111";
2、open wallet --创建wallet之后自动打开了wallet
SQL> alter system set wallet open identified by "111111";
alter system set wallet open identified by "111111";
SQL> connect / as sysdba
Connected.
SQL> alter system set encryption key authenticated by "111111";
alter system set encryption key authenticated by "111111"
*
ERROR at line 1:
ORA-28368: cannot auto-create wallet
页:
[1]