[20160710]备份archivelog仅仅1次.txt

[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

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

转载于:http://blog.itpub.net/267265/viewspace-2121803/