ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 不备份上次已经备份的归档

不备份上次已经备份的归档

原创 Linux操作系统 作者:paulyibinyi 时间:2008-02-28 17:57:01 0 删除 编辑

backup archivelog all not backed up 1 times;  不备份上次已经备份的归档

delete noprompt archivelog all completed before 'sysdate -7'; 在本地保留7天的归档日志.

RMAN> backup archivelog all not backed up 1 times;

Starting backup at 28-FEB-08
current log archived
using channel ORA_DISK_1
skipping archive log file D:\ARCHPAUL\1_10.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_11.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_12.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_13.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_14.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_15.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_16.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_17.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_18.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_19.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_20.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_21.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_22.DBF; already backed up 1 time(s)
skipping archive log file D:\ARCHPAUL\1_23.DBF; already backed up 1 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=24 recid=1361 stamp=647891751
channel ORA_DISK_1: starting piece 1 at 28-FEB-08
channel ORA_DISK_1: finished piece 1 at 28-FEB-08
piece handle=D:\BACKUP\7RJ9S2P7_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 28-FEB-08

Starting Control File and SPFILE Autobackup at 28-FEB-08
piece handle=D:\BACKUP\C-1605165889-20080228-09 comment=NONE
Finished Control File and SPFILE Autobackup at 28-FEB-08

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-196160/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
oracle 10g ocm oracle 10g/11g/12c ocp aix 6.1 administrator,ogg expert,ITSS 技术交流群 201703254 微信公众号 paulyibin 探讨技术,开心工作 电话 13719354869 ,深入研究数据库和开始研究big data

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6505126