不同版本下的rman压缩备份

实验环境：
10.2.0.2 虚拟机-linux 64位
11.1.0.6 小机-HPUNIX
11.2.0.3 小机-HPUNIX
 10G 推出了bzip2算法的压缩备份。
 11R1推出了zlib算法的压缩备份。
 11R2推出了基本压缩备份和高级压缩备份。
备注：实验会因为坏境不同而存在多多少少的误差
1. 10G的普通备份和压缩备份
库中有数据的数据块大小一共为8865M。 
1.1  10G---普通备份
RMAN> run
 {
    allocate channel ch01 type disk;
    allocate channel ch02 type disk;
    allocate channel ch03 type disk;
    backup database format '/home/oracle/dbfull_%d_%T_%t_%s';
    release channel ch01;
    release channel ch02;
    release channel ch03;
 }
备份文件大小：8196M  备份时间为：55s  cpu使用率：8%

1.2  10G---bzip2压缩备份
RMAN> run
{
   allocate channel ch01 type disk;
   allocate channel ch02 type disk;
   allocate channel ch03 type disk;
   backup as compressed backupset full database  format '/home/oracle/dbfull-compreee-%U';
   release channel ch01;
   release channel ch02;
   release channel ch03;
}
备份文件大小：5064M 备份时间：7:18分  cpu使用率：37%
2. 11R1的普通备份和压缩备份
库中有数据的数据块大小一共为9639M。
1.1  11R1---普通备份
RMAN> run
 {
    allocate channel ch01 type disk;
    allocate channel ch02 type disk;
    allocate channel ch03 type disk;
    backup database format '/pmsdb/dbfull_%d_%T_%t_%s';
    release channel ch01;
    release channel ch02;
    release channel ch03;
 }
备份文件大小：11169M  备份时间为：62s  cpu使用率：14%
2.2  11R1---bzip2压缩备份
RMAN> CONFIGURE COMPRESSION ALGORITHM 'BZIP2';
RMAN> run
{
   allocate channel ch01 type disk;
   allocate channel ch02 type disk;
   allocate channel ch03 type disk;
   backup as compressed backupset full database  format '/pmsdb/dbfull-bzip2compreee-%U';
   release channel ch01;
   release channel ch02;
   release channel ch03;
}
备份文件大小：1480M 备份时间：03:25分  cpu使用率：37%
2.3  11R1---ZLIB压缩备份
RMAN> CONFIGURE COMPRESSION ALGORITHM 'ZLIB';
RMAN> run
{
   allocate channel ch01 type disk;
   allocate channel ch02 type disk;
   allocate channel ch03 type disk;
   backup as compressed backupset full database  format '/pmsdb/dbfull-zlibcompreee-%U';
   release channel ch01;
   release channel ch02;
   release channel ch03;
}
备份文件大小：1310M 备份时间：01:30分  cpu使用率：34%
3. 11R2的普通备份和压缩备份
库中有数据的数据块大小一共为8115M。
3.1  11R2---普通备份
RMAN> run
 {
    allocate channel ch01 type disk;
    allocate channel ch02 type disk;
    allocate channel ch03 type disk;
    backup database format '/pmsdb/oradata/dbfull_%d_%T_%t_%s';
    release channel ch01;
    release channel ch02;
    release channel ch03;
 }
