【RMAN】RMAN备份恢复3 RMAN增量备份脚本与crontab计划任务

最新推荐文章于 2024-07-08 21:32:26 发布
最新推荐文章于 2024-07-08 21:32:26 发布
阅读量309 收藏 1
点赞数
文章标签： 数据库
RMAN备份恢复3
RMAN增量备份脚本与crontab计划任务

【RMAN增量备份】

差异性增量备份 differential incremental backup，备份最近一次0级或1级备份之后发生改变的数据块。
累积性增量备份 cumulative incremental backup，备份最近一次0级备份之后发生改变的数据块。

下面实验使用默认的 差异增量备份
备份策略：每周日执行0级备份，周一至周六每天执行1级增量备份
测试环境 整点进行0级备份，每10分钟1级增量备份一次

【实验环境】
OS:RHEL 6.4-64bit
DB:oracle 11gR2 (11.2.0.3)



【创建目录】
创建rman热备目录
[oracle@rhel64 ~]$ mkdir -p /u01/app/oracle/backup/rman_hot

创建备份脚本目录
[oracle@rhel64 ~]$ mkdir  /u01/app/oracle/scripts


【配置rman】
RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_PROD.f'; # default


【编写rman 0级增量备份脚本】


[oracle@rhel64 ~]$ cat /u01/app/oracle/scripts/PROD_rman_level0.sh
#!/bin/sh

export PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/practice/scripts:/home/oracle/bin
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=PROD
export PATH=$PATH:$ORACLE_HOME/bin

rman target / nocatalog msglog=/u01/app/oracle/backup/rman_hot/PROD_rman_`date +%Y%m%d-%H%M%S`_L0.log << EOF
run{
crosscheck backup;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup incremental level 0 database format '/u01/app/oracle/backup/rman_hot/db_%d_%T_%U.bak'
        plus archivelog format '/u01/app/oracle/backup/rman_hot/ar_%d_%T_%U.bak';
backup current controlfile format '/u01/app/oracle/backup/rman_hot/control_%d_%T_%U.bak';
report obsolete device type disk;
delete noprompt obsolete device type disk;
delete noprompt expired backup device type disk;
release channel c1;
release channel c2;
}

EOF
exit
[oracle@rhel64 ~]$


【编写rman 1级增量备份脚本】

[oracle@rhel64 ~]$ cat /u01/app/oracle/scripts/PROD_rman_level1.sh
#!/bin/sh

export PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/practice/scripts:/home/oracle/bin
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=PROD
export PATH=$PATH:$ORACLE_HOME/bin

rman target / nocatalog msglog=/u01/app/oracle/backup/rman_hot/PROD_rman_`date +%Y%m%d-%H%M%S`_L1.log << EOF
run{
crosscheck backup;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup incremental level 1 database format '/u01/app/oracle/backup/rman_hot/db_%d_%T_%U.bak'
        plus archivelog format '/u01/app/oracle/backup/rman_hot/ar_%d_%T_%U.bak';
backup current controlfile format '/u01/app/oracle/backup/rman_hot/control_%d_%T_%U.bak';
report obsolete device type disk;
delete noprompt obsolete device type disk;
delete noprompt expired backup device type disk;
release channel c1;
release channel c2;
}

EOF
exit
[oracle@rhel64 ~]$



[oracle@rhel64 ~]$ chmod a+x /u01/app/oracle/scripts/PROD_rman_level0.sh
[oracle@rhel64 ~]$ chmod a+x /u01/app/oracle/scripts/PROD_rman_level1.sh
[oracle@rhel64 ~]$

[oracle@rhel64 ~]$ ll /u01/app/oracle/scripts/
total 8
-rwxr-xr-x 1 oracle oinstall 946 May 11 18:51 PROD_rman_level0.sh
-rwxr-xr-x 1 oracle oinstall 948 May 11 18:51 PROD_rman_level1.sh
[oracle@rhel64 ~]$



【编辑计划任务】
测试环境 整点进行0级备份，每10分钟1级增量备份一次
[oracle@rhel64 ~]$ crontab -e

[oracle@rhel64 ~]$ crontab -l
0 * * * * /u01/app/oracle/scripts/PROD_rman_level0.sh >> /u01/app/oracle/scripts/PROD_hotrman_`date +\%Y\%m\%d-\%H\%M\%S`.log 2>&1
10,20,30,40,50 * * * * /u01/app/oracle/scripts/PROD_rman_level1.sh >> /u01/app/oracle/scripts/PROD_hotrman_`date +\%Y\%m\%d-\%H\%M\%S`.log 2>&1
[oracle@rhel64 ~]$



约2小时左右 观察备份情况、rman备份日志
均正常，则修改计划任务
【备份策略】
周日23点             进行0级备份
周一至周六23点   进行1级备份




测试环境 生成备份及备份日志

