怎么理解RMAN backup database plus archivelog delete all input命令_好文资源

本篇文章为大家展示了怎么理解RMAN backup database plus archivelog delete all input命令，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。RMAN> run {2> backup as compressed backupset incremental level 1 database plus archivelog delete all input;3> }//RMAN备份脚本Starting backup at 28-APR-10#切换在线日志(sql ‘alter system archive log current’;)current log archived//发生日志切换#备份之前所有的归档日志using channel ORA_DISK_1channel ORA_DISK_1: starting compressed archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=33 recid=6 stamp=717527999 //这是刚刚归档的日志channel ORA_DISK_1: starting piece 1 at 28-APR-10channel ORA_DISK_1: finished piece 1 at 28-APR-10piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_annnn_TAG20100428T172000_5xhvxkcy_.bkp tag=TAG20100428T172000 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)//删除输入的归档日志archive log filename=/u01/app/oracle/flash_recovery_area/YTHDB/archivelog/2010_04_28/o1_mf_1_33_5xhvxhjl_.arc recid=6 stamp=717527999Finished backup at 28-APR-10#备份数据文件Starting backup at 28-APR-10using channel ORA_DISK_1channel ORA_DISK_1: starting compressed incremental level 1 datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00005 name=/dev/rdcdb_data01input datafile fno=00006 name=/dev/rdcdb_data02input datafile fno=00007 name=/dev/rd开发云主机域名cdb_data03input datafile fno=00008 name=/dev/rdcdb_data04input datafile fno=00009 name=/dev/rdcdb_data05input datafile fno=00010 name=/dev/rdcdb_data06input datafile fno=00011 name=/dev/rdcdb_data07input datafile fno=00012 name=/dev/rdcdb_data08input datafile fno=00013 name=/dev/rdcdb_data09input datafile fno=00014 name=/dev/rd开发云主机域名cdb_data10input datafile fno=00015 name=/dev/rdcdb_data11input datafile fno=00016 name=/dev/rdcdb_data12input datafile fno=00017 name=/dev/rdcdb_data13input datafile fno=00018 name=/dev/rdcdb_data14input datafile fno=00019 name=/dev/rdcdb_data15input datafile fno=00020 name=/dev/rdcdb_data16input datafile fno=00021 name=/dev/rdcdb_data17input datafile fno=00022 name=/dev/rdcdb_data18input datafile fno=00001 name=/dev/rdcdb_system01input datafile fno=00023 name=/dev/rdcdb_data19input datafile fno=00003 name=/dev/rdcdb_sysaux01input datafile fno=00002 name=/dev/rdcdb_undotbs01input datafile fno=00004 name=/dev/rdcdb_userchannel ORA_DISK_1: starting piece 1 at 28-APR-10channel ORA_DISK_1: finished piece 1 at 28-APR-10piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_nnnd1_TAG20100428T172003_5xhvxqn1_.bkp tag=TAG20100428T172003 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:04c开发云主机域名hannel ORA_DISK_1: starting compressed incremental level 1 datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupset#备份控制文件和SPFILE(AUTOBACKUP OFF)including current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 28-APR-10channel ORA_DISK_1: finished piece 1 at 28-APR-10piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_ncsn1_TAG20100428T172003_5xhvxv6b_.bkp tag=TAG20100428T172003 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03Finis活动：慈云数据爆款香港服务器，CTG+CN2高速带宽、快速稳定、平均延迟10+ms 速度快，免备案，每月仅需19元！！点击查看hed backup at 28-APR-10Starting backup at 28-APR-10#再次切换在线日志(sql ‘alter system archive log current’;)current log archived//发生日志切换#备份执行备份命令期间产生的归档日志using channel ORA_DISK_1channel ORA_DISK_1: starting compressed archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=34 recid=7 stamp=717528012//这是刚刚归档的日志channel ORA_DISK_1: starting piece 1 at 28-APR-10channel ORA_DISK_1: finished piece 1 at 28-APR-10piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_annnn_TAG20100428T172012_5xhvxy7k_.bkp tag=TAG20100428T172012 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)//删除输入的归档日志archive log filename=/u01/app/oracle/flash_recovery_area/YTHDB/archivelog/2010_04_28/o1_mf_1_34_5xhvxwgz_.arc recid=7 stamp=717528012Finished backup at 28-APR-10命令中的关键字all个人理解有2层含义：1.表示当前归档日志之前的所有日志。所以我们在备份执行要先加入一句crosscheck archivelog all;以免在比对老的归档时发现没有而报错。2.如果有多个归档的目的地，表示所有的归档目的地，在执行删除归档日志的时候才会在所有的目的地上全部删除。上述内容就是怎么理解RMAN backup database plus archivelog delete all input命令，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注开发云行业资讯频道。

本文从转载，原作者保留一切权利，若侵权请联系删除。

《怎么理解RMAN backup database plus archivelog delete all input命令》来自互联网同行内容，若有侵权，请联系我们删除！