RMAN Compressed Backupset

看一段官方文档的解释:


There is some CPU overhead associated with compressing backup sets. If the database being backed up is running at or near its maximum load, you may find the overhead from using AS COMPRESSED BACKUPSET unacceptable. In most other circumstances, compressing backupsets saves enough disk space to be worth the CPU overhead


总之、占用更多的 CPU 开销、但备份集减小了
测试一把(平台:10gR2 redhat):

不使用压缩备份


RMAN> list backup;

RMAN> list copy;

RMAN> backup database plus archivelog delete all input;

RMAN> list backup;

Size       Device     Elapsed Time  
------- ---- -- --- ------ -------- 
606.06M    DISK        00:01:26     


使用压缩备份


RMAN> list backup;

RMAN> list copy;

RMAN> backup as compressed backupset database plus archivelog delete all input;

RMAN> list backup;

Size       Device     Elapsed Time  
------- ---- -- --     ----- ------
112.27M    DISK        00:01:43     



适用场景

在CPU并不是主要瓶颈的系统中、可以启动压缩备份
但库比较大的话、建议使用Image Copy Incremental Updates(ICIU)策略来解决

grid@rac11g01 ~]$ #!/bin/bash [grid@rac11g01 ~]$ source ~/.bash_profile [grid@rac11g01 ~]$ backup_log=/home/oracle/ORCL_full_`date +"%Y%m%d"`.log allocate channel ch4 type disk; backup AS COMPRESSED BACKUPSET incremental level=0 database format '/db_backup/%d_FULL_%T_%s_%p.bak'; backup AS COMPRESSED BACKUPSET archivelog all format '/db_backup/%d_ARC_%T_%s_%p.bak' delete input; backup current controlfile format '/db_backup/%d_CTL_%T_%s_%p.bak'; release channel ch1; release channel ch2; release channel ch3; release channel ch4; } exit; EOF[grid@rac11g01 ~]$ [grid@rac11g01 ~]$ rman target / nocatalog msglog $backup_log append << EOF > run { > allocate channel ch1 type disk; > allocate channel ch2 type disk; > allocate channel ch3 type disk; > allocate channel ch4 type disk; > > backup AS COMPRESSED BACKUPSET incremental level=0 database format '/db_backup/%d_FULL_%T_%s_%p.bak'; > backup AS COMPRESSED BACKUPSET archivelog all format '/db_backup/%d_ARC_%T_%s_%p.bak' delete input; > backup current controlfile format '/db_backup/%d_CTL_%T_%s_%p.bak'; > > release channel ch1; > release channel ch2; > release channel ch3; > release channel ch4; > } > exit; > EOF RMAN-00557: could not open MSGLOG "/home/oracle/ORCL_full_20250604.log" Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jun 4 20:30:57 2025 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-12001: could not open channel default RMAN-10008: could not create channel context RMAN-10002: ORACLE error: ORA-15021: parameter "remote_dependencies_mode" is not valid in asm instance RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature [grid@rac11g01 ~]$
最新发布
06-05
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值