【RMAN】RMAN备份恢复3 RMAN增量备份脚本与crontab计划任务
RMAN备份恢复3
RMAN增量备份脚本与crontab计划任务
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]$
吕星昊
2016.5.13
正文到此结束
热门推荐
相关文章
近期评论
-
文章和留言都翻到11页了 没有OOM
-
-
朋友，翻页到11页，及以后，会出现OOM，无法访问
-
-
搞个gitee的项目
-
-
版本号是多少，你可以下载哪个代码仓库，jdk选1.8 直接跑就行
-
-
-
Loading...
![[HBLOG]公众号](https://www.liuhaihua.cn/img/qrcode_gzh.jpg)
