首页 > 数据库 > Oracle > 正文

oraclerman备份日志单独备份和交叉校验

2019-11-02 15:53:39
字体:
来源:转载
供稿:网友

 手动备份归档日志

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:手动备份归档日志,每次都是从最近的归档日志开始备份,接在备份以前的,以前较早漏掉备份的可能每次执行都不会被备份。这样的话可能就要执行交叉检查命令来确认系统有多少备份

虾滚网[www.aikan.tv/special/xiagundianyingwang/]
日志成功备份,

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';

上一篇:oracle闪回表详解

下一篇:oracle表空间

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表