增量备份和累积备份包括0,1,2,3,4,5五个备份级别

10g,仍然保留了这五种备份级别,但将来的版本会逐步淘汰2,3,4三个级别。其中,级别0相当于完全备份,会备份数据文件的所有已用数据块,而其它级别只会备份相应级别最近一次备份以来变化的数据块。增量级别的数据字值越大,备份的数据块相对越少。当制定备份策略时,如果要采用增量备份和累积备份,则必须首先进行增量0级备份。

增量备份:增加备份是指备份更低级别和相同级别最近一次备份以来变化的数据块,增量备份的基础是增量0级备份。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
下面是 Oracle 数据库的 0、1、2 级增量备份和完整备份备份脚本示例: 1. 完整备份脚本 ``` #!/bin/bash # Oracle Database full backup script # Author: Your Name # Set up environment variables export ORACLE_SID=your_SID export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export PATH=$PATH:$ORACLE_HOME/bin export NLS_DATE_FORMAT='YYYY-MM-DD_HH24:MI:SS' # Set up backup directory backup_dir=/backup/oracle/full if [ ! -d "$backup_dir" ]; then mkdir -p "$backup_dir" fi # Backup database rman target / <<EOF run { allocate channel ch1 device type disk; backup as compressed backupset database format '$backup_dir/full_%d_%T.bkp'; backup as compressed backupset archivelog all format '$backup_dir/arch_%d_%T.bkp'; release channel ch1; } exit; EOF # Clean up old backups find $backup_dir -type f -mtime +7 -delete ``` 这个脚本备份包括完整备份和归档日志备份备份文件存储在 `/backup/oracle/full` 目录下。备份文件使用压缩备份集格式。同时,脚本会定期清理七天前的备份文件,以节省存储空间。 2. 0 级增量备份脚本 ``` #!/bin/bash # Oracle Database 0-level incremental backup script # Author: Your Name # Set up environment variables export ORACLE_SID=your_SID export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export PATH=$PATH:$ORACLE_HOME/bin export NLS_DATE_FORMAT='YYYY-MM-DD_HH24:MI:SS' # Set up backup directory backup_dir=/backup/oracle/0_level if [ ! -d "$backup_dir" ]; then mkdir -p "$backup_dir" fi # Backup database rman target / <<EOF run { allocate channel ch1 device type disk; backup as compressed backupset incremental level 0 format '$backup_dir/0_level_%d_%T.bkp' database; backup as compressed backupset archivelog all format '$backup_dir/arch_%d_%T.bkp'; release channel ch1; } exit; EOF # Clean up old backups find $backup_dir -type f -mtime +7 -delete ``` 这个脚本是 0 级增量备份备份脚本。备份文件存储在 `/backup/oracle/0_level` 目录下。备份文件使用压缩备份集格式。同时,脚本会定期清理七天前的备份文件,以节省存储空间。 3. 1 级增量备份脚本 ``` #!/bin/bash # Oracle Database 1-level incremental backup script # Author: Your Name # Set up environment variables export ORACLE_SID=your_SID export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export PATH=$PATH:$ORACLE_HOME/bin export NLS_DATE_FORMAT='YYYY-MM-DD_HH24:MI:SS' # Set up backup directory backup_dir=/backup/oracle/1_level if [ ! -d "$backup_dir" ]; then mkdir -p "$backup_dir" fi # Backup database rman target / <<EOF run { allocate channel ch1 device type disk; backup as compressed backupset incremental level 1 format '$backup_dir/1_level_%d_%T.bkp' database; backup as compressed backupset archivelog all format '$backup_dir/arch_%d_%T.bkp'; release channel ch1; } exit; EOF # Clean up old backups find $backup_dir -type f -mtime +7 -delete ``` 这个脚本是 1 级增量备份备份脚本。备份文件存储在 `/backup/oracle/1_level` 目录下。备份文件使用压缩备份集格式。同时,脚本会定期清理七天前的备份文件,以节省存储空间。 4. 2 级增量备份脚本 ``` #!/bin/bash # Oracle Database 2-level incremental backup script # Author: Your Name # Set up environment variables export ORACLE_SID=your_SID export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export PATH=$PATH:$ORACLE_HOME/bin export NLS_DATE_FORMAT='YYYY-MM-DD_HH24:MI:SS' # Set up backup directory backup_dir=/backup/oracle/2_level if [ ! -d "$backup_dir" ]; then mkdir -p "$backup_dir" fi # Backup database rman target / <<EOF run { allocate channel ch1 device type disk; backup as compressed backupset incremental level 2 format '$backup_dir/2_level_%d_%T.bkp' database; backup as compressed backupset archivelog all format '$backup_dir/arch_%d_%T.bkp'; release channel ch1; } exit; EOF # Clean up old backups find $backup_dir -type f -mtime +7 -delete ``` 这个脚本是 2 级增量备份备份脚本。备份文件存储在 `/backup/oracle/2_level` 目录下。备份文件使用压缩备份集格式。同时,脚本会定期清理七天前的备份文件,以节省存储空间。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值