✎ 编程开发网

ORACLE之rman备份加密(四)

2014-11-24 15:14:09 · 作者: · 浏览: 6

标签: ORACLE rman 备份加密

:~/oradata> l

total 615033

drwxr-x--- 4 oracle oinstall 240 2013-03-28 20:41 ./

drwxrwx--- 32 oracle oinstall 1368 2013-03-25 21:51 ../

drwxr-x--- 5 oracle oinstall 136 2013-03-24 11:50 ORCL/

drwxr-x--- 3 oracle oinstall 72 2013-03-20 22:17 ORCL01/

-rw-r----- 1 oracle oinstall 104865792 2013-03-28 20:42 sysaux_add.dbf

-rw-r----- 1 oracle oinstall 104865792 2013-03-21 11:40 sysaux_add.dbf_bak

-rw-r----- 1 oracle oinstall 209723392 2013-03-28 20:42 system_add.dbf

-rw-r----- 1 oracle oinstall 209723392 2013-03-21 11:40 system_add.dbf_bak

oracle@oracle:~/oradata> cd

oracle@oracle:~> cd admin

oracle@oracle:~/admin> ls

orcl ORCL01

oracle@oracle:~/admin> cd orcl/

oracle@oracle:~/admin/orcl> echo $ORACLE_SID

orcl

oracle@oracle:~/admin/orcl> ls

adump dpdump pfile

第二种透明方式：使用加密证书，局限性是只能在本地数据库进行修复和恢复。

oracle@oracle:~/admin/orcl> mkdir wallet

oracle@oracle:~/admin/orcl> exit

exit

主机命令完成

RMAN>

RMAN> show all;

db_unique_name 为 ORCL 的数据库的 RMAN 配置参数为:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/opt/oracle/flash_recovery_area/ORCL/controlfile/c_%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/10.2/db_1/dbs/snapcf_orcl.f'; # default

RMAN> host;

oracle@oracle:~/oradata> sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 3月 28 20:47:40 2013

连接到:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@orcl#alter system set encryption key authenticated by "root";

系统已更改。

SYS@orcl#exit

从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开

oracle@oracle:~/oradata> cd

oracle@oracle:~> cd admin/

oracle@oracle:~/admin> cd orcl/

oracle@oracle:~/admin/orcl> cd wallet/

oracle@oracle:~/admin/orcl/wallet> ls

ewallet.p12

oracle@oracle:~/admin/orcl/wallet> pwd

/opt/oracle/admin/orcl/wallet

oracle@oracle:~/admin/orcl/wallet> exit