zt:Different type of RMAN backup compression in 11G
http://www.itpub.net/viewthread.php?tid=829560&pid=10201894&page=1&extra=#pid10201894
主題: Different type of RMAN backup compression in 11G
文件 ID: 註釋:427581.1 型別: REFERENCE
上次修訂日期: 31-JUL-2007 狀態: REVIEWED
In this Document
Purpose
Different type of RMAN backup compression in 11G
--------------------------------------------------------------------------------
Applies to:
Oracle Server - Enterprise Edition - Version: 11.0
Information in this document applies to any platform.
Purpose
In addition to the existing BZIP2 algorithm for binary compression of backup in oracle 10G, RMAN 11G executable also support ZLIB algorithm for the compress backup.ZLIB is the default compression for RMAN in 11G
Different type of RMAN backup compression in 11G
RMAN support binary compression of backup sets.You can choose which compression algorithm that RMAN uses for backups.By default, RMAN uses ZLIB compression.
ZLIB Compression is very fast but compression ratio is not as good as other algorithm.
BZIP2 Compression ratio is very good but is slower than ZLIB
If the COMPATIBLE initialization parameter is set to 11.0 or higher , then the default compression for RMAN backups is ZLIB. IF the COMPATIBILITY initialization parameter is set lower than 11.0 and greater than 10.2 then the default and only possible compression algorithm is BZIP2
Compression can be used for backupset of datafile, archive log and controlfiles.
e.g
RMAN> backup as compressed backupset archivelog all;
RMAN> backup as compressed backupset database;
RMAN> backup as compressed backupset current controlfile;
RMAN compress the backupset contents before writing to disk.No extra decompression steps are required during recovery for rman compressed backup;
To configure the compression algorithm
CONFIGURE COMPRESSION ALGORITHM '
--------------------------------------------------------------------------------
Help us improve our service. Please email us your comments for this document. .
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-1002972/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- Oracle 11G RAC複製備庫RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 RMAN-10038Oracle
- RMAN-03009: failure of backup command on ORA_DISK_1 channelAI
- Oracle案例03——RMAN-06091: no channel allocated for maintenance (of an appropriate type)OracleAINaNAPP
- 3.5 Different
- Unused Block Compression和Null Block CompressionBloCNull
- Different AG groups have the exactly same group_id value if the group names are same and the ‘CLUSTER_TYPE = EXTERNAL/NONE’None
- Windows oracle 11g rman備份恢復到linux系統WindowsOracleLinux
- 11.23 Two Different Worlds
- different random numbers generatorrandom
- 2.3.3.3.2 Applications at Different VersionsAPP
- Encoder Data compression
- CF1408F Two Different
- INSTEAD OF(zt)
- lsof(zt)
- md_backup
- Script of Narrative Writing from different point of viewView
- [LeetCode] 3163. String Compression IIILeetCode
- Enhanced Invertible Encoding for Learned Image CompressionEncoding
- LZ4 compression algorithm on FPGAGoFPGA
- codeforces1450D. Rating Compression
- expdp+compression效能測試
- SQLSERVER SELECT(zt)SQLServer
- V$LOCK(zt)
- EXISTS、IN、NOT EXISTS、NOT IN(zt)
- Event Reference(zt)
- oracle enqueue(zt)OracleENQ
- Fallacies Of The CBO(zt)
- 【RMAN】RMAN備份至ASMASM
- 【RMAN】RMAN的備份保留策略
- MODEL COMPRESSION VIA DISTILLATION AND QUANTIZATION翻譯
- DBMS_PROFILER(zt)
- oracle event 2 (zt)Oracle
- ORA-00604(zt)
- 物化檢視(zt)
- SQL Access Advisor(zt)SQL
- DBMS_SUPPORT(zt)