数据库|mysql教程
Oracle rman备份,Oracle rman 备份日志
数据库-mysql教程
六间房 美女主播 网站源码,vscode c语言函数调用,ubuntu 优势,java8 tomcat,sqlite 缓冲,嘉兴网页设计,dedecms通过日志对数据库恢复,轻云服务器 云服务器 区别,iis插件未安装,安全前端框架,反爬虫500,云播php,seo具体做什么,springboot+im,dede文章页分页标签,网站模板组件,国庆主题网页模板,微擎模板开发手册,网站后台上传图片做难吗,竞价单页是单页面吗,jsp网站内容管理系统源码,微赞框架程序安装教程lzw
手动备份归档日志 1、database01 [oraprod@db01 scripts ]$ pwd/usr/tivoli/scripts[oraprod@db01 scripts ]$ ls1.txt
炫酷特效源码,ubuntu19卡,tomcat包含哪些知识点,什么爬虫好上手,php地址怎么设置成html,seo排名探索lzw
素材网解析源码,vscode快捷键介绍,ubuntu总是掉线,tomcat怎么写代码,爬虫树种植,php远程获取数据,技术型seo服务费用,网站源码安装教程,织梦 使用html5模板lzw
手动备份归档日志
1、database01
[oraprod@db01 scripts ]$ pwd
/usr/tivoli/scripts
[oraprod@db01 scripts ]$ ls
1.txtnohup.out oraicr0.sh scheoraicr0.sh
BKlognull oraicr1.sh scheoraicr0.sh.test
BKlog.tar oraarch.sh oraicr1.sh.orig scheoraicr1.sh
DBArchivelogBK.shoraarch.sh.BK091206 oraicr1v.shscheoraicr1.sh.test
DBArchivelogBK1130.shoraarch.sh.yt oraicr2.sh scheoraicr1v.sh
DBFileBK_full.sh oraarch2.shrecover.sh scheoraicr2.sh
backup0428.log oraarchyzz.sh refull.sh scheoraicr2.sh.test
nihao.c orafull.sh schearch.shtdpora.tar
nihao.sh orafull.sh.0912combak schearch.sh.bak test.sh
nihao02.sh orafull.sh.BK091206 scheorafull.sh
[oraprod@db01 scripts ]$ rman target / catalog rman/rman@rman log = backup_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 = backup0501.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.14GSBT_TAPE 00:16:1606-SEP-13
BP Key: 1728052 Status: AVAILABLE Compressed: NO Tag: TAG0906T091351
Handle: /arch_40509_1/ Media: 103
List of Archived Logs in backup set 1728048
Thrd SeqLow 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’;
推荐阅读:
RMAN 配置归档日志删除策略
Oracle基础教学之通过RMAN复制数据库
RMAN备份策略制定参考内容
RMAN备份学习笔记
Oracle数据库备份加密 RMAN加密