怎么理解RMANbackupdatabaseplusarchivelogdeleteallinput命令
本篇文章为大家展示了怎么理解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_1
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=33 recid=6 stamp=717527999 //这是刚刚归档的日志
channel ORA_DISK_1: starting piece 1 at 28-APR-10
channel ORA_DISK_1: finished piece 1 at 28-APR-10
piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_annnn_TAG20100428T172000_5xhvxkcy_.bkp tag=TAG20100428T172000 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel 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=717527999
Finished backup at 28-APR-10
#备份数据文件
Starting backup at 28-APR-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=/dev/rdcdb_data01
input datafile fno=00006 name=/dev/rdcdb_data02
input datafile fno=00007 name=/dev/rdcdb_data03
input datafile fno=00008 name=/dev/rdcdb_data04
input datafile fno=00009 name=/dev/rdcdb_data05
input datafile fno=00010 name=/dev/rdcdb_data06
input datafile fno=00011 name=/dev/rdcdb_data07
input datafile fno=00012 name=/dev/rdcdb_data08
input datafile fno=00013 name=/dev/rdcdb_data09
input datafile fno=00014 name=/dev/rdcdb_data10
input datafile fno=00015 name=/dev/rdcdb_data11
input datafile fno=00016 name=/dev/rdcdb_data12
input datafile fno=00017 name=/dev/rdcdb_data13
input datafile fno=00018 name=/dev/rdcdb_data14
input datafile fno=00019 name=/dev/rdcdb_data15
input datafile fno=00020 name=/dev/rdcdb_data16
input datafile fno=00021 name=/dev/rdcdb_data17
input datafile fno=00022 name=/dev/rdcdb_data18
input datafile fno=00001 name=/dev/rdcdb_system01
input datafile fno=00023 name=/dev/rdcdb_data19
input datafile fno=00003 name=/dev/rdcdb_sysaux01
input datafile fno=00002 name=/dev/rdcdb_undotbs01
input datafile fno=00004 name=/dev/rdcdb_user
channel ORA_DISK_1: starting piece 1 at 28-APR-10
channel ORA_DISK_1: finished piece 1 at 28-APR-10
piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_nnnd1_TAG20100428T172003_5xhvxqn1_.bkp tag=TAG20100428T172003 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
#备份控制文件和SPFILE(AUTOBACKUP OFF)
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 28-APR-10
channel ORA_DISK_1: finished piece 1 at 28-APR-10
piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_ncsn1_TAG20100428T172003_5xhvxv6b_.bkp tag=TAG20100428T172003 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 28-APR-10
Starting backup at 28-APR-10
#再次切换在线日志(sql 'alter system archive log current';)
current log archived//发生日志切换
#备份执行备份命令期间产生的归档日志
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=34 recid=7 stamp=717528012//这是刚刚归档的日志
channel ORA_DISK_1: starting piece 1 at 28-APR-10
channel ORA_DISK_1: finished piece 1 at 28-APR-10
piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_annnn_TAG20100428T172012_5xhvxy7k_.bkp tag=TAG20100428T172012 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel 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=717528012
Finished backup at 28-APR-10
命令中的关键字all个人理解有2层含义:
1.表示当前归档日志之前的所有日志。所以我们在备份执行要先加入一句crosscheck archivelog all;以免在比对老的归档时发现没有而报错。
2.如果有多个归档的目的地,表示所有的归档目的地,在执行删除归档日志的时候才会在所有的目的地上全部删除。
上述内容就是怎么理解RMAN backup database plus archivelog delete all input命令,你们学到知识或技能了吗?如果还想学到更多技能或者丰富自己的知识储备,欢迎关注创新互联行业资讯频道。
当前名称:怎么理解RMANbackupdatabaseplusarchivelogdeleteallinput命令
当前网址:http://pwwzsj.com/article/gpgsdh.html