oracle增量的0级备份,0级增量备份脚本(示例)

create script bak_0{

crosscheck backup;

crosscheck archivelog all;

allocate channel c1 type disk maxpiecesize = 200000m;

sql 'alter system archive log current';

backup incremental level 0 skip inaccessible database tag 'inc_0' format '/oralce/ora_rman/bak_0%p_%s_%t.bak' filesperset 4

include current controlfile plus archivelog tag 'arc_0' format '/oracle/ora_rman/bak_arc%U.bak' filesperset 2

delete all input;

delete obsolete;

release channel c1;

}

PS:脚本来源《Oracle高性能自动化运维》

  • 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、付费专栏及课程。

余额充值