[oracle@rhel64 rman_hot]$ ls -lht
total 2.3G
-rw-r--r-- 1 oracle oinstall 9.9K May 13 23:30 PROD_rman_20160513-233001_L1.log               
-rw-r----- 1 oracle oinstall  10M May 13 23:30 control_PROD_20160513_4kr5h7kc_1_1.bak
-rw-r----- 1 oracle oinstall 4.0K May 13 23:30 ar_PROD_20160513_4jr5h7kb_1_1.bak
-rw-r----- 1 oracle oinstall 616K May 13 23:30 db_PROD_20160513_4ir5h7js_1_1.bak
-rw-r----- 1 oracle oinstall  72K May 13 23:30 db_PROD_20160513_4hr5h7js_1_1.bak
-rw-r----- 1 oracle oinstall 180K May 13 23:30 ar_PROD_20160513_4gr5h7jq_1_1.bak
-rw-r--r-- 1 oracle oinstall 9.2K May 13 23:20 PROD_rman_20160513-232001_L1.log
-rw-r----- 1 oracle oinstall 4.0K May 13 23:20 ar_PROD_20160513_4dr5h71k_1_1.bak
-rw-r----- 1 oracle oinstall 800K May 13 23:20 db_PROD_20160513_4cr5h714_1_1.bak
-rw-r----- 1 oracle oinstall 288K May 13 23:20 db_PROD_20160513_4br5h714_1_1.bak
-rw-r----- 1 oracle oinstall 823K May 13 23:20 ar_PROD_20160513_4ar5h713_1_1.bak
-rw-r--r-- 1 oracle oinstall 8.6K May 13 23:10 PROD_rman_20160513-231001_L1.log
-rw-r----- 1 oracle oinstall 3.5K May 13 23:10 ar_PROD_20160513_47r5h6er_1_1.bak
-rw-r----- 1 oracle oinstall 4.7M May 13 23:10 db_PROD_20160513_46r5h6ec_1_1.bak
-rw-r----- 1 oracle oinstall 128K May 13 23:10 db_PROD_20160513_45r5h6ec_1_1.bak
-rw-r----- 1 oracle oinstall 198K May 13 23:10 ar_PROD_20160513_44r5h6eb_1_1.bak
-rw-r--r-- 1 oracle oinstall  14K May 13 23:00 PROD_rman_20160513-230001_L0.log
-rw-r----- 1 oracle oinstall 2.1M May 13 23:00 ar_PROD_20160513_41r5h5sf_1_1.bak
-rw-r----- 1 oracle oinstall 436M May 13 23:00 db_PROD_20160513_40r5h5rk_1_1.bak
-rw-r----- 1 oracle oinstall 679M May 13 23:00 db_PROD_20160513_3vr5h5rk_1_1.bak
-rw-r----- 1 oracle oinstall 392K May 13 23:00 ar_PROD_20160513_3ur5h5rj_1_1.bak
-rw-r--r-- 1 oracle oinstall 7.8K May 13 22:50 PROD_rman_20160513-225001_L1.log
-rw-r----- 1 oracle oinstall 4.0K May 13 22:50 ar_PROD_20160513_3rr5h59b_1_1.bak
-rw-r----- 1 oracle oinstall 872K May 13 22:50 db_PROD_20160513_3qr5h58s_1_1.bak
-rw-r----- 1 oracle oinstall 280K May 13 22:50 db_PROD_20160513_3pr5h58s_1_1.bak
-rw-r----- 1 oracle oinstall 621K May 13 22:50 ar_PROD_20160513_3or5h58r_1_1.bak
-rw-r--r-- 1 oracle oinstall 7.2K May 13 22:40 PROD_rman_20160513-224002_L1.log
-rw-r----- 1 oracle oinstall 5.5K May 13 22:40 ar_PROD_20160513_3lr5h4mk_1_1.bak
-rw-r----- 1 oracle oinstall 1.7M May 13 22:40 db_PROD_20160513_3kr5h4m5_1_1.bak
-rw-r----- 1 oracle oinstall 224K May 13 22:40 db_PROD_20160513_3jr5h4m5_1_1.bak
-rw-r----- 1 oracle oinstall 1.6M May 13 22:40 ar_PROD_20160513_3ir5h4m3_1_1.bak
-rw-r--r-- 1 oracle oinstall 5.9K May 13 22:30 PROD_rman_20160513-223001_L1.log
-rw-r----- 1 oracle oinstall 4.5K May 13 22:30 ar_PROD_20160513_3fr5h43s_1_1.bak
-rw-r----- 1 oracle oinstall 3.5M May 13 22:30 db_PROD_20160513_3er5h43c_1_1.bak
-rw-r----- 1 oracle oinstall 296K May 13 22:30 db_PROD_20160513_3dr5h43c_1_1.bak
-rw-r----- 1 oracle oinstall 704K May 13 22:30 ar_PROD_20160513_3cr5h43b_1_1.bak
-rw-r--r-- 1 oracle oinstall 5.4K May 13 22:20 PROD_rman_20160513-222001_L1.log             此处实际进行0级增量备份
-rw-r----- 1 oracle oinstall 932K May 13 22:20 ar_PROD_20160513_39r5h3h4_1_1.bak
-rw-r----- 1 oracle oinstall 433M May 13 22:20 db_PROD_20160513_38r5h3gk_1_1.bak
-rw-r----- 1 oracle oinstall 679M May 13 22:20 db_PROD_20160513_37r5h3gk_1_1.bak



【 执行1级增量备份时，如果之前没有进行过0级备份，则进行0级增量备份】
[oracle@rhel64 rman_hot]$ more PROD_rman_20160513-222001_L1.log             从名称看是1级增量备份的日志，实际进行0级备份

