oracle rman 備份日誌單獨備份和交叉校正

手動備份歸檔日誌

1、database01

[oraprod@db01 scripts ]$ pwd
/usr/tivoli/scripts
[oraprod@db01 scripts ]$ ls
1.txt                      nohup.out                  oraicr0.sh                 scheoraicr0.sh
BKlog                      null                       oraicr1.sh                 scheoraicr0.sh.test
BKlog.tar                  oraarch.sh                 oraicr1.sh.orig            scheoraicr1.sh
DBArchivelogBK.sh          oraarch.sh.BK091206        oraicr1v.sh                scheoraicr1.sh.test
DBArchivelogBK1130.sh      oraarch.sh.yt              oraicr2.sh                 scheoraicr1v.sh
DBFileBK_full.sh           oraarch2.sh                recover.sh                 scheoraicr2.sh
backup20130428.log         oraarchyzz.sh              refull.sh                  scheoraicr2.sh.test
nihao.c                    orafull.sh                 schearch.sh                tdpora.tar
nihao.sh                   orafull.sh.20120912combak  schearch.sh.bak            test.sh
nihao02.sh                 orafull.sh.BK091206        scheorafull.sh

[oraprod@db01 scripts ]$ rman target / catalog rman/rman@rman  log = backup2013_05_01.log
RMAN>@oraarchyzz.sh

 

database 02

[oraprod@db02 archivelog ]$ pwd
/u01/archivelog
[oraprod@db02 archivelog ]$ cat backuparc.sql
run {
####backup archivelog####
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
connect backup/bk1949coal@PROD1;
allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
connect backup/bk1949coal@PROD2;
backup filesperset 10
(archivelog all skip inaccessible delete input format '/arch_%s_%p/');
release channel t1;
release channel t2;
}
[oraprod@db02 archivelog ]$ rman target / catalog rman/rman@rman log = backup20130501.log

PS:手動備份歸檔日誌，每次都是從最近的歸檔日誌開始備份，接在備份以前的，以前較早漏掉備份的可能每次執行都不會被備份。這樣的話可能就要執行交叉檢查命令來確認系統有多少備份日誌成功備份，

crosscheck archivelog all;
crosscheck backupset;

 

 

進入rman：
list backup of archivelog all;
list backup of archivelog sequence 6474;

RMAN> list backup of archivelog from sequence 100425627276 thread 2;

 

RMAN>list backup of archivelog all;        ------------列出所有歸檔日誌
RMAN>list backup of archivelog from sequence 8116 thread 2;  ------------列出某條歸檔日誌

List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1728048 11.14G     SBT_TAPE    00:16:16     06-SEP-13     
        BP Key: 1728052   Status: AVAILABLE  Compressed: NO  Tag: TAG20130906T091351
        Handle: /arch_40509_1/   Media: 103

  List of Archived Logs in backup set 1728048
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    7774    100425627276 06-SEP-13 100431144864 06-SEP-13

RMAN>

應該是歸檔記錄備份後被刪除了吧，沒做交叉檢驗？
crosscheck archivelog all;

 

  

 

delete archivelog all completed before 'sysdate-7';