【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
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29475508/viewspace-2099559/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【RMAN】RMAN備份恢復1 RMAN冷備指令碼與crontab計劃任務指令碼
- 【RMAN】RMAN備份恢復2 RMAN熱備指令碼與crontab計劃任務指令碼
- rman增量備份指令碼指令碼
- rman備份和增量備份指令碼指令碼
- RMAN備份恢復測試指令碼指令碼
- RMAN備份與恢復之加密備份加密
- rman備份恢復-rman入門
- RMAN說，我能備份(9)--RMAN增量備份與備份保留策略
- rman 備份指令碼指令碼
- rman備份指令碼指令碼
- RMAN備份恢復原理
- [Rman]Oracle Rman增量備份Level012指令碼Oracle指令碼
- Oracle RMAN 增量備份Oracle
- RMAN備份恢復典型案例——RMAN備份&系統變慢
- oracle實驗記錄 (恢復-rman增量備份)Oracle
- rman 全備份指令碼指令碼
- windows rman備份指令碼Windows指令碼
- RMAN常用備份指令碼指令碼
- oracle RMAN備份指令碼Oracle指令碼
- Rman 定時備份crontab
- RMAN 備份與恢復深入解析（二）
- RMAN 備份與恢復深入解析（一）
- 【轉】 RMAN備份與恢復實踐
- Nocatalog 下的RMAN 增量備份 shell指令碼指令碼
- 一個較完整的RMAN增量備份指令碼指令碼
- dg丟失歸檔，使用rman增量備份恢復
- Oracle 11g RMAN備份-增量備份Oracle
- 循序漸進oracle第7章：備份與恢復之RMAN完整備份指令碼Oracle指令碼
- rman備份恢復-rman恢復資料檔案測試
- [Oracle] rman備份指令碼(2)Oracle指令碼
- 使用rman備份的指令碼指令碼
- oracle rman備份指令碼收集Oracle指令碼
- Windows下RMAN備份指令碼Windows指令碼
- RMAN全庫備份指令碼指令碼
- RMAN備份Shel指令碼示例指令碼
- Rman備份的shell指令碼指令碼
- RMAN備份、恢復實驗室 之 備份篇 【rman: can't open target】
- RMAN備份恢復效能優化優化