Recovery Manager: Release 11.2.0.3.0 - Production on Fri May 13 22:20:01 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=314169367)
using target database control file instead of recovery catalog

RMAN>
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device type=DISK
specification does not match any backup in the repository

released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=41 device type=DISK

allocated channel: c2
channel c2: SID=48 device type=DISK


Starting backup at 13-MAY-16
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=41 RECID=36 STAMP=911584229
input archived log thread=1 sequence=42 RECID=37 STAMP=911584802
input archived log thread=1 sequence=43 RECID=38 STAMP=911584869
input archived log thread=1 sequence=44 RECID=39 STAMP=911588068
input archived log thread=1 sequence=45 RECID=40 STAMP=911588095
input archived log thread=1 sequence=46 RECID=41 STAMP=911588251
channel c1: starting piece 1 at 13-MAY-16
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=1 sequence=47 RECID=42 STAMP=911588268
input archived log thread=1 sequence=48 RECID=43 STAMP=911590202
input archived log thread=1 sequence=49 RECID=44 STAMP=911590229
input archived log thread=1 sequence=50 RECID=45 STAMP=911772605
input archived log thread=1 sequence=51 RECID=46 STAMP=911772623
channel c2: starting piece 1 at 13-MAY-16
channel c1: finished piece 1 at 13-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_34r5h3gi_1_1.bak tag=TAG20160513T222002 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=52 RECID=47 STAMP=911773202
channel c1: starting piece 1 at 13-MAY-16
channel c2: finished piece 1 at 13-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_35r5h3gi_1_1.bak tag=TAG20160513T222002 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:01
channel c1: finished piece 1 at 13-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_36r5h3gj_1_1.bak tag=TAG20160513T222002 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-MAY-16

Starting backup at 13-MAY-16
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 4 found
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 5 found
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/PROD/system01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/PROD/example01.dbf
channel c1: starting piece 1 at 13-MAY-16
channel c2: starting incremental level 0 datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/PROD/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/PROD/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/PROD/users01.dbf
channel c2: starting piece 1 at 13-MAY-16
channel c1: finished piece 1 at 13-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_37r5h3gk_1_1.bak tag=TAG20160513T222004 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:15
channel c2: finished piece 1 at 13-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_38r5h3gk_1_1.bak tag=TAG20160513T222004 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:15
Finished backup at 13-MAY-16

Starting backup at 13-MAY-16
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=53 RECID=48 STAMP=911773219
channel c1: starting piece 1 at 13-MAY-16
channel c1: finished piece 1 at 13-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_39r5h3h4_1_1.bak tag=TAG20160513T222020 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-MAY-16

Starting backup at 13-MAY-16
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 13-MAY-16
channel c1: finished piece 1 at 13-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/control_PROD_20160513_3ar5h3h5_1_1.bak tag=TAG20160513T222021 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-MAY-16

Starting Control File and SPFILE Autobackup at 13-MAY-16
piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-314169367-20160513-01 comment=NONE
Finished Control File and SPFILE Autobackup at 13-MAY-16

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
no obsolete backups found

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
no obsolete backups found

specification does not match any backup in the repository

released channel: c1

released channel: c2

RMAN>
RMAN>

Recovery Manager complete.
[oracle@rhel64 rman_hot]$





【第三次0级备份后查看删除过时备份情况 】
5.13 22:20第一次0级备份
5.13 23:00第二次0级备份
5.14 0:00  第三次0级备份
当前备份策略冗余度2    REDUNDANCY 2;
固5.14 0:00 进行第三次0级备份后，保留2次0级备份，删除了23:00（第二次0级备份） 之前的备份文件