备份文件大小：7517M  备份时间为：01:27分  cpu使用率：2.9%
3.2  11R2---BASIC压缩备份
RMAN> CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
RMAN> run
{
   allocate channel ch01 type disk;
   allocate channel ch02 type disk;
   allocate channel ch03 type disk;
   backup as compressed backupset full database  format '/pmsdb/oradata/dbfull-basiccompreee-%U';
   release channel ch01;
   release channel ch02;
   release channel ch03;
}
备份文件大小：1148M 备份时间：04:45分  cpu使用率：14%
3.3  11R2---LOW压缩备份
RMAN> CONFIGURE COMPRESSION ALGORITHM 'LOW';
RMAN> run
{
   allocate channel ch01 type disk;
   allocate channel ch02 type disk;
   allocate channel ch03 type disk;
   backup as compressed backupset full database  format '/pmsdb/oradata/dbfull-lowcompreee-%U';
   release channel ch01;
   release channel ch02;
   release channel ch03;
}
备份文件大小：1649M 备份时间：01:47分  cpu使用率：8%
3.4  11R2---MEDIUM压缩备份
RMAN> CONFIGURE COMPRESSION ALGORITHM 'MEDIUM';
RMAN> run
{
   allocate channel ch01 type disk;
   allocate channel ch02 type disk;
   allocate channel ch03 type disk;
   backup as compressed backupset full database  format '/pmsdb/oradata/dbfull-mediumcompreee-%U';
   release channel ch01;
   release channel ch02;
   release channel ch03;
}
备份文件大小：1346M 备份时间：02:36分  cpu使用率：11%
3.5  11R2---HIGH压缩备份
RMAN> CONFIGURE COMPRESSION ALGORITHM 'HIGH';
RMAN> run
{
   allocate channel ch01 type disk;
   allocate channel ch02 type disk;
   allocate channel ch03 type disk;
   backup as compressed backupset full database  format '/pmsdb/oradata/dbfull-highcompreee-%U';
   release channel ch01;
   release channel ch02;
   release channel ch03;
}
备份文件大小：910M 备份时间：21:52分  cpu使用率：20%



 
遇到的问题
RMAN>  CONFIGURE COMPRESSION ALGORITHM 'LOW';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 12/19/2013 09:29:18
RMAN-06806: compression algorithm 'LOW' of release DEFAULT not found
错误产生原因：
由于我的库是11.1升级到11.2的，而且我并没有修改 compatible='11.2.0.0.0'，而是使用原来的 compatible为'11.1.0.0.0'，可以通过查看V$RMAN_COMPRESSION_ALGORITHM来看出：
11R1的V$RMAN_COMPRESSION_ALGORITHM：
SQL>  select * from V$RMAN_COMPRESSION_ALGORITHM;
ALGORITHM_ID ALGORITHM_NAME                 ALGORITHM_DESCRIPTION                    ALGORITHM_COMPATIB DATABASE_COMPATIBI IS_ IS_
------------ ------------------------------ ---------------------------------------- ------------------ ------------------ --- ---
           1 ZLIB                           optimized for speed                      11.0.0.0.0         11.1.0.0.0         YES NO
           0 BZIP2                          optimized for maximum compression        9.2.0.0.0          11.1.0.0.0         YES YES
这个是11R1的，这里我写出来只是为了区别升级前后这个试图的变化。
11R2的V$RMAN_COMPRESSION_ALGORITHM（compatible此时为'11.1.0.0.0'）：
 SQL> select ALGORITHM_NAME, INITIAL_RELEASE, TERMINAL_RELEASE, ALGORITHM_DESCRIPTION, IS_VALID, REQUIRES_ACO, IS_DEFAULT from V$RMAN_COMPRESSION_ALGORITHM;

ALGORITHM_ INITIAL_RELEASE    TERMINAL_RELEASE   ALGORITHM_DESCRIPTION                                            IS_ REQ IS_
---------- ------------------ ------------------ ---------------------------------------------------------------- --- --- ---
BZIP2      10.0.0.0.0         11.2.0.0.0         good compression ratio                                           YES NO  YES
BASIC      10.0.0.0.0                            good compression ratio                                           YES NO  NO
LOW        11.2.0.0.0                            maximum possible compression speed                               NO  YES NO
ZLIB       11.0.0.0.0         11.2.0.0.0         balance between speed and compression ratio                      YES YES NO
MEDIUM     11.2.0.0.0                            balance between speed and compression ratio                      YES YES NO
HIGH       11.2.0.0.0                            maximum possible compression ratio                               NO  YES NO
6 rows selected.
11R2的V$RMAN_COMPRESSION_ALGORITHM（compatible此时为'11.2.0.0.0'）：
SQL> col ALGORITHM_NAME for a10
SQL> col INITIAL_RELEASE for a10
SQL> col TERMINAL_RELEASE for a10
SQL> col ALGORITHM_DESCRIPTION for a50
SQL> set linesize 200
SQL>  select ALGORITHM_NAME, INITIAL_RELEASE, TERMINAL_RELEASE, ALGORITHM_DESCRIPTION, IS_VALID, REQUIRES_ACO, IS_DEFAULT from V$RMAN_COMPRESSION_ALGORITHM;

ALGORITHM_ INITIAL_RE TERMINAL_R ALGORITHM_DESCRIPTION                              IS_ REQ IS_
---------- ---------- ---------- -------------------------------------------------- --- --- ---
BZIP2      10.0.0.0.0 11.2.0.0.0 good compression ratio                             YES NO  NO
BASIC      10.0.0.0.0            good compression ratio                             YES NO  YES
LOW        11.2.0.0.0            maximum possible compression speed                 YES YES NO
ZLIB       11.0.0.0.0 11.2.0.0.0 balance between speed and compression ratio        YES YES NO
MEDIUM     11.2.0.0.0            balance between speed and compression ratio        YES YES NO
HIGH       11.2.0.0.0            maximum possible compression ratio                 YES YES NO
6 rows selected.

然后再次执行RMAN>  CONFIGURE COMPRESSION ALGORITHM 'LOW';就不会报错啦。

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24500180/viewspace-1063760/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24500180/viewspace-1063760/