Oracle11g新特性:RMAN压缩备份

Oracle10g的rman已经可以执行压缩备份,采用的压缩算法是bzip2。Oracle11g引入了一种新的压缩算法zlib。zlib的压缩率不如bzip2,但是压缩速度则要快不少。本文通过一个实验来对这两种压缩算法进行比较。


[oracle@localhost oracle]$ rman target /

Recovery Manager: Release 11.1.0.6.0 – Production on Thu Sep 6 15:47:43 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: NING (DBID=1218842970)


先执行普通全库备份


RMAN> backup full database
2> format=’/oracle/nocomp%u.ora';

Starting backup at 06-SEP-07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=156 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/oracle/oradata/ning/undotbs01.dbf
input datafile file number=00001 name=/oracle/oradata/ning/system01.dbf
input datafile file number=00002 name=/oracle/oradata/ning/sysaux01.dbf
input datafile file number=00004 name=/oracle/oradata/ning/users01.dbf
input datafile file number=00005 name=/oracle/oradata/ning/test01.dbf
channel ORA_DISK_1: starting piece 1 at 06-SEP-07
channel ORA_DISK_1: finished piece 1 at 06-SEP-07
piece handle=/oracle/nocomp09ir94u3.ora tag=TAG20070906T154819 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 06-SEP-07
channel ORA_DISK_1: finished piece 1 at 06-SEP-07
piece handle=/oracle/nocomp0air9500.ora tag=TAG20070906T154819 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 06-SEP-07

默认情况下,Oracle11g还是采用的bzip2压缩算法

RMAN> show all;

RMAN configuration parameters for database with db_unique_name NING are:

CONFIGURE COMPRESSION ALGORITHM ‘BZIP2′;

以bzip2压缩算法执行第二次全库备份

RMAN> backup as compressed backupset full database
2> format=’/oracle/bzip2comp%u.ora';

Starting backup at 06-SEP-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=156 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/oracle/oradata/ning/undotbs01.dbf
input datafile file number=00001 name=/oracle/oradata/ning/system01.dbf
input datafile file number=00002 name=/oracle/oradata/ning/sysaux01.dbf
input datafile file number=00004 name=/oracle/oradata/ning/users01.dbf
input datafile file number=00005 name=/oracle/oradata/ning/test01.dbf
channel ORA_DISK_1: starting piece 1 at 06-SEP-07
channel ORA_DISK_1: finished piece 1 at 06-SEP-07
piece handle=/oracle/bzip2comp0bir953r.ora tag=TAG20070906T155122 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 06-SEP-07
channel ORA_DISK_1: finished piece 1 at 06-SEP-07
piece handle=/oracle/bzip2comp0cir9552.ora tag=TAG20070906T155122 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 06-SEP-07

然后修改默认压缩算法,使用zlib算法

RMAN> configure compression algorithm ‘ZLIB';

old RMAN configuration parameters:
CONFIGURE COMPRESSION ALGORITHM ‘BZIP2′;
new RMAN configuration parameters:
CONFIGURE COMPRESSION ALGORITHM ‘ZLIB';
new RMAN configuration parameters are successfully stored

使用zlib压缩算法备份全库

RMAN> backup as compressed backupset full database
2> format=’/oracle/zlibcomp%u.ora';

Starting backup at 06-SEP-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/oracle/oradata/ning/undotbs01.dbf
input datafile file number=00001 name=/oracle/oradata/ning/system01.dbf
input datafile file number=00002 name=/oracle/oradata/ning/sysaux01.dbf
input datafile file number=00004 name=/oracle/oradata/ning/users01.dbf
input datafile file number=00005 name=/oracle/oradata/ning/test01.dbf
channel ORA_DISK_1: starting piece 1 at 06-SEP-07
channel ORA_DISK_1: finished piece 1 at 06-SEP-07
piece handle=/oracle/zlibcomp0dir958h.ora tag=TAG20070906T155353 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 06-SEP-07
channel ORA_DISK_1: finished piece 1 at 06-SEP-07
piece handle=/oracle/zlibcomp0eir959e.ora tag=TAG20070906T155353 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 06-SEP-07


下面是备份集的大小


[oracle@localhost oracle]$ ls -l | grep comp
-rw-r—– 1 oracle oinstall 53755904 Sep 6 15:51 bzip2comp0bir953r.ora
-rw-r—– 1 oracle oinstall 1114112 Sep 6 15:52 bzip2comp0cir9552.ora
-rw-r—– 1 oracle oinstall 332972032 Sep 6 15:49 nocomp09ir94u3.ora
-rw-r—– 1 oracle oinstall 9830400 Sep 6 15:49 nocomp0air9500.ora
-rw-r—– 1 oracle oinstall 59514880 Sep 6 15:54 zlibcomp0dir958h.ora
-rw-r—– 1 oracle oinstall 1146880 Sep 6 15:54 zlibcomp0eir959e.ora

现在来对这三种备份进行比较(忽略controlfile和spfile备份集)

不压缩: 文件大小332972032 备份时间00:00:56
BZIP2压缩:文件大小53755904 备份时间00:00:35
ZLIB压缩: 文件大小59514880 备份时间00:00:25

可以看到,两种压缩算法中,bzip2的压缩率比zlib高大概10.7%,但是压缩速度则比zlib慢大概28.6%。这样就可以根据不同的需求来选择不同的压缩算法。



无觅相关文章插件,快速提升流量

没有评论


(Required)
(Required, will not be published)