[oracle@rhel64 rman_hot]$ ls -lht
total 2.2G
-rw-r--r-- 1 oracle oinstall  22K May 14 00:00 PROD_rman_20160514-000001_L0.log
-rw-r----- 1 oracle oinstall  10M May 14 00:00 control_PROD_20160514_56r5h9d9_1_1.bak
-rw-r----- 1 oracle oinstall 1.4M May 14 00:00 ar_PROD_20160514_55r5h9d7_1_1.bak
-rw-r----- 1 oracle oinstall 422M May 14 00:00 db_PROD_20160514_54r5h9c4_1_1.bak
-rw-r----- 1 oracle oinstall 679M May 14 00:00 db_PROD_20160514_53r5h9c4_1_1.bak
-rw-r----- 1 oracle oinstall 264K May 14 00:00 ar_PROD_20160514_52r5h9c3_1_1.bak
-rw-r--r-- 1 oracle oinstall  12K May 13 23:50 PROD_rman_20160513-235001_L1.log
-rw-r----- 1 oracle oinstall 3.5K May 13 23:50 ar_PROD_20160513_4vr5h8pr_1_1.bak
-rw-r----- 1 oracle oinstall 600K May 13 23:50 db_PROD_20160513_4ur5h8pc_1_1.bak
-rw-r----- 1 oracle oinstall  72K May 13 23:50 db_PROD_20160513_4tr5h8pc_1_1.bak
-rw-r----- 1 oracle oinstall 177K May 13 23:50 ar_PROD_20160513_4sr5h8pb_1_1.bak
-rw-r--r-- 1 oracle oinstall  11K May 13 23:40 PROD_rman_20160513-234001_L1.log
-rw-r----- 1 oracle oinstall 3.5K May 13 23:40 ar_PROD_20160513_4pr5h873_1_1.bak
-rw-r----- 1 oracle oinstall 696K May 13 23:40 db_PROD_20160513_4or5h86j_1_1.bak
-rw-r----- 1 oracle oinstall 208K May 13 23:40 db_PROD_20160513_4nr5h86j_1_1.bak
-rw-r----- 1 oracle oinstall 295K May 13 23:40 ar_PROD_20160513_4mr5h86i_1_1.bak
-rw-r--r-- 1 oracle oinstall 9.9K May 13 23:30 PROD_rman_20160513-233001_L1.log
-rw-r----- 1 oracle oinstall 4.0K May 13 23:30 ar_PROD_20160513_4jr5h7kb_1_1.bak
-rw-r----- 1 oracle oinstall 616K May 13 23:30 db_PROD_20160513_4ir5h7js_1_1.bak
-rw-r----- 1 oracle oinstall  72K May 13 23:30 db_PROD_20160513_4hr5h7js_1_1.bak
-rw-r----- 1 oracle oinstall 180K May 13 23:30 ar_PROD_20160513_4gr5h7jq_1_1.bak
-rw-r--r-- 1 oracle oinstall 9.2K May 13 23:20 PROD_rman_20160513-232001_L1.log
-rw-r----- 1 oracle oinstall 4.0K May 13 23:20 ar_PROD_20160513_4dr5h71k_1_1.bak
-rw-r----- 1 oracle oinstall 800K May 13 23:20 db_PROD_20160513_4cr5h714_1_1.bak
-rw-r----- 1 oracle oinstall 288K May 13 23:20 db_PROD_20160513_4br5h714_1_1.bak
-rw-r----- 1 oracle oinstall 823K May 13 23:20 ar_PROD_20160513_4ar5h713_1_1.bak
-rw-r--r-- 1 oracle oinstall 8.6K May 13 23:10 PROD_rman_20160513-231001_L1.log
-rw-r----- 1 oracle oinstall 3.5K May 13 23:10 ar_PROD_20160513_47r5h6er_1_1.bak
-rw-r----- 1 oracle oinstall 4.7M May 13 23:10 db_PROD_20160513_46r5h6ec_1_1.bak
-rw-r----- 1 oracle oinstall 128K May 13 23:10 db_PROD_20160513_45r5h6ec_1_1.bak
-rw-r----- 1 oracle oinstall 198K May 13 23:10 ar_PROD_20160513_44r5h6eb_1_1.bak
-rw-r--r-- 1 oracle oinstall  14K May 13 23:00 PROD_rman_20160513-230001_L0.log
-rw-r----- 1 oracle oinstall 2.1M May 13 23:00 ar_PROD_20160513_41r5h5sf_1_1.bak
-rw-r----- 1 oracle oinstall 436M May 13 23:00 db_PROD_20160513_40r5h5rk_1_1.bak
-rw-r----- 1 oracle oinstall 679M May 13 23:00 db_PROD_20160513_3vr5h5rk_1_1.bak
-rw-r--r-- 1 oracle oinstall 7.8K May 13 22:50 PROD_rman_20160513-225001_L1.log
-rw-r--r-- 1 oracle oinstall 7.2K May 13 22:40 PROD_rman_20160513-224002_L1.log
-rw-r--r-- 1 oracle oinstall 5.9K May 13 22:30 PROD_rman_20160513-223001_L1.log
-rw-r--r-- 1 oracle oinstall 5.4K May 13 22:20 PROD_rman_20160513-222001_L1.log




【查看备份第三次0级备份 备份日志】

[oracle@rhel64 rman_hot]$ cat PROD_rman_20160514-000001_L0.log

Recovery Manager: Release 11.2.0.3.0 - Production on Sat May 14 00:00:01 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=314169367)
using target database control file instead of recovery catalog

