【RMAN】RMAN備份恢復3 RMAN增量備份指令碼與crontab計劃任務

531968912發表於2016-05-17

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]$

呂星昊
2016.5.13

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29475508/viewspace-2099559/，如需轉載，請註明出處，否則將追究法律責任。

rman 增量備份恢復
2019-03-27
rman 備份指令碼
2018-05-11
指令碼
RMAN備份恢復技巧
2022-10-18
RMAN備份恢復典型案例——RMAN備份&系統變慢
2022-10-18
RMAN備份與恢復測試
2018-04-03
RMAN備份異機恢復
2021-03-12
dg丟失歸檔，使用rman增量備份恢復
2021-02-20
RMAN備份恢復效能優化
2019-08-01
優化
【RMAN】RMAN備份至ASM
2020-06-10
ASM
RMAN自動備份任務新增
2021-03-05
分享Oracle Rman的備份指令碼
2019-09-21
Oracle指令碼
【RMAN】RMAN的備份保留策略
2020-12-17
Oracle 備份恢復篇之RMAN catalog
2018-06-27
Oracle
ORACLE DG從庫 Rman備份恢復
2020-10-10
Oracle
rman備份異機恢復（原創）
2019-02-12
RMAN備份概述
2022-10-18
【RMAN】Oracle12c以後rman 備份恢復命令參考
2021-12-24
Oracle
【RMAN】在多租戶環境下的RMAN備份及恢復
2020-12-20
12 使用RMAN備份和恢復檔案
2020-03-23
RMAN備份恢復典型案例——ORA-00245
2022-10-18
oracle10g RMAN增量備份策略
2021-09-09
Oracle
RMAN增量恢復
2022-10-18
RMAN備份進度
2019-04-17
RMAN的備份原理
2018-06-04
RMAN備份恢復典型案例——異機恢復未知DBID
2022-10-18
oracle資料庫使用rman備份指令碼
2018-12-27
Oracle資料庫指令碼
備份恢復Lesson 04.Using the RMAN Recovery Catalog
2020-10-14
Oracle9i RMAN 的優缺點及RMAN 備份及恢復步驟
2018-07-16
Oracle
透過RMAN備份standby database成功恢復還原
2018-05-08
Database
RMAN備份恢復典型案例——資料庫卡頓
2022-10-18
資料庫
Oracle RMAN備份實戰
2020-07-14
Oracle
Oracle OCP(60)：RMAN 備份
2019-06-14
Oracle
【rman備份策略】實驗
2022-08-25
【RMAN】在備庫執行rman備份時報錯RMAN-06820 ORA-17629
2021-12-21
[20221028]rman使用tape與增量備份測試2.txt
2022-11-02
【RMAN】Oracle12c之後，rman備份Dataguard備端恢復可能出現邏輯錯誤
2021-03-31
Oracle
RMAN備份恢復典型案例——跨平臺遷移pdb
2022-10-18
RMAN備份詳解(轉載)
2018-05-10
[20190522]rman備份問題.txt
2019-05-22

【RMAN】RMAN備份恢復3 RMAN增量備份指令碼與crontab計劃任務

相關文章