[20160710]backup archivelog all not backed up 1 times.txt
--我们生产系统archivelog总是保留1个月的时间不删除.这样在日常备份中为了避免重复备份archivelog,就要注意备份N次的
--archivelog,就不需要再备份.
--在rman脚本中写入:
backup archivelog all not backed up 1 times format '/home/oracle/backup/arch_%U';
--次数可以根据自己备份的需要修改,我这里选择1.这样后续的备份仅仅备份没有备份的archivelog.
--如果次数2,就仅仅备份已经备份1次以及还没有备份的archivelog.减少备份的空间占用.
--在测试环境测试看看;
1.环境:
SCOTT@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
RMAN> delete archivelog all completed before 'sysdate-1';
RMAN> list archivelog all ;
List of Archived Log Copies for database with db_unique_name BOOK
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
204 1 343 A 2016-07-10 08:24:16
Name: /u01/app/oracle/archivelog/book/1_343_907434361.dbf
205 1 344 A 2016-07-10 13:10:21
Name: /u01/app/oracle/archivelog/book/1_344_907434361.dbf
206 1 345 A 2016-07-10 22:04:43
Name: /u01/app/oracle/archivelog/book/1_345_907434361.dbf
--保留1天的archivelog。为了测试需要，不要备份这个多archivelog。
2.备份第1次:
RMAN> backup archivelog all not backed up 1 times format '/home/oracle/backup/arch_%U';
Starting backup at 2016-07-11 08:40:09
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=343 RECID=204 STAMP=916837821
input archived log thread=1 sequence=344 RECID=205 STAMP=916869884
channel ORA_DISK_1: starting piece 1 at 2016-07-11 08:40:09
channel ORA_DISK_2: starting archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=345 RECID=206 STAMP=916907094
input archived log thread=1 sequence=346 RECID=207 STAMP=916908009
channel ORA_DISK_2: starting piece 1 at 2016-07-11 08:40:09
channel ORA_DISK_1: finished piece 1 at 2016-07-11 08:40:10
piece handle=/home/oracle/backup/arch_47radpv9_1_1 tag=TAG20160711T084009 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 2016-07-11 08:40:10
piece handle=/home/oracle/backup/arch_48radpv9_1_1 tag=TAG20160711T084009 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
Finished backup at 2016-07-11 08:40:10
Starting Control File and SPFILE Autobackup at 2016-07-11 08:40:10
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2016_07_11/o1_mf_s_916908010_cr5tqbwl_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2016-07-11 08:40:11
RMAN> list archivelog all ;
List of Archived Log Copies for database with db_unique_name BOOK
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
204 1 343 A 2016-07-10 08:24:16
Name: /u01/app/oracle/archivelog/book/1_343_907434361.dbf
205 1 344 A 2016-07-10 13:10:21
Name: /u01/app/oracle/archivelog/book/1_344_907434361.dbf
206 1 345 A 2016-07-10 22:04:43
Name: /u01/app/oracle/archivelog/book/1_345_907434361.dbf
207 1 346 A 2016-07-11 08:24:54
Name: /u01/app/oracle/archivelog/book/1_346_907434361.dbf
--备份到seq=346,也就是做archivelog备份时，oracle切换一个archivelog。
3.备份第2次:
RMAN> backup archivelog all not backed up 1 times format '/home/oracle/backup/arch_%U';
Starting backup at 2016-07-11 08:41:56
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
skipping archived logs of thread 1 from sequence 343 to 346; already backed up
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=347 RECID=208 STAMP=916908116
channel ORA_DISK_1: starting piece 1 at 2016-07-11 08:41:56
channel ORA_DISK_1: finished piece 1 at 2016-07-11 08:41:57
piece handle=/home/oracle/backup/arch_4aradq2k_1_1 tag=TAG20160711T084156 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2016-07-11 08:41:57
Starting Control File and SPFILE Autobackup at 2016-07-11 08:41:57
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2016_07_11/o1_mf_s_916908117_cr5ttoy9_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2016-07-11 08:41:58
--//注意看~,前面的from sequence 343 to 346被跳过，仅仅备份seq ＝347.
RMAN> list archivelog all ;
List of Archived Log Copies for database with db_unique_name BOOK
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
204 1 343 A 2016-07-10 08:24:16
Name: /u01/app/oracle/archivelog/book/1_343_907434361.dbf
205 1 344 A 2016-07-10 13:10:21
Name: /u01/app/oracle/archivelog/book/1_344_907434361.dbf
206 1 345 A 2016-07-10 22:04:43
Name: /u01/app/oracle/archivelog/book/1_345_907434361.dbf
207 1 346 A 2016-07-11 08:24:54
Name: /u01/app/oracle/archivelog/book/1_346_907434361.dbf
208 1 347 A 2016-07-11 08:40:09
Name: /u01/app/oracle/archivelog/book/1_347_907434361.dbf