RMAN>
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_37r5h3gk_1_1.bak RECID=103 STAMP=911773204
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_38r5h3gk_1_1.bak RECID=104 STAMP=911773207
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_39r5h3h4_1_1.bak RECID=105 STAMP=911773220
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3cr5h43b_1_1.bak RECID=108 STAMP=911773803
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3dr5h43c_1_1.bak RECID=109 STAMP=911773804
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3er5h43c_1_1.bak RECID=110 STAMP=911773807
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3fr5h43s_1_1.bak RECID=111 STAMP=911773820
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3ir5h4m3_1_1.bak RECID=114 STAMP=911774403
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3jr5h4m5_1_1.bak RECID=115 STAMP=911774405
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3kr5h4m5_1_1.bak RECID=116 STAMP=911774409
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3lr5h4mk_1_1.bak RECID=117 STAMP=911774420
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3or5h58r_1_1.bak RECID=120 STAMP=911775003
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3pr5h58s_1_1.bak RECID=121 STAMP=911775004
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3qr5h58s_1_1.bak RECID=122 STAMP=911775007
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3rr5h59b_1_1.bak RECID=123 STAMP=911775019
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3ur5h5rj_1_1.bak RECID=126 STAMP=911775603
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_40r5h5rk_1_1.bak RECID=127 STAMP=911775606
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3vr5h5rk_1_1.bak RECID=128 STAMP=911775604
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_41r5h5sf_1_1.bak RECID=129 STAMP=911775631
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_44r5h6eb_1_1.bak RECID=132 STAMP=911776203
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_45r5h6ec_1_1.bak RECID=133 STAMP=911776204
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_46r5h6ec_1_1.bak RECID=134 STAMP=911776207
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_47r5h6er_1_1.bak RECID=135 STAMP=911776219
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_4ar5h713_1_1.bak RECID=138 STAMP=911776803
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_4br5h714_1_1.bak RECID=139 STAMP=911776804
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_4cr5h714_1_1.bak RECID=140 STAMP=911776807
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_4dr5h71k_1_1.bak RECID=141 STAMP=911776820
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_4gr5h7jq_1_1.bak RECID=144 STAMP=911777402
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_4hr5h7js_1_1.bak RECID=145 STAMP=911777404
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_4ir5h7js_1_1.bak RECID=146 STAMP=911777406
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_4jr5h7kb_1_1.bak RECID=147 STAMP=911777419
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_4mr5h86i_1_1.bak RECID=150 STAMP=911778002
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_4nr5h86j_1_1.bak RECID=151 STAMP=911778003
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_4or5h86j_1_1.bak RECID=152 STAMP=911778006
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_4pr5h873_1_1.bak RECID=153 STAMP=911778019
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-314169367-20160513-09 RECID=155 STAMP=911778022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_4sr5h8pb_1_1.bak RECID=156 STAMP=911778603
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_4tr5h8pc_1_1.bak RECID=157 STAMP=911778604
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_4ur5h8pc_1_1.bak RECID=158 STAMP=911778606
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_4vr5h8pr_1_1.bak RECID=159 STAMP=911778619
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/rman_hot/control_PROD_20160513_50r5h8ps_1_1.bak RECID=160 STAMP=911778621
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-314169367-20160513-0a RECID=161 STAMP=911778623
Crosschecked 42 objects


released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=30 device type=DISK

allocated channel: c2
channel c2: SID=44 device type=DISK


Starting backup at 14-MAY-16
current log archived
skipping archived logs of thread 1 from sequence 53 to 71; already backed up
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=72 RECID=67 STAMP=911779203
channel c1: starting piece 1 at 14-MAY-16
channel c1: finished piece 1 at 14-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160514_52r5h9c3_1_1.bak tag=TAG20160514T000003 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 14-MAY-16

Starting backup at 14-MAY-16
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/PROD/system01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/PROD/example01.dbf
channel c1: starting piece 1 at 14-MAY-16
channel c2: starting incremental level 0 datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/PROD/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/PROD/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/PROD/users01.dbf
channel c2: starting piece 1 at 14-MAY-16
channel c1: finished piece 1 at 14-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160514_53r5h9c4_1_1.bak tag=TAG20160514T000004 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:25
channel c2: finished piece 1 at 14-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160514_54r5h9c4_1_1.bak tag=TAG20160514T000004 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:35
Finished backup at 14-MAY-16

Starting backup at 14-MAY-16
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=73 RECID=68 STAMP=911779239
channel c1: starting piece 1 at 14-MAY-16
channel c1: finished piece 1 at 14-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160514_55r5h9d7_1_1.bak tag=TAG20160514T000039 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 14-MAY-16

Starting backup at 14-MAY-16
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 14-MAY-16
channel c1: finished piece 1 at 14-MAY-16
piece handle=/u01/app/oracle/backup/rman_hot/control_PROD_20160514_56r5h9d9_1_1.bak tag=TAG20160514T000041 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 14-MAY-16

Starting Control File and SPFILE Autobackup at 14-MAY-16
piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-314169367-20160514-00 comment=NONE
Finished Control File and SPFILE Autobackup at 14-MAY-16

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           103    13-MAY-16         
  Backup Piece       103    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_37r5h3gk_1_1.bak
Archive Log          48     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_53_902331034.dbf
Backup Set           104    13-MAY-16         
  Backup Piece       104    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_38r5h3gk_1_1.bak
Backup Set           105    13-MAY-16         
  Backup Piece       105    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_39r5h3h4_1_1.bak
Archive Log          49     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_54_902331034.dbf
Backup Set           108    13-MAY-16         
  Backup Piece       108    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3cr5h43b_1_1.bak
Backup Set           109    13-MAY-16         
  Backup Piece       109    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3dr5h43c_1_1.bak
Archive Log          50     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_55_902331034.dbf
Backup Set           110    13-MAY-16         
  Backup Piece       110    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3er5h43c_1_1.bak
Backup Set           111    13-MAY-16         
  Backup Piece       111    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3fr5h43s_1_1.bak
Archive Log          51     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_56_902331034.dbf
Backup Set           114    13-MAY-16         
  Backup Piece       114    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3ir5h4m3_1_1.bak
Backup Set           115    13-MAY-16         
  Backup Piece       115    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3jr5h4m5_1_1.bak
Backup Set           116    13-MAY-16         
  Backup Piece       116    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3kr5h4m5_1_1.bak
