oracle 壓縮備份與普通備份從空間，時間，CPU效能的比較
[oracle@gl ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jan 12 21:11:15 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DB11G (DBID=299228420)
RMAN> backup database ;
Starting backup at 12-JAN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=45 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=54 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=41 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=00001 name=/data/oradata/DB11G/system01.dbf
input datafile file number=00003 name=/data/oradata/DB11G/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 12-JAN-14
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=/data/oradata/DB11G/sysaux01.dbf
input datafile file number=00004 name=/data/oradata/DB11G/users01.dbf
channel ORA_DISK_2: starting piece 1 at 12-JAN-14
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_3: starting piece 1 at 12-JAN-14
channel ORA_DISK_3: finished piece 1 at 12-JAN-14
piece handle=/data/flash_recovery_area/DB11G/backupset/2014_01_12/o1_mf_ncnnf_TAG20140112T211144_9f554td8_.bkp tag=TAG20140112T211144 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:24
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_3: starting piece 1 at 12-JAN-14
channel ORA_DISK_3: finished piece 1 at 12-JAN-14
piece handle=/data/flash_recovery_area/DB11G/backupset/2014_01_12/o1_mf_nnsnf_TAG20140112T211144_9f555rco_.bkp tag=TAG20140112T211144 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:33
channel ORA_DISK_2: finished piece 1 at 12-JAN-14
piece handle=/data/flash_recovery_area/DB11G/backupset/2014_01_12/o1_mf_nnndf_TAG20140112T211144_9f554qtm_.bkp tag=TAG20140112T211144 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:02:15
channel ORA_DISK_1: finished piece 1 at 12-JAN-14
piece handle=/data/flash_recovery_area/DB11G/backupset/2014_01_12/o1_mf_nnndf_TAG20140112T211144_9f554l55_.bkp tag=TAG20140112T211144 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:35
Finished backup at 12-JAN-14
正常的全備份需要的時間： 為四個紅色背景的顏色之和 24 + 32 + 135 + 155 = 346 秒
==================================================================================================
RMAN> backup as compressed backupset database ;
Starting backup at 12-JAN-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/data/oradata/DB11G/system01.dbf
input datafile file number=00003 name=/data/oradata/DB11G/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 12-JAN-14
channel ORA_DISK_2: starting compressed full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=/data/oradata/DB11G/sysaux01.dbf
input datafile file number=00004 name=/data/oradata/DB11G/users01.dbf
channel ORA_DISK_2: starting piece 1 at 12-JAN-14
channel ORA_DISK_3: starting compressed full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_3: starting piece 1 at 12-JAN-14
channel ORA_DISK_3: finished piece 1 at 12-JAN-14
piece handle=/data/flash_recovery_area/DB11G/backupset/2014_01_12/o1_mf_ncnnf_TAG20140112T211902_9f55l9gp_.bkp tag=TAG20140112T211902 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:09
channel ORA_DISK_3: starting compressed full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_3: starting piece 1 at 12-JAN-14
channel ORA_DISK_3: finished piece 1 at 12-JAN-14
piece handle=/data/flash_recovery_area/DB11G/backupset/2014_01_12/o1_mf_nnsnf_TAG20140112T211902_9f55llpd_.bkp tag=TAG20140112T211902 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_2: finished piece 1 at 12-JAN-14
piece handle=/data/flash_recovery_area/DB11G/backupset/2014_01_12/o1_mf_nnndf_TAG20140112T211902_9f55l8yx_.bkp tag=TAG20140112T211902 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:42
channel ORA_DISK_1: finished piece 1 at 12-JAN-14
piece handle=/data/flash_recovery_area/DB11G/backupset/2014_01_12/o1_mf_nnndf_TAG20140112T211902_9f55l8c4_.bkp tag=TAG20140112T211902 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:52
Finished backup at 12-JAN-14
可以看出壓縮消費的時間為： 9 + 4 + 104 + 112 = 229 秒
實驗表明：壓縮備份，消耗時間少一些。
====================================================================================================
[root@gl ~]# top
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6582 oracle 18 0 534m 49m 33m D 6.3 4.9 0:01.07 oracle
6580 oracle 18 0 534m 54m 31m D 3.4 5.4 0:01.37 oracle
壓縮備份：
[root@gl ~]# top
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6580 oracle 16 0 549m 69m 41m D 51.1 6.9 0:15.58 oracle
6582 oracle 17 0 549m 65m 42m D 16.2 6.5 0:09.95 oracle
比較得知： 壓縮備份消耗的CPU比例比較大。
=============================================================================================
普通備份大小查詢：
[root@gl 2014_01_12]# ll
total 275496
-rw-r----- 1 oracle oinstall 1114112 Jan 12 21:24 o1_mf_ncnnf_TAG20140112T212420_9f55w6kk_.bkp
-rw-r----- 1 oracle oinstall 189693952 Jan 12 21:25 o1_mf_nnndf_TAG20140112T212420_9f55w5hj_.bkp
-rw-r----- 1 oracle oinstall 90906624 Jan 12 21:25 o1_mf_nnndf_TAG20140112T212420_9f55w5vf_.bkp
-rw-r----- 1 oracle oinstall 98304 Jan 12 21:24 o1_mf_nnsnf_TAG20140112T212420_9f55wj7t_.bkp
壓縮備份大小查詢：
[root@gl 2014_01_12]# ll
total 1051560
-rw-r----- 1 oracle oinstall 9830400 Jan 12 21:32 o1_mf_ncnnf_TAG20140112T213232_9f56cl3c_.bkp
-rw-r----- 1 oracle oinstall 622133248 Jan 12 21:34 o1_mf_nnndf_TAG20140112T213232_9f56ckdc_.bkp
-rw-r----- 1 oracle oinstall 443662336 Jan 12 21:34 o1_mf_nnndf_TAG20140112T213232_9f56cpvt_.bkp
-rw-r----- 1 oracle oinstall 98304 Jan 12 21:32 o1_mf_nnsnf_TAG20140112T213232_9f56d1gz_.bkp
可以檢視到：比例大約為 1：5
===============================================================================================
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29196873/viewspace-1069809/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Rman增量壓縮備份來解決備份空間不足
- ORACLE備份中的壓縮Oracle
- Windows 備份oracle按時間命名WindowsOracle
- oralce 壓縮表與heap表儲存空間與查詢效能比較
- oracle監控表空間,JOB，rman備份Oracle
- Linux備份與壓縮命令Linux
- Oracle12c多租戶資料庫備份與恢復 - 備份表空間Oracle資料庫
- RMAN說，我能備份(3)--RMAN全庫備份和表空間備份
- Oracle RMAN備份以及壓縮原理分析Oracle
- win10備份空間不足怎麼辦_win10備份空間不足如何處理Win10
- Oracle 12C RMAN備份佔用大量臨時表空間Oracle
- Oracle資料庫的備份與恢復方式比較Oracle資料庫
- Oracle rman 備份與恢復 臨時表空間的檔案問題解決Oracle
- 【物理熱備】（下）備份恢復系統表空間 手工備份恢復
- 區別oracle 9i 與 oracle 10g 備份表空間Oracle 10g
- Unix備份與壓縮命令實踐（轉）
- oracle壓縮表表空間Oracle
- 備份集和備份片之間的關係
- 不同備份方法的特性比較
- 不同版本下的rman壓縮備份
- 基於表空間的熱備份指令碼指令碼
- RMAN說，我能備份(13)--RMAN中的備份壓縮和加密加密
- MySQL 遷移表空間，備份單表MySql
- 實戰RMAN備份傳輸表空間
- Backup And Recovery User's Guide-RMAN備份概念-備份集-備份集塊壓縮GUIIDE
- LINUX學習（二）備份與壓縮命令Linux
- [DB2]線上備份資料庫與表空間DB2資料庫
- [Oracle] rman備份channel數量和時間測試.Oracle
- Backup And Recovery User's Guide-RMAN備份概念-備份集塊壓縮-未使用塊壓縮GUIIDE
- Oracle RMAN備份為什麼會大量使用temp表空間？Oracle
- Mac時間機器備份加速教程，Time Machine 備份太慢的解決方法Mac
- 雙機備份和叢集的原理與比較
- mysqldump壓縮備份匯出匯入（含定期備份shell指令碼）MySql指令碼
- 寶塔自動備份網站到FTP空間網站FTP
- 透過rman備份system系統表空間
- mysql無備份恢復-獨立表空間MySql
- 表空間級資料庫備份恢復資料庫
- RMAN相容性、控制檔案自動備份、儲存時間、備份策略、備份指令碼（二）指令碼