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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Using RMAN REPORT NEED BACKUP with Different Retention Policies
- oracle 11g rman backup scriptOracle
- Oracle OCP 1Z0 053 Q688(RMAN Backup Compression)Oracle
- The different between cumulative and differential incremental backupREM
- Rman Backups When The Directory Structures Are DifferentStruct
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- rman backup script(引用)
- Rman backup standby databaseDatabase
- DP rman backup scripts
- Oracle 11g RMAN備份-RMAN的backup database plus archivelog命令背後的操作OracleDatabaseHive
- Oracle 11g Advanced Compression(上)Oracle
- Oracle 11g Advanced Compression(下)Oracle
- Oracle 學習(Rman Backup)Oracle
- rman backup database force 功能Database
- [zt] RMAN的原理
- Oracle 12C Transport a Database to a Different Platform Using Backup SetsOracleDatabasePlatform
- V$RMAN_BACKUP_JOB_DETAILSAI
- RMAN cumulative and differential incremental backupREM
- Oracle OCP 1Z0-053(Rman Compression Algorithm)OracleGo
- DUPLICATE (Backup based) DATABASE from non ASM to ASM to different host_382669.1DatabaseASM
- How to use rman backup a noarchivelog databaseHiveDatabase
- 轉貼_RMAN-DBMS_BACKUP_RESTOREREST
- RMAN跨平臺傳輸表空間(different Endian)
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- 理解RMAN backup database plus archivelog命令DatabaseHive
- NBU report error 6 when RMAN backupError
- Restore Rman Backups On A Different Node When The Directory Are Diff_419137.1REST
- RMAN : Consistent Backup, Restore and Recovery using RMAN (Doc ID 162855.1)REST
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- Oracle 11G support different OS Platform DataGaurd ( windows and linux )OraclePlatformWindowsLinux
- zt_oracle lock type鎖型別詳解Oracle型別
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- rman backup ENCRYPTION(備份加密特性)測試!加密
- RMAN backup validate database on databases in noarchivelog modeDatabaseHive
- rman backup as copy database format '/tmp/%U.dbf'DatabaseORM
- [zt] Oracle 11g DataGuard 配置Oracle
- Backup And Recovery User's Guide-RMAN架構-RMAN庫(Repository)GUIIDE架構
- RMAN backup fails with Ora-00245 And Rman-08132 [ID 1365484.1]AI