Archive Log          52     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_57_902331034.dbf
Backup Set           117    13-MAY-16         
  Backup Piece       117    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3lr5h4mk_1_1.bak
Archive Log          53     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_58_902331034.dbf
Backup Set           120    13-MAY-16         
  Backup Piece       120    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3or5h58r_1_1.bak
Backup Set           121    13-MAY-16         
  Backup Piece       121    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3pr5h58s_1_1.bak
Backup Set           122    13-MAY-16         
  Backup Piece       122    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3qr5h58s_1_1.bak
Archive Log          54     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_59_902331034.dbf
Backup Set           123    13-MAY-16         
  Backup Piece       123    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3rr5h59b_1_1.bak
Archive Log          55     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_60_902331034.dbf
Backup Set           126    13-MAY-16         
  Backup Piece       126    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3ur5h5rj_1_1.bak
Backup Set           155    13-MAY-16         
  Backup Piece       155    13-MAY-16          /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-314169367-20160513-09
Backup Set           160    13-MAY-16         
  Backup Piece       160    13-MAY-16          /u01/app/oracle/backup/rman_hot/control_PROD_20160513_50r5h8ps_1_1.bak

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           103    13-MAY-16         
  Backup Piece       103    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_37r5h3gk_1_1.bak
Archive Log          48     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_53_902331034.dbf
Backup Set           104    13-MAY-16         
  Backup Piece       104    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_38r5h3gk_1_1.bak
Backup Set           105    13-MAY-16         
  Backup Piece       105    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_39r5h3h4_1_1.bak
Archive Log          49     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_54_902331034.dbf
Backup Set           108    13-MAY-16         
  Backup Piece       108    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3cr5h43b_1_1.bak
Backup Set           109    13-MAY-16         
  Backup Piece       109    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3dr5h43c_1_1.bak
Archive Log          50     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_55_902331034.dbf
Backup Set           110    13-MAY-16         
  Backup Piece       110    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3er5h43c_1_1.bak
Backup Set           111    13-MAY-16         
  Backup Piece       111    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3fr5h43s_1_1.bak
Archive Log          51     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_56_902331034.dbf
Backup Set           114    13-MAY-16         
  Backup Piece       114    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3ir5h4m3_1_1.bak
Backup Set           115    13-MAY-16         
  Backup Piece       115    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3jr5h4m5_1_1.bak
Backup Set           116    13-MAY-16         
  Backup Piece       116    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3kr5h4m5_1_1.bak
Archive Log          52     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_57_902331034.dbf
Backup Set           117    13-MAY-16         
  Backup Piece       117    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3lr5h4mk_1_1.bak
Archive Log          53     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_58_902331034.dbf
Backup Set           120    13-MAY-16         
  Backup Piece       120    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3or5h58r_1_1.bak
Backup Set           121    13-MAY-16         
  Backup Piece       121    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3pr5h58s_1_1.bak
Backup Set           122    13-MAY-16         
  Backup Piece       122    13-MAY-16          /u01/app/oracle/backup/rman_hot/db_PROD_20160513_3qr5h58s_1_1.bak
Archive Log          54     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_59_902331034.dbf
Backup Set           123    13-MAY-16         
  Backup Piece       123    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3rr5h59b_1_1.bak
Archive Log          55     13-MAY-16          /u01/app/oracle/arch/arch_12b9d817_1_60_902331034.dbf
Backup Set           126    13-MAY-16         
  Backup Piece       126    13-MAY-16          /u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3ur5h5rj_1_1.bak
Backup Set           155    13-MAY-16         
  Backup Piece       155    13-MAY-16          /u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-314169367-20160513-09
Backup Set           160    13-MAY-16         
  Backup Piece       160    13-MAY-16          /u01/app/oracle/backup/rman_hot/control_PROD_20160513_50r5h8ps_1_1.bak
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_37r5h3gk_1_1.bak RECID=103 STAMP=911773204
deleted archived log
archived log file name=/u01/app/oracle/arch/arch_12b9d817_1_53_902331034.dbf RECID=48 STAMP=911773219
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_38r5h3gk_1_1.bak RECID=104 STAMP=911773207
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_39r5h3h4_1_1.bak RECID=105 STAMP=911773220
deleted archived log
archived log file name=/u01/app/oracle/arch/arch_12b9d817_1_54_902331034.dbf RECID=49 STAMP=911773803
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3cr5h43b_1_1.bak RECID=108 STAMP=911773803
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3dr5h43c_1_1.bak RECID=109 STAMP=911773804
deleted archived log
archived log file name=/u01/app/oracle/arch/arch_12b9d817_1_55_902331034.dbf RECID=50 STAMP=911773819
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3er5h43c_1_1.bak RECID=110 STAMP=911773807
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3fr5h43s_1_1.bak RECID=111 STAMP=911773820
deleted archived log
archived log file name=/u01/app/oracle/arch/arch_12b9d817_1_56_902331034.dbf RECID=51 STAMP=911774403
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3ir5h4m3_1_1.bak RECID=114 STAMP=911774403
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3jr5h4m5_1_1.bak RECID=115 STAMP=911774405
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3kr5h4m5_1_1.bak RECID=116 STAMP=911774409
deleted archived log
archived log file name=/u01/app/oracle/arch/arch_12b9d817_1_57_902331034.dbf RECID=52 STAMP=911774420
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3lr5h4mk_1_1.bak RECID=117 STAMP=911774420
deleted archived log
archived log file name=/u01/app/oracle/arch/arch_12b9d817_1_58_902331034.dbf RECID=53 STAMP=911775002
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3or5h58r_1_1.bak RECID=120 STAMP=911775003
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3pr5h58s_1_1.bak RECID=121 STAMP=911775004
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/db_PROD_20160513_3qr5h58s_1_1.bak RECID=122 STAMP=911775007
deleted archived log
archived log file name=/u01/app/oracle/arch/arch_12b9d817_1_59_902331034.dbf RECID=54 STAMP=911775019
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3rr5h59b_1_1.bak RECID=123 STAMP=911775019
deleted archived log
archived log file name=/u01/app/oracle/arch/arch_12b9d817_1_60_902331034.dbf RECID=55 STAMP=911775602
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/ar_PROD_20160513_3ur5h5rj_1_1.bak RECID=126 STAMP=911775603
deleted backup piece
backup piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-314169367-20160513-09 RECID=155 STAMP=911778022
deleted backup piece
backup piece handle=/u01/app/oracle/backup/rman_hot/control_PROD_20160513_50r5h8ps_1_1.bak RECID=160 STAMP=911778621
Deleted 26 objects


