您当前的位置: 首页 > 数据库教程 > Oracle教程 > oraclerman备份日志单独备份和交叉校验

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

作者:不详 来源:网络 发布时间: 2014-08-23 20:54 点击:
手动备份归档日志 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 DBArc

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

  手动备份归档日志

  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';
分享到:
本文"oraclerman备份日志单独备份和交叉校验"由远航站长收集整理而来,仅供大家学习与参考使用。更多网站制作教程尽在远航站长站。
顶一下
(0)
0%
踩一下
(0)
0%
[点击 次] [返回上一页] [打印]
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
用户名: 密码: 验证码:
关于本站 - 联系我们 - 广告合作 - 网站声明 - 友情连接- 网站地图 - 站点地图 - 返回顶部
Copyright © 2007-2013 www.yhzhan.com(远航站长). All Rights Reserved .
远航站长:为中小站长提供最佳的学习与交流平台,提供网页制作与网站编程等各类网站制作教程.
官方QQ:445490277 网站群:26680406 网站备案号:豫ICP备07500620号-4