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.shdatabase 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-13RMAN>应该是归档日志备份后被删除了吧，没做交叉检验？
crosscheck archivelog all;delete archivelog all completed before "sysdate-7";推荐阅读：RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle Database for Linux 不能使用退格键MySQL5.5配置安装半同步复制相关资讯 rman备份 Oracle RMAN备份

RMAN备份报 RMAN-06059 错误（05月13日）
RMAN备份文件远大于数据库大小的原（01月09日）
Oracle RMAN备份之控制文件备份（12/20/2015 20:07:06）

RMAN备份策略修正案例实录（02月29日）
Oracle 11g R2 RAC RMAN备份脚本示（12/27/2015 11:33:20）
RMAN备份时遇到ORA-19588 （07/23/2015 15:01:01）

本文评论查看全部评论（0）