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. .

[@more@]

时间: 2024-08-01 23:44:30

zt:Different type of RMAN backup compression in 11G的相关文章

rman backup遇到ORA-19811

在对数据库进行备份的时候,使用了backup的 keep 选项,遇到了一个错误 ORA-19811. Recovery Manager: Release 11.2.0.4.0 - Production on Tue Dec 24 13:39:49 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. connected to target database: ANDREA run {

[20171121]rman backup as copy.txt

[20171121]rman backup as copy.txt --//上个星期做数据文件块头恢复时,提到使用rman备份数据文件时,文件头数据库信息是最后写入备份集文件的,在filesperset=1的情况 --//下写入备份集文件中的倒数第2块就是文件头的备份.参考链接: http://blog.itpub.net/267265/viewspace-2147297/=>[20171115]恢复数据文件块头4补充.txt --//而且我最后还做了测试证明如果resotre数据文件,实际上文

[20171121]rman backup as copy 2.txt

[20171121]rman backup as copy 2.txt --//昨天测试backup as copy ,备份时备份文件的文件头什么时候更新.是最后完成后还是顺序写入备份文件. --//我测试的数据文件使用数据文件2(表空间sysaux),也许是文件不够大,应该减慢备份速度来测试看看. 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ----------------

[20171122]rman backup as copy的备份问题

[20171122]rman backup as copy的备份问题.txt --//以前曾经写过一篇[20160524]rman备份与检查点4.txt=>链接:http://blog.itpub.net/267265/viewspace-2106087/ --//里面提到加入备份时间很长,这样可能会出现数据块里面的scn号大于文件头scn号.我提到视图v$backup_datafile --//的ABSOLUTE_FUZZY_CHANGE#字段记录了备份时块最大的scn号.查询视图: sele

RMAN backup validate database on databases in noarchivelog mode

从11g开始oracle rman允许在非归档模式下备份数据库 sys@rac1>archive log list 数据库日志模式             非存档模式 自动存档             禁用 存档终点            d:\oracle\archive 最早的联机日志序列     42 当前日志序列           44 sys@rac1>host Microsoft Windows [版本 6.1.7600] 版权所有 (c) 2009 Microsoft Corp

Oracle 通过odu验证rman backup对于truncate对象备份处理

通过odu挖rman备份前和备份后的数据文件,得知rman backup备份的过程,对绝大多数truncate的表的原始数据未正常备份(为什么是绝大多数,我无法给出解释),这里也可以看出rman backup并非是真正意义上的完全物理上复制(和rman copy还是有区别,copy不能完全被取代) 创建模拟环境  代码如下 复制代码 SQL> select * from v$version;    BANNER ------------------------------------------

动手写个数字输入框1:input[type=number]的遗憾

前言  最近在用Polymer封装纯数字的输入框,开发过程中发现不少坑,也有很多值得研究的地方.本系列打算分4篇来叙述这段可歌可泣的踩坑经历: <动手写个数字输入框1:input[type=number]的遗憾> <动手写个数字输入框2:起手式--拦截非法字符> <动手写个数字输入框3:痛点--输入法是个魔鬼> <动手写个数字输入框4:魔鬼在细节--打磨光标位置> HTML5带来的福利-input[type=number] <input id=&quo

ZT:数据库Oracle11g新特性RMAN

http://soft.zdnet.com.cn/software_zone/2007/0719/427418.shtml RMAN除了单纯的备份恢复功能,已经被赋予了越来越多的责任,比如创建Standby数据库,比如跨平台传输表空间中的表空间转换.Oracle11g的RMAN倒是没有太多飞跃性的更新.1. 自定义archivelog删除策略 我们知道在11g之前,只有backupset的删除策略可以定义,比如保留多长时间的备份或者保留多少份有效备份,而删除归档日志只有在delete命令中定义删

RMAN-03002, RMAN-06059, ORA-19625 and ORA-27037 When Running RMAN Backup of Archivelogs

RMAN备份数据库时,出现下面错误错误信息: Starting backup at 25-MAY-15 current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=953 devtype=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR