Compressed backups

最新推荐文章于 2025-12-04 07:03:54 发布
转载 最新推荐文章于 2025-12-04 07:03:54 发布 · 622 阅读 · 1
文章标签：

#compression #database #initialization #command #oracle #image

本文介绍了如何通过使用RMAN命令实现数据库的压缩备份，从而减小备份集占用的空间。重点阐述了压缩备份的限制条件及配置方法，包括将设备类型设置为并行处理和自动压缩备份集。
 

Compressed backups reduce the amount of space required for storing backup sets. You create a compressed backup of a database by using the command:

RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;

The compressed backup set feature cannot be used with pre–Oracle Database10gdatabases. The COMPATIBILITY database initialization parameter must be set to at least10.0.0.0. The compression applies only to backup sets, not image copies.

You can configure RMAN to automatically make compressed backup sets with the CONFIGURE DEVICE TYPE command:

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2

2> BACKUP TYPE TO COMPRESSED BACKUPSET;

By default compression is disabled.

Limitations of MySQL Online Backup Solutions
AI天才研究院
09-16 2180
作者：禅与计算机程序设计艺术 1.简介 As the name suggests, MySQL online backup solutions aim to provide real-time backups and restore capabilities in an efficient way fo
MySQL备份利器系列之MySQL Enterprise Backup 使用详解从入门到实战
专注于编程、AI、人工智能等多个领域内容研究和分析
08-07 341
MySQL Enterprise Backup (MEB) 是Oracle官方提供的企业级MySQL热备份工具，支持在线备份、增量备份等核心功能。本文详细介绍了MEB的安装配置、基础备份操作（包括完整备份和增量备份命令）、恢复流程以及压缩、加密等高级功能。特别分析了MEB最适合的大型生产数据库、24/7高可用系统等场景，并提供了性能优化建议和常见问题解答。通过本文，读者可以掌握MEB从安装到实战应用的全流程，了解如何利用这一工具提高MySQL数据库的备份效率和恢复速度。
关于压缩的备份集---compressed backupset
甲骨文可乐的专栏
07-08 1213
文档地址：http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta009.htm#RCMRF107 backupTypeSpec::= -----这是备份成备份集的图 backupTypeSpec Syntax Element Description AS [ COMPRESSED ] BACKUPSET C
RMAN-压缩选项(as compressed backupset)
gxftry1st的专栏
07-09 1536
转载▼     Oracle10g允许你和BACKUP命令伴随使用AS COMPRESSED BACKUPSET字句，对备份集进行压缩。 这个压缩备份在恢复时无需解压缩，这一特性在以下条件下可能大为有益: 1.你的备份存储空间有限 2.通过网络备份而带宽有限 3.直接备份至磁带、CD，DVD介质而压缩不可用 你可以选择在备份命
053试题 73/485 - compressed backup
文档搬运工
08-14 322
题目： 73.You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.) A. You are backing up to tape and your tape device pe...
RMAN 备份详解
DBA Tips
04-14 597
一、数据库备份与RMAN备份的概念         1.数据库完全备份：按归档模式分为归档和非归档         归档模式             打开状态，属于非一致性备份             关闭状态，可以分为一致性和非一致性         非归档模式             打开状态，非一致性备份无效             关闭状态，一致性备份，非一致性备份不被推
OCP-1Z0-053-V12.02-53题
一抹曦阳-Oracle
11-03 7640
53.You want to use RMAN to create compressed backups. Which statement is true about the compression algorithms that RMAN can use? A. The BZIP2 compression algorithm consumes more CPU resources than
MySQL Compressed Backup
Zhong Weicheng Study Notes
11-04 1625
[root@test zwc]# ls -lh total 953M -rw-rw---- 1 mysql mysql   61 Nov  3 22:03 db.opt -rw-rw---- 1 mysql mysql 8.5K Nov  3 22:10 t1.frm -rw-rw---- 1 mysql mysql 191M Nov  3 22:25 t1.MYD -rw-rw----
【RMAN】使用RMAN的 Compressed Backupsets备份压缩技术 （转载）
weixin_34128501的博客
07-17 358
1.Oracle参考文档中关于RMAN备份压缩的描述1）关于如何通过调整RMAN参数启用取消备份压缩功能http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup004.htm#sthref229使用关键字COMPRESSED启用RMAN压缩备份方法RMAN> CONFIGURE DEVICE TYPE DISK ...
MSSQL Compressed Backup-开源
05-03
MSSQL压缩备份使用bzip2，zip或gzip压缩即时压缩SQL Server 2000、2005和2008数据库。 它以标准SQL Server备份文件格式保存数据，以便可以使用标准的解压缩和还原工具。
backup full format '/orabak/rman_backup/full_%T_%d_%U' database plus archivelog; 这一行如何添加 as compressed
05-29
backup as compressed backupset full format '/orabak/rman_backup/full_%T_%d_%U' database plus archivelog; ``` #### 2. **压缩效果说明** - 使用该命令后，备份集（包括数据库和归档日志）将采用Oracle默认的...
修改为使用磁盘备份 并添加释放通道rman target / log=$LOG_DIR/full_backup.log <<EOF CONFIGURE RETENTION POLICY TO REDUNDANCY 2; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE DEVICE TYPE DISK PARALLELISM 4; RUN { # 分配通道（必须在 RUN 块内） ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT '$BACKUP_DIR/full_%d_%T_%U.bkp'; ALLOCATE CHANNEL ch2 DEVICE TYPE DISK FORMAT '$BACKUP_DIR/full_%d_%T_%U.bkp'; ALLOCATE CHANNEL ch3 DEVICE TYPE DISK FORMAT '$BACKUP_DIR/full_%d_%T_%U.bkp'; ALLOCATE CHANNEL ch4 DEVICE TYPE DISK FORMAT '$BACKUP_DIR/full_%d_%T_%U.bkp'; # 执行备份命令 BACKUP AS COMPRESSED BACKUPSET SPFILE; # 备份spfile BACKUP AS COMPRESSED BACKUPSET DATABASE INCLUDE CURRENT CONTROLFILE; # 备份数据文件和控制文件 #BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL DELETE ALL INPUT; # 备份归档，并删除已备份归档 BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG UNTIL TIME 'SYSDATE-0.04' DELETE ALL INPUT; copy current controlfile to '/backup/full_bk/control_airexdb3.ctl'; # 复制控制文件到本地备份 # 清理过期备份 CROSSCHECK BACKUP; # 校验备份有效性 DELETE NOPROMPT OBSOLETE; # 清理过期备份 } EOF
03-19
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG; DELETE OBSOLETE; } ``` --- ### 注意事项 1. **日志检查**：备份完成后检查`RMAN`输出日志，确认无`ORA-`错误。 2. **控制文件备份**：建议启用自动...
SQL SERVER BACKUP DATABASE 加快备份速度方法（压缩-Compression）
热门推荐
学无止境
03-31 1万+
很多SQL SERVER DBA 在备份的时候，一般的撰写格式，都是如下 BACKUP DATABASE AdventureWorks TO DISK = 'Z:\SQLServerBackups\AdvWorksData.bak'    WITH FORMAT,CHECKSUM; 对于比较大的数据库，备份时间比较长， 最近在研究了BACKUP DATABASE 参数后，发现可以通过设置
1z0-883 mysql_MySQL 5.6 Database Administrator 1Z0-883
weixin_30017913的博客
01-26 793
1.A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY'' ...
【RMAN】使用RMAN的 Compressed Backupsets备份压缩技术
cuanchuwei1207的博客
07-21 319
1.Oracle参考文档中关于RMAN备份压缩的描述1）关于如何通过调整RMAN参数启用取消备份压缩功能http://download.oracle.com/docs/cd/B19306_01/backup.102/b...
架构设计过去十年与未来十年
weixin_40213018的博客
10-21 606
架构十年 过去的十年，刘海锋与架构一同成长。他认为，架构领域经历了快速演进的十年。架构领域在整个互联网的技术栈是偏底层的，但过去十年架构领域的演进速度，一点都不亚于应用开发，甚至移动端开发的速度。比如容器，新型的数据库，新型的中间件，大规模集群的调度，以及系统跟算法的结合，在很多方面都出现了新的变化，甚至是出现了里程碑式的进步。 在具体的变化方面，刘海锋列举了三点，第一点是容器。把所有的东西都放在容器里，这是以前从没有过的。到今天，我们不光把应用的部署放在容器里，很多有状态的服务，包括缓存，..
【MySQL】表的基本操作
2509_94196848的博客
12-01 871
创建表可指定字符集和存储引擎，不指定字符集和存储引擎默认为 InnoDB存储引擎 和 utf8mb4字符集。查看当前数据库的表，和查看具体表结构是不同概念，使用不同语句查看。表的修改和删除涉及等关键字。本文内容到此结束，如果感觉有帮助的话，还望给博主一个赞~~
Navicat Oracle数据库连接失败，报错：Oracle library is not loaded
最新发布
默默提升实验室
12-04 268
Navicat Oracle数据库连接失败，报错：Oracle library is not loaded
SQL Server 创建用户并授权
2509_94201067的博客
12-01 287
创建用户前需要有一个数据库，创建数据库命令如下：CREATE DATABASE [数据库名称];
xtra_backup
12-28
### Percona XtraBackup MySQL Backup Tool Usage and Download Percona XtraBackup is a powerful tool designed to perform non-blocking backups of MySQL databases, including InnoDB and MyISAM tables. This utility supports incremental backups, compressed backups, partial backups, and more advanced features. #### Installation on RHEL/CentOS Systems For installing Percona XtraBackup on Red Hat Enterprise Linux (RHEL) or CentOS systems, the process involves adding the official repository followed by installation through `yum`. The command sequence ensures that all dependencies are correctly managed: ```bash sudo yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm sudo percona-release setup tools sudo yum install -y percona-xtrabackup-80 ``` Optionally, if compression support during backup operations is desired, QPress can be installed as well[^1]: ```bash sudo yum install -y qpress ``` #### Basic Usage Example To create a full backup using Percona XtraBackup, one would typically use the following commands within an environment where the necessary permissions have been granted for accessing database files directly from disk: ```bash innobackupex --user=root --password=your_password /path/to/backup_directory/ ``` After completing this operation successfully, preparing the backed-up data before restoring it into another instance requires executing prepare phase which applies redo logs onto copied pages ensuring consistency: ```bash innobackupex --apply-log /path/to/backup_directory/ ``` Finally, when ready to restore such prepared snapshot back into production server's datadir location, stopping mysqld service first then copying over contents while preserving ownership & privileges accordingly becomes essential step prior applying changes permanently via restart mechanism[^2]. --related questions-- 1. What additional options does Percona XtraBackup offer beyond standard functionality? 2. How do you configure automated scheduled backups with Percona XtraBackup? 3. Can Percona XtraBackup handle very large datasets efficiently without impacting performance significantly? 4. Are there any specific security considerations when performing remote backups using Percona XtraBackup?
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值