手動備份歸檔日志

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

總結

以上是生活随笔為你收集整理的oracle备份片校验,oracle rman 备份日志单独备份和交叉校验的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。