specification does not match any backup in the repository

released channel: c1

released channel: c2

RMAN>
RMAN>

Recovery Manager complete.
[oracle@rhel64 rman_hot]$



尽管备份脚本中备份归档日志plus archivelog时没有delete input,
设置redundancy 2后，report bosolete / delete noprompt obsolete    已将23:00之前归档日志文件删除
上述第三次0备份的备份日志中也有相关信息（绿色）

【查看存放归档日志文件目录】
[oracle@rhel64 arch]$ ls -lh
total 5.3M
-rw-r----- 1 oracle oinstall 2.1M May 13 23:00 arch_12b9d817_1_61_902331034.dbf
-rw-r----- 1 oracle oinstall 197K May 13 23:10 arch_12b9d817_1_62_902331034.dbf
-rw-r----- 1 oracle oinstall 2.0K May 13 23:10 arch_12b9d817_1_63_902331034.dbf
-rw-r----- 1 oracle oinstall 822K May 13 23:20 arch_12b9d817_1_64_902331034.dbf
-rw-r----- 1 oracle oinstall 2.5K May 13 23:20 arch_12b9d817_1_65_902331034.dbf
-rw-r----- 1 oracle oinstall 178K May 13 23:30 arch_12b9d817_1_66_902331034.dbf
-rw-r----- 1 oracle oinstall 2.5K May 13 23:30 arch_12b9d817_1_67_902331034.dbf
-rw-r----- 1 oracle oinstall 294K May 13 23:40 arch_12b9d817_1_68_902331034.dbf
-rw-r----- 1 oracle oinstall 2.0K May 13 23:40 arch_12b9d817_1_69_902331034.dbf
-rw-r----- 1 oracle oinstall 175K May 13 23:50 arch_12b9d817_1_70_902331034.dbf
-rw-r----- 1 oracle oinstall 2.0K May 13 23:50 arch_12b9d817_1_71_902331034.dbf
-rw-r----- 1 oracle oinstall 262K May 14 00:00 arch_12b9d817_1_72_902331034.dbf
-rw-r----- 1 oracle oinstall 1.4M May 14 00:00 arch_12b9d817_1_73_902331034.dbf
[oracle@rhel64 arch]$





吕星昊
20 16.5.13

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29475508/viewspace-2099559/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29475508/viewspace-2099559/

citiao3931
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
rman备份脚本和rman增量备份脚本分享
09-10
主要介绍了rman备份脚本和rman增量备份脚本,需要的朋友可以参考下
linux自动运行rman增量备份脚本
09-10
与0级备份脚本相似，它同样分配了通道c1并执行增量备份，但这次是级别1，意味着它基于上一次全量或更高级别的增量备份。`backup incremental level 1`就是这个级别的标志。同样，备份结果会被写入指定的文件路径，...
Rman+crontab实现一周自动备份计划
weixin_33901641的博客
08-29 134
Rman+crontab实现一周自动备份计划 要点： 1、编写脚本，在脚本中列出环境变量，脚本文件bakl0.sh内容如下：(这是关键的一步必须要在调用脚时给出环境变量) PATH=$PATH:$HOME/bin export PATH export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/10g ...
【RMAN】RMAN备份恢复2 RMAN热备脚本与crontab计划任务
citiao3931的博客
05-11 231
RMAN备份恢复2 RMAN热备脚本与crontab计划任务 【rman热备】 热备（非一致性备份，不关库备份。热备要求数据库必须是归档模式） SYS@PROD>select * fro...
rman自动备份恢复脚本
zuixinnet的专栏
04-10 874
源端每周日全备： #/bin/sh source ~/.bash_profile export BACKUP_DATE=`date +%Y%m%d` export BACKUP_PATH=/orabak echo `mkdir -p ${BACKUP_PATH}/${BACKUP_DATE}/backupset` echo `mkdir -p ${BACKUP_PATH}/${BACK
RMAN恢复脚本
lucklover的专栏
12-19 717
C:\Program Files\Veritas\NetBackup\bin>bplist -C pdmdb02 -t 4 -R / cntrl_s29_p1_t866569480:\ al_s28_p1_t866569444:\ al_s27_p1_t866569408:\ bk_s26_p1_t866569370:\ bk_s25_p1_t866569094:\ C:\User
rman增量备份及恢复的例子
csdn_0706的博客
11-26 99
SQL> ![oracle@oracle ~]$ cd /oracle[oracle@oracle oracle]$ lsadmin app flash_recovery_area oradata oraInven...
linux 定时任务
data eudemon
12-07 382
定时任务类型： at   crontab   anacron 1. 计划任务：at    只能执行一次  是单次计划任务：   at  时间（now+ 10min）或  at 20:00 2016-10-1      服务：atd  必须开启    创建成功的at计划任务会在/var/spool/at/目录下成生一个可执行的脚本文件     at任务删除：atrm + 计划任务的编号 ...
Oracle Rman全能备份脚本 DBA必备
06-02
3. crontab.sh：Crontab是Linux系统中的定时任务调度器，通过编写crontab.sh脚本并设置定时任务，可以自动化执行RMAN备份，确保备份的定期性和连续性。例如，可以设置每天凌晨执行全备份，其他时间执行增量备份，以...
AIX上oracle备份策略（rman+crontab)
12-30
本文将详细讲解如何在AIX操作系统上使用RMAN（Recovery Manager）结合crontab来实现Oracle数据库的自动化增量备份。 首先，RMAN是Oracle数据库提供的一种强大工具，用于执行数据库备份、恢复、空间管理和性能优化等...
rman备份策略及脚本
01-03
最后，`crontab.txt`文件通常用于设置定时任务，例如通过cron服务定期执行这些RMAN备份脚本，确保数据库备份的自动化和定期性。 在实际应用中，RMAN备份策略会根据业务需求、数据库大小、可用存储和恢复时间目标等...
Linux环境下rman备份的实例脚本
12-28
"Linux环境下RMAN备份实例脚本" 本文档介绍了在Linux环境下使用RMAN...本文档提供了一个完整的 RMAN 备份实例脚本，包括配置 Catalog、连接到目标数据库和 Catalog、创建 Catalog 表、配置参数、备份方案和计划任务。
Rman 定时备份crontab
05-18 176
第一步：加入定时任务： crontab - l 10 0 * * * /oradata_uat8/udb001/backup_db.sh > /oradata_uat8/udb001/b.log // 每天凌晨0...
LINUX下使用crontab进行RMAN备份实验
还不算晕的专栏
09-12 3913
之前写了脚本，手动执行可以，使用crontab总是无法运行成功，今天下午花了两个小时实验，完成如下： 注意事项：脚本完成首先手动执行，确定可以正常执行。 在crontab中使用，要注意以下几点： 1.要定义环境变量，即使是使用的ORACLE用户crontab -e编辑的。source /home/oracle/.bash_profile或者直接将/home/oracle/.bash_prof
crontab+rman 日期备份脚本
java3344520的专栏
06-21 3098
新接手了几个客户的数据库，数据库真是一团糟糕，什么分区，索引，表空间都十分的乱，最重要的是归档都没有开，竟然还是生产库，更别说什么备份脚本了，最近一直在做备份恢复的整理工作，该归档的停机归档，该建立脚本的建立备份脚本，以前库少，现在库多了，管理多个库不能那么空闲了，现在的库之前做了CRONTAB+RMAN的备份，做了些修改，记录如下：2011-06-21修改RMAN参数以及备份脚本，实
ORACLE rman备份策略结合crontab
Vincent的专栏
11-17 765
这是开发环境的备份策略，和大家分享一下，有
【RMAN】RMAN备份恢复1 RMAN冷备脚本与crontab计划任务
citiao3931的博客
05-05 124
RMAN备份恢复1 RMAN冷备脚本与crontab计划任务 冷备（一致性备份，需要关库。非归档模式只能冷备） SYS@PROD>select version from v$instance;...
oracle rman备份脚本
king_harry的专栏
07-04 1075
# RMAN 备份 connect target system/oracle@oratest1 #脱机备份需要先关闭和加载数据库 shutdown immediate startup mount run { #分配通道 allocate channel c1 device type disk format 'd:\ora\backup\oratest1_full_disk_
初始C++
最新发布
2302_81016149的博客
07-08 808
在C语言我们学习函数的时候，我们学习过生命周期这个概念。那么，什么是生命周期呢？生命周期通常指的是一个对象或变量从创建到销毁所经历的时间段。那么，命名空间是什么？咱们可以这样理解：在这个空间的生命周期内，对这个空间内的全部标识符起一个名字，可对其进行引用，可类似与C语言中的结构体。#include<stdlib.h>//此处不包此头文件代码可正常运行，那该如何解决此处情况呢？int main()//此处编译不通过原因为：在不包头文件前为变量，包含后为函数。return 0;
Oracle-RMAN增量备份恢复测试记录.docx
11-16
Oracle-RMAN增量备份恢复测试记录.docx

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值