rman备份压缩比例？5倍左右

喝醉酒的小白

已于 2022-07-18 23:49:42 修改

阅读量1.3k

点赞数 1

分类专栏： DBA 文章标签：数据库 oracle

于 2022-07-18 23:47:26 首次发布

本文链接：https://blog.csdn.net/hezuijiudexiaobai/article/details/125862547

版权

DBA 专栏收录该内容

722 篇文章 17 订阅

订阅专栏

1 5.7倍

测试1
在这里插入图片描述

2 6倍

测试2
在这里插入图片描述

3 4.4倍

@tbs

在这里插入图片描述

select 1683.81/1024 from dual;

1683.81/1024
------------
   1.6443457

 backup as compressed backupset full database;

Starting backup at 2022-07-18 23:37:46
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6770 instance=bpxtest1 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=00006 name=+SSDDG1/bpxtest/datafile/test.11936.1110411371
input datafile file number=00001 name=+SSDDG2/bpxtest/datafile/system.276.1110062879
input datafile file number=00002 name=+SSDDG1/bpxtest/datafile/sysaux.12322.1109773657
input datafile file number=00003 name=+SSDDG1/bpxtest/datafile/undotbs1.12320.1109773657
input datafile file number=00005 name=+SSDDG1/bpxtest/datafile/undotbs2.12311.1109773755
input datafile file number=00004 name=+SSDDG1/bpxtest/datafile/users.12318.1109773657
channel ORA_DISK_1: starting piece 1 at 2022-07-18 23:37:47
channel ORA_DISK_1: finished piece 1 at 2022-07-18 23:38:32
piece handle=/opt/oracle/products/11.2.0/dbs/0a12v26b_1_1 tag=TAG20220718T233747 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
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 2022-07-18 23:38:33
channel ORA_DISK_1: finished piece 1 at 2022-07-18 23:38:34
piece handle=/opt/oracle/products/11.2.0/dbs/0b12v27o_1_1 tag=TAG20220718T233747 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2022-07-18 23:38:34

backup full database;

Starting backup at 2022-07-18 23:39:42
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=+SSDDG1/bpxtest/datafile/test.11936.1110411371
input datafile file number=00001 name=+SSDDG2/bpxtest/datafile/system.276.1110062879
input datafile file number=00002 name=+SSDDG1/bpxtest/datafile/sysaux.12322.1109773657
input datafile file number=00003 name=+SSDDG1/bpxtest/datafile/undotbs1.12320.1109773657
input datafile file number=00005 name=+SSDDG1/bpxtest/datafile/undotbs2.12311.1109773755
input datafile file number=00004 name=+SSDDG1/bpxtest/datafile/users.12318.1109773657
channel ORA_DISK_1: starting piece 1 at 2022-07-18 23:39:43
channel ORA_DISK_1: finished piece 1 at 2022-07-18 23:39:58
piece handle=/opt/oracle/products/11.2.0/dbs/0c12v29v_1_1 tag=TAG20220718T233943 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
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 2022-07-18 23:39:59
channel ORA_DISK_1: finished piece 1 at 2022-07-18 23:40:00
piece handle=/opt/oracle/products/11.2.0/dbs/0d12v2ae_1_1 tag=TAG20220718T233943 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2022-07-18 23:40:00