ITPub博客

首页 > 数据库 > Oracle > [20180228]archivelog backup?log switch?

[20180228]archivelog backup?log switch?

原创 Oracle 作者:lfree 时间:2018-02-28 11:03:38 0 删除 编辑

[20180228]How to prevent RMAN archivelog backup from log switch.txt

--//备份归档时有时候避免log switch.可以加入until time 'sysdate'限制条件,测试如下:
--//https://blog.dbi-services.com/prevent-rman-archivelog-backup-log-switch/
--//我感觉加入not backed up 1 times ;更佳,避免备份多次.测试如下:

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

SYS@book> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/archivelog/book/
Oldest online log sequence     703
Next log sequence to archive   705
Current log sequence           705


RMAN> backup archivelog  until time 'sysdate' not backed up 1 times ;
Starting backup at 2018-02-28 10:58:29
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=28 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=54 device type=DISK
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=695 RECID=1235 STAMP=969271723
input archived log thread=1 sequence=696 RECID=1236 STAMP=969271739
input archived log thread=1 sequence=697 RECID=1239 STAMP=969272321
input archived log thread=1 sequence=698 RECID=1241 STAMP=969272449
channel ORA_DISK_1: starting piece 1 at 2018-02-28 10:58:31
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=699 RECID=1243 STAMP=969272579
input archived log thread=1 sequence=700 RECID=1245 STAMP=969273334
input archived log thread=1 sequence=701 RECID=1248 STAMP=969273514
input archived log thread=1 sequence=702 RECID=1250 STAMP=969273523
channel ORA_DISK_2: starting piece 1 at 2018-02-28 10:58:31
channel ORA_DISK_3: starting archived log backup set
channel ORA_DISK_3: specifying archived log(s) in backup set
input archived log thread=1 sequence=703 RECID=1252 STAMP=969273525
input archived log thread=1 sequence=704 RECID=1254 STAMP=969273527
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
channel ORA_DISK_3: starting piece 1 at 2018-02-28 10:58:31
channel ORA_DISK_1: finished piece 1 at 2018-02-28 10:58:32
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2018_02_28/o1_mf_annnn_TAG20180228T105830_f9d6pq0x_.bkp tag=TAG20180228T105830 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 2018-02-28 10:58:32
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2018_02_28/o1_mf_annnn_TAG20180228T105830_f9d6pq18_.bkp tag=TAG20180228T105830 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_3: finished piece 1 at 2018-02-28 10:58:32
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2018_02_28/o1_mf_annnn_TAG20180228T105830_f9d6pq1h_.bkp tag=TAG20180228T105830 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:01
Finished backup at 2018-02-28 10:58:32

Starting Control File and SPFILE Autobackup at 2018-02-28 10:58:32
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2018_02_28/o1_mf_s_969274712_f9d6pr5l_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2018-02-28 10:58:33

RMAN> backup archivelog  until time 'sysdate' not backed up 1 times ;
Starting backup at 2018-02-28 10:58:53
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
skipping archived logs of thread 1 from sequence 695 to 704; already backed up
Finished backup at 2018-02-28 10:58:53

--//第2次就没有备份.

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

请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    4006
  • 访问量
    7970358