永发信息网

rman备份归档的问题,谢谢,如果回答的好,有加分~

答案:2  悬赏:60  手机版
解决时间 2021-04-06 12:25
就是,我已经备份归档了,下次rman备份的时候,还会备份那些上次备份过得归档日志么?
还有一个问题,我想在备份完归档日之后,将归档日志移动(剪切)到其他地方,在rman中如何实现呢?
附我的rman脚本:
orabackup0:
run {allocate channel t1 type disk maxpiecesize = 3G;
backup
incremental level 0
filesperset 10
format 'c:\rman\db_%d_%t_%s_%p'
(database include current controlfile);
release channel t1;}
run {allocate channel a1 type disk maxpiecesize = 3G;
sql 'alter system archive log current';
crosscheck archivelog all;
backup
filesperset 10
format 'c:\rman\arch_%d_%t_%s_%p'
archivelog all delete input;
Backup current controlfile;
release channel a1;
}

orabackup1:
run {allocate channel t1 type disk maxpiecesize = 3G;
backup
incremental level 1
filesperset 10
format 'c:\rman\db_%d_%t_%s_%p'
(database include current controlfile);
release channel t1;}
run {allocate channel a1 type disk maxpiecesize = 3G;
sql 'alter system archive log current';
crosscheck archivelog all;
backup
filesperset 10
format 'c:\rman\arch_%d_%t_%s_%p'
archivelog all delete input;
Backup current controlfile;
release channel a1;
}
最佳答案
你的脚本不是自己写的吧?
1、倒数第4行 delete input其实就是备份后删除,你下次备份的时候,归档日志已经没了,根本没法再备份。
我看你的意思是想备份了然后清理一下归档日志,归档日志大量堆积会产生不利影响。其实这个脚本已经实现了。
全部回答
这个需求可以通过 backup archivelog all not backed up; 语法来实现。 使用该命令如果遇到 满足 not backed up xx times 的归档才会备份,否则即便该归档仍在disk上未被删除 也不会重复备份, 避免了重复备份带来的问题,也无需每次备份均删除磁盘上的归档文件。 rman> backup archivelog all not backed up; starting backup at 30-nov-13 current log archived using channel ora_disk_1 channel ora_disk_1: starting archive log backupset channel ora_disk_1: specifying archive log(s) in backup set input archive log thread=1 sequence=31 recid=88 stamp=832886696 input archive log thread=1 sequence=32 recid=89 stamp=832886698 input archive log thread=1 sequence=33 recid=90 stamp=832886701 input archive log thread=1 sequence=34 recid=91 stamp=832886705 input archive log thread=1 sequence=35 recid=92 stamp=832886706 input archive log thread=1 sequence=36 recid=93 stamp=832886707 input archive log thread=1 sequence=37 recid=94 stamp=832886709 input archive log thread=1 sequence=38 recid=95 stamp=832886710 input archive log thread=1 sequence=39 recid=96 stamp=832886717 channel ora_disk_1: starting piece 1 at 30-nov-13 channel ora_disk_1: finished piece 1 at 30-nov-13 piece handle=/s01/flash_recovery_area/g10r25/backupset/2013_11_30/o1_mf_annnn_tag20131130t212517_99mssy9g_.bkp tag=tag20131130t212517 comment=none channel ora_disk_1: backup set complete, elapsed time: 00:00:02 finished backup at 30-nov-13 starting control file and spfile autobackup at 30-nov-13 piece handle=/s01/flash_recovery_area/g10r25/autobackup/2013_11_30/o1_mf_s_832886719_99msszd5_.bkp comment=none finished control file and spfile autobackup at 30-nov-13 rman> backup archivelog all not backed up; starting backup at 30-nov-13 current log archived using channel ora_disk_1 skipping archive log file /s01/arch/1_31_831398352.dbf; already backed on 30-nov-13 skipping archive log file /s01/arch/1_32_831398352.dbf; already backed on 30-nov-13 skipping archive log file /s01/arch/1_33_831398352.dbf; already backed on 30-nov-13 skipping archive log file /s01/arch/1_34_831398352.dbf; already backed on 30-nov-13 skipping archive log file /s01/arch/1_35_831398352.dbf; already backed on 30-nov-13 skipping archive log file /s01/arch/1_36_831398352.dbf; already backed on 30-nov-13 skipping archive log file /s01/arch/1_37_831398352.dbf; already backed on 30-nov-13 skipping archive log file /s01/arch/1_38_831398352.dbf; already backed on 30-nov-13 skipping archive log file /s01/arch/1_39_831398352.dbf; already backed on 30-nov-13 channel ora_disk_1: starting archive log backupset channel ora_disk_1: specifying archive log(s) in backup set input archive log thread=1 sequence=40 recid=97 stamp=832886724 channel ora_disk_1: starting piece 1 at 30-nov-13 channel ora_disk_1: finished piece 1 at 30-nov-13 piece handle=/s01/flash_recovery_area/g10r25/backupset/2013_11_30/o1_mf_annnn_tag20131130t212524_99mst5k2_.bkp tag=tag20131130t212524 comment=none channel ora_disk_1: backup set complete, elapsed time: 00:00:02 finished backup at 30-nov-13 starting control file and spfile autobackup at 30-nov-13 piece handle=/s01/flash_recovery_area/g10r25/autobackup/2013_11_30/o1_mf_s_832886726_99mst6n1_.bkp comment=none finished control file and spfile autobackup at 30-nov-13 此外还可以指定 备份几次以上的才不备份, 例如 这里我们要求备份2次或以上的归档 此次才不备份, 那么就是backup archivelog all not backed up 2 times; rman> backup archivelog all not backed up 2 times; starting backup at 30-nov-13 current log archived using channel ora_disk_1 channel ora_disk_1: starting archive log backupset channel ora_disk_1: specifying archive log(s) in backup set input archive log thread=1 sequence=31 recid=88 stamp=832886696 input archive log thread=1 sequence=32 recid=89 stamp=832886698 input archive log thread=1 sequence=33 recid=90 stamp=832886701 input archive log thread=1 sequence=34 recid=91 stamp=832886705 input archive log thread=1 sequence=35 recid=92 stamp=832886706 input archive log thread=1 sequence=36 recid=93 stamp=832886707 input archive log thread=1 sequence=37 recid=94 stamp=832886709 input archive log thread=1 sequence=38 recid=95 stamp=832886710 input archive log thread=1 sequence=39 recid=96 stamp=832886717 input archive log thread=1 sequence=40 recid=97 stamp=832886724 input archive log thread=1 sequence=41 recid=98 stamp=832886806 channel ora_disk_1: starting piece 1 at 30-nov-13 channel ora_disk_1: finished piece 1 at 30-nov-13 piece handle=/s01/flash_recovery_area/g10r25/backupset/2013_11_30/o1_mf_annnn_tag20131130t212646_99mswr0o_.bkp tag=tag20131130t212646 comment=none channel ora_disk_1: backup set complete, elapsed time: 00:00:03 finished backup at 30-nov-13 starting control file and spfile autobackup at 30-nov-13 piece handle=/s01/flash_recovery_area/g10r25/autobackup/2013_11_30/o1_mf_s_832886809_99msws3r_.bkp comment=none finished control file and spfile autobackup at 30-nov-13 rman> backup archivelog all not backed up 2 times; starting backup at 30-nov-13 current log archived using channel ora_disk_1 skipping archive log file /s01/arch/1_31_831398352.dbf; already backed up 2 time(s) skipping archive log file /s01/arch/1_32_831398352.dbf; already backed up 2 time(s) skipping archive log file /s01/arch/1_33_831398352.dbf; already backed up 2 time(s) skipping archive log file /s01/arch/1_34_831398352.dbf; already backed up 2 time(s) skipping archive log file /s01/arch/1_35_831398352.dbf; already backed up 2 time(s) skipping archive log file /s01/arch/1_36_831398352.dbf; already backed up 2 time(s) skipping archive log file /s01/arch/1_37_831398352.dbf; already backed up 2 time(s) skipping archive log file /s01/arch/1_38_831398352.dbf; already backed up 2 time(s) skipping archive log file /s01/arch/1_39_831398352.dbf; already backed up 2 time(s) skipping archive log file /s01/arch/1_40_831398352.dbf; already backed up 2 time(s) channel ora_disk_1: starting archive log backupset channel ora_disk_1: specifying archive log(s) in backup set input archive log thread=1 sequence=41 recid=98 stamp=832886806 input archive log thread=1 sequence=42 recid=99 stamp=832886861 channel ora_disk_1: starting piece 1 at 30-nov-13 channel ora_disk_1: finished piece 1 at 30-nov-13 piece handle=/s01/flash_recovery_area/g10r25/backupset/2013_11_30/o1_mf_annnn_tag20131130t212741_99msygh3_.bkp tag=tag20131130t212741 comment=none channel ora_disk_1: backup set complete, elapsed time: 00:00:02 finished backup at 30-nov-13 starting control file and spfile autobackup at 30-nov-13 piece handle=/s01/flash_recovery_area/g10r25/autobackup/2013_11_30/o1_mf_s_832886863_99msyhl3_.bkp comment=none finished control file and spfile autobackup at 30-nov-13
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
委婉的问作业该怎么说?
夫妻都拆迁,双方都能享受政策吗
一部动画片主角叫东城日本的
本科论文文章引用不能超过多少?
单选题The
南昌二十六中怎么样
请问angel beats游戏出了吗? 18x还是全年龄
升学红包怎么写祝福语,升学宴可以包420红包吗
下列解释不正确的一项是A.人迹罕至:少有人来
歌词中有爱上了你爱上了你飞蛾扑火是什么歌
心安家政服务有限公司地址在什么地方,我要处
谨慎和不自信有什么本质区别呢?谨慎而不谨小
济怎么组词挤怎么组词,妆的组词有哪些
收费存车棚丢车不赔起诉需要多少钱,没有监控
高三生物知识点归纳
推荐资讯
Whenhehurriedtotherailwaystation,
数字电影命名XIAO-TOU-JIA-ZU-FTR-F-JA-QMS-
名侦探柯南tv版,在那观看?尤其是第722集,
135KbPS是多少兆的网速
小花仙种什么花升级快?
什么是泡沫玻璃?
在南半球,越往北走,纬度越________,在用东
驼色裤子配什么样的上衣
qq情侣网名 ╰我喜欢的样子你都有つ 求领一半
单选题1918年,陈独秀在《新青年》发文,痛骂
操作系统生态圈什么意思?现在操作系统都给美
雨燕前汽车把车标去掉可以吗
正方形一边上任一点到这个正方形两条对角线的
阴历怎么看 ?