当前位置:  数据库>oracle

Oracle 11g 数据库rman压缩备份压缩率测试

    来源: 互联网  发布时间：2017-05-08

    本文导语: 此测试不从时间维度比较，只从存储空间维度进行简要比较。--操作系统环境[Oracle@11grac1 ~]$ uname -aLinux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/Linux--数据库环境SQL> set pagesize 200SQL> col BANNER for a60SQL> select *...

此测试不从时间维度比较，只从存储空间维度进行简要比较。
--操作系统环境
[Oracle@11grac1 ~]$ uname -a
Linux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/Linux
--数据库环境
SQL> set pagesize 200
SQL> col BANNER for a60
SQL> select * from gv$version where rownumOracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
           Production
         1 PL/SQL Release 11.2.0.1.0 - Production
         1 CORE 11.2.0.1.0      Production
         1 TNS for Linux: Version 11.2.0.1.0 - Production
         1 NLSRTL Version 11.2.0.1.0 - Production
         2 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
           Production
         2 PL/SQL Release 11.2.0.1.0 - Production
         2 CORE 11.2.0.1.0      Production
         2 TNS for Linux: Version 11.2.0.1.0 - Production
         2 NLSRTL Version 11.2.0.1.0 - Production
--数据库归档情况
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     2
Next log sequence to archive   3
Current log sequence           3
SQL> show parameter cluster_database;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     TRUE
cluster_database_instances           integer     2
--数据库当前大小
SQL> select sum(bytes)/1024/1024 m from dba_data_files;
         M
----------
      1195
--rman参数配置
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name RACDB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 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 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_racdb1.f'; # default
--执行压缩备份脚本(只备份数据库)
RMAN> run {
2> allocate channel c1 type disk maxpiecesize=512m;
3> allocate channel c2 type disk maxpiecesize=512m;
4> backup as compressed backupset database format '/u01/app/backup/db_full_%U_%p_%T_%s.bak' tag 'dbl0';
5> backup current controlfile format '/u01/app/backup/contorlfile_%T_%U_%s.ctlbak';
release channel c1;
6> 7> release channel c2;
8> }
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: c1
channel c1: SID=32 instance=racdb1 device type=DISK
allocated channel: c2
channel c2: SID=57 instance=racdb1 device type=DISK
Starting backup at 13-SEP-12
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/racdb/system01.dbf
input datafile file number=00004 name=+DATA/racdb/users01.dbf
channel c1: starting piece 1 at 13-SEP-12
channel c2: starting compressed full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/racdb/sysaux01.dbf
input datafile file number=00003 name=+DATA/racdb/undotbs01.dbf
input datafile file number=00005 name=+DATA/racdb/undotbs02.dbf
channel c2: starting piece 1 at 13-SEP-12
channel c2: finished piece 1 at 13-SEP-12
piece handle=/u01/app/backup/db_full_08nl4lf6_1_1_1_20120913_8.bak tag=DBL0 comment=NONE
channel c2: backup set complete, elapsed time: 00:03:26
channel c1: finished piece 1 at 13-SEP-12
piece handle=/u01/app/backup/db_full_07nl4lf6_1_1_1_20120913_7.bak tag=DBL0 comment=NONE
channel c1: backup set complete, elapsed time: 00:04:27
Finished backup at 13-SEP-12
Starting backup at 13-SEP-12
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 13-SEP-12
channel c1: finished piece 1 at 13-SEP-12
piece handle=/u01/app/backup/contorlfile_20120913_09nl4lnq_1_1_9.ctlbak tag=TAG20120913T224930 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 13-SEP-12
Starting Control File and SPFILE Autobackup at 13-SEP-12
piece handle=+DATA/racdb/autobackup/2012_09_13/s_793925381.271.793925387 comment=NONE
Finished Control File and SPFILE Autobackup at 13-SEP-12
released channel: c1
released channel: c2
--查看备份大小
[oracle@11grac1 backup]$ pwd
/u01/app/backup
[oracle@11grac1 backup]$ ls
contorlfile_20120913_09nl4lnq_1_1_9.ctlbak  db_full_08nl4lf6_1_1_1_20120913_8.bak
db_full_07nl4lf6_1_1_1_20120913_7.bak
[oracle@11grac1 backup]$ du -sh
269M    .
--执行非压缩备份脚本(只备份数据库)
RMAN> run {
2> allocate channel c1 type disk maxpiecesize=512m;
3> allocate channel c2 type disk maxpiecesize=512m;
4> backup as backupset database format '/u01/app/backup/db_full_%U_%p_%T_%s.bak' tag 'dbl0';
5> backup current controlfile format '/u01/app/backup/contorlfile_%T_%U_%s.ctlbak';
6> release channel c1;
7> release channel c2;
}8>
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: c1
channel c1: SID=32 instance=racdb1 device type=DISK
allocated channel: c2
channel c2: SID=57 instance=racdb1 device type=DISK
Starting backup at 13-SEP-12
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/racdb/system01.dbf
input datafile file number=00004 name=+DATA/racdb/users01.dbf
channel c1: starting piece 1 at 13-SEP-12
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/racdb/sysaux01.dbf
input datafile file number=00003 name=+DATA/racdb/undotbs01.dbf
input datafile file number=00005 name=+DATA/racdb/undotbs02.dbf
channel c2: starting piece 1 at 13-SEP-12
channel c1: finished piece 1 at 13-SEP-12
piece handle=/u01/app/backup/db_full_0bnl4lsf_1_1_1_20120913_11.bak tag=DBL0 comment=NONE
channel c1: starting piece 2 at 13-SEP-12
channel c1: finished piece 2 at 13-SEP-12
piece handle=/u01/app/backup/db_full_0bnl4lsf_2_1_2_20120913_11.bak tag=DBL0 comment=NONE
channel c1: backup set complete, elapsed time: 00:02:42
channel c2: finished piece 1 at 13-SEP-12
piece handle=/u01/app/backup/db_full_0cnl4lsg_1_1_1_20120913_12.bak tag=DBL0 comment=NONE
channel c2: backup set complete, elapsed time: 00:02:51
Finished backup at 13-SEP-12
Starting backup at 13-SEP-12
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 13-SEP-12
channel c1: finished piece 1 at 13-SEP-12
piece handle=/u01/app/backup/contorlfile_20120913_0dnl4m21_1_1_13.ctlbak tag=TAG20120913T225456 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 13-SEP-12
Starting Control File and SPFILE Autobackup at 13-SEP-12
piece handle=+DATA/racdb/autobackup/2012_09_13/s_793925708.270.793925713 comment=NONE
Finished Control File and SPFILE Autobackup at 13-SEP-12
released channel: c1
released channel: c2
--查看备份大小
[oracle@11grac1 backup]$ rm -rf *
[oracle@11grac1 backup]$ du -sh
969M    .
--11g压缩备份效率比较
是否压缩备份        压缩备份（单位M）        非压缩备份（单位M）            比率
库大小                    1195                                  1195                                         1
备份文件大小        269                                    969                                           3.6
比率                        0.23                                   0.81                                          3.52










































































































































































    
 
 

您可能感兴趣的文章:

  • oracle定时备份压缩的实现步骤
  • Linux oracle数据库自动备份自动压缩脚本代码
  • Oracle压缩表表空间
  • 如何将Aix上的oracle 物理备份 然后再在linux 系统上还原oracle
  • Oracle数据库设置任务计划备份一周的备份记录
  • Oracle数据库备份和恢复工具 RMan
  • oracle10g 数据备份与导入
  • aix下自动备份oracle 的输出日志问题，急！！
  • hp unix下备份oracle表的问题
  • linux小白提问linux备份oracle数据库的问题
  • oracle不能自动备份
  • Oracle数据库逻辑备份的SH文件
  • Linux环境中Oracle数据导入与导出备份操作
  • oracle数据库备份急？？？？？？？？？？？
  • Unix系统下如何将oracle数据库备份
  • 详解如何应用改变跟踪技术加速Oracle递增备份
  • Oracle中备份表的简单sql命令语句
  • 实战Oracle数据库备份与恢复
  • Linux下实现自动备份Oracle数据库
  • oracle备份恢复的具体方法
  • 利用windows任务计划实现oracle的定期备份
  • Oracle11g备份和恢复功能的提高
  • Oracle数据库冷备份的异地恢复
    •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。












  • 相关文章推荐
  • Oracle 数据库(oracle Database)Select 多表关联查询方式
  • Oracle 数据库开发工具 Oracle SQL Developer
  • Oracle数据库(Oracle Database)体系结构及基本组成介绍
  • 请问大家用oracle数据库, 用import oracle.*;下的东西么? 还是用标准库?
  • Oracle 数据库(oracle Database)性能调优技术详解
  • 关于JDBC连接Oracle数据库，是否必须有Oracle客户端
  • ORACLE数据库常用字段数据类型介绍
  • win2000+jbuilder6+oracle817编出的程序，在win2000下执行很好，在win98下却访问不了oracle数据库
  • oracle数据库导出和oracle导入数据的二种方法(oracle导入导出数据)
  • Oracle发布Oracle SQL Developer 1.2数据库开发工具 帮助用户简化开发工作
  • 怎样调出ORACLE数据库中的数据,该如何连接?
  • Oracle收购TimesTen 提高数据库软件性能
  • 卸载oracle数据库
  • Oracle数据库恢复后心得
  • linux上安装oracle 数据库后，是否能写shell程序实现数据库的自动启动。
  • Linux下如何用C语言操作Oracle数据库相关的图书推荐
  • Oracle数据库运行Oracle form时避免出现提示信息
  • Oracle欲收购开源数据库MySQL未果
  • 如何在JBuilder中连接Oracle数据库？
  • Oracle数据库访问参数文件的顺序
  • 循序渐进学习Oracle数据库
  • unix/linux知识 iis7站长之家
  • 在linux下安装oracle,如何设置让oracle自动启动！也就是让oracle那个服务自动启动，不是手动的
  • oracle 11g最新版官方下载地址
  • 请问su oracle 和su - oracle有什么不同？
  • 如何设置让Oracle SQL Developer显示的时间包含时分秒
  • 虚拟机装Oracle R12与Oracle10g
  • Oracle 10g和Oracle 11g网格技术介绍
  • Oracle EBS R12 支持 Oracle Database 11g
  • oracle中如何把表中具有相同值列的多行数据合并成一行
  • SCO unix下安装oracle，但没有光盘，请大家推荐一个oracle下载站点（unix版本的）。谢谢！！！！


    • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除！

    ©2012-2021,