oracle备份片校验,oracle rman 备份日志单独备份和交叉校验

手动备份归档日志

1、database01

[[email protected] scripts ]$ pwd

/usr/tivoli/scripts

[[email protected] 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

[[email protected] scripts ]$ rman target / catalog [email protected]  log = backup2013_05_01.log

RMAN>@oraarchyzz.sh

database 02

[[email protected] archivelog ]$ pwd

/u01/archivelog

[[email protected] 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 [email protected];

allocate channel t2 type ‘sbt_tape‘ parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)‘

connect [email protected];

backup filesperset 10

(archivelog all skip inaccessible delete input format ‘/arch_%s_%p/‘);

release channel t1;

release channel t2;

}

[[email protected] archivelog ]$ rman target / catalog [email protected] 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‘;

原文：http://blog.csdn.net/huzia/article/details/18937455