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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle RMAN備份以及壓縮原理分析Oracle
- [20210527]rman與undo表空間備份.txt
- QQ 空間備份神器，一鍵備份你所有的青春！
- Oracle 12C RMAN備份佔用大量臨時表空間Oracle
- win10備份空間不足怎麼辦_win10備份空間不足如何處理Win10
- ＬＩｎｕｘ＿壓縮和備份
- 備份集和備份片之間的關係
- Oracle RMAN備份為什麼會大量使用temp表空間？Oracle
- 【PG備份恢復】pg_basebackup 多表空間備份恢復測試
- SYSTEM 表空間管理及備份恢復
- MySQL 遷移表空間，備份單表MySql
- 寶塔自動備份網站到FTP空間網站FTP
- Mac時間機器備份加速教程，Time Machine 備份太慢的解決方法Mac
- mysqldump壓縮備份匯出匯入（含定期備份shell指令碼）MySql指令碼
- PostgreSQL從小白到高手教程 - 第41講：postgres表空間備份與恢復SQL
- Liunx運維(六)-檔案備份與壓縮命令運維
- 如何使用時間機器備份您的MacMac
- win10備份要多大空間_win10系統備份需要多少記憶體Win10記憶體
- 快速上手Linux核心命令（九）：檔案備份與壓縮Linux
- 【RMAN】當表空間處於備份狀態時發生了什麼
- mysql的冷備份與熱備份MySql
- Oracle 備份 與 恢復 概述Oracle
- ORACLE 備份表Oracle
- oracle 如何不備份已經備份的歸檔Oracle
- mongodb使用備份後的oplog做時間點恢復MongoDB
- oracle資料庫備份之exp增量備份Oracle資料庫
- ORACLE常用定時備份指令碼Oracle指令碼
- 備份與恢復oracle_homeOracle
- ORACLE DG從庫 Rman備份恢復Oracle
- ORACLE備份策略(轉)Oracle
- ORACLE備份指令碼Oracle指令碼
- Networker備份oracle racOracle
- 【BAK_ORACLE】Oracle 12c之CDB與PDB的備份與恢復（三）CDB與PDB的備份方式Oracle
- 帝國CMS備份資料壓縮存放目錄
- PostgreSQL12中實現增量備份與任意時間點恢復SQL
- Mysql備份與恢復(1)---物理備份MySql
- 基於Linux指令碼，對日誌進行定時壓縮備份Linux指令碼
- GitLab的自動備份、清理備份與恢復Gitlab
- 天翼云云主機快照、雲硬碟備份、雲主機備份之間的區別硬碟