就是,我已经备份归档了,下次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;
}
rman备份归档的问题,谢谢,如果回答的好,有加分~
答案:2 悬赏:60 手机版
解决时间 2021-04-06 12:25
- 提问者网友:两耳就是菩提
- 2021-04-05 20:49
最佳答案
- 五星知识达人网友:夜余生
- 2021-04-05 21:12
你的脚本不是自己写的吧?
1、倒数第4行 delete input其实就是备份后删除,你下次备份的时候,归档日志已经没了,根本没法再备份。
我看你的意思是想备份了然后清理一下归档日志,归档日志大量堆积会产生不利影响。其实这个脚本已经实现了。
1、倒数第4行 delete input其实就是备份后删除,你下次备份的时候,归档日志已经没了,根本没法再备份。
我看你的意思是想备份了然后清理一下归档日志,归档日志大量堆积会产生不利影响。其实这个脚本已经实现了。
全部回答
- 1楼网友:逃夭
- 2021-04-05 22:21
这个需求可以通过 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
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