RMAN备份报错(二)

2015-07-16 12:08:56 · 作者: · 浏览: 20
ved logthread=1 sequence=29 RECID=27 STAMP=877853741
input archived logthread=1 sequence=30 RECID=28 STAMP=877903227
input archived logthread=1 sequence=31 RECID=29 STAMP=877936609
input archived logthread=1 sequence=32 RECID=30 STAMP=877946863
input archived logthread=1 sequence=33 RECID=31 STAMP=878018408
input archived logthread=1 sequence=34 RECID=32 STAMP=878023071
input archived logthread=1 sequence=35 RECID=33 STAMP=878047701
input archived logthread=1 sequence=36 RECID=34 STAMP=878109519
input archived logthread=1 sequence=37 RECID=35 STAMP=878162579
input archived logthread=1 sequence=38 RECID=36 STAMP=878194931
input archived logthread=1 sequence=39 RECID=37 STAMP=878248841
input archived logthread=1 sequence=40 RECID=38 STAMP=878281394
input archived logthread=1 sequence=41 RECID=39 STAMP=878335209
input archived logthread=1 sequence=42 RECID=40 STAMP=878357413
input archived logthread=1 sequence=43 RECID=41 STAMP=878378428
input archived logthread=1 sequence=44 RECID=42 STAMP=878421646
input archived logthread=1 sequence=45 RECID=43 STAMP=878540967
input archived logthread=1 sequence=46 RECID=44 STAMP=878594428
input archived logthread=1 sequence=47 RECID=45 STAMP=878627427
input archived logthread=1 sequence=48 RECID=46 STAMP=878637664
input archived logthread=1 sequence=49 RECID=47 STAMP=878688020
input archived logthread=1 sequence=50 RECID=48 STAMP=878713890
input archived logthread=1 sequence=51 RECID=49 STAMP=878727648
input archived logthread=1 sequence=52 RECID=50 STAMP=878792434
input archived logthread=1 sequence=53 RECID=51 STAMP=878853632
input archived logthread=1 sequence=54 RECID=52 STAMP=878854392
input archived logthread=1 sequence=55 RECID=53 STAMP=878925105
input archived logthread=1 sequence=56 RECID=54 STAMP=878925252
input archived logthread=1 sequence=57 RECID=55 STAMP=878925853
input archived logthread=1 sequence=58 RECID=56 STAMP=878926991


channelORA_DISK_1: starting piece 1 at 05-MAY-15


channelORA_DISK_1: finished piece 1 at 05-MAY-15


piecehandle=/u01/app/oracle/fast_recovery_area/ORACLE007/backupset/2015_05_05/o1_mf_annnn_TAG20150505T191655_bnk9o8p0_.bkptag=TAG20150505T191655 comment=NONE


channelORA_DISK_1: backup set complete, elapsed time: 00:00:35


Finishedbackup at 05-MAY-15


1.1.1.5 知识点
1.使用CONFIGURE RETENTIONPOLICY TO RECOVERY WINDOW命令。


例如:RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;


我现在的时间是6月11日16:42,如果我设置了上述备份保留策略并进行备份,则该备份在6月16日16:42之后会被标识为废弃。


2.使用CONFIGURE RETENTION POLICYREDUNDANCY命令。


例如:RMAN>CONFIGURE RETENTION POLICYREDUNDANCY 3;


如果进行了上述设置,当完成三次备份后,在做完第四次备份的时候,第一次备份结果将被标识为废弃。ORACLE11G默认的备份保留策略是用该方法设置的,且REDUNDANCY为1。可以使用命令CONFIGURE RETENTION POLICY CLEAR恢复策略为默认值。还可以用命令CONFIGURE RETENTION POLICY TO NONE进行策略设置,此时REPORT OBSOLETE和DELETE OBSOLETE将不把任何备份文件视为废弃。


3.ORACLE备份目录由db_recovery_file_dest参数设置


4.ORACLE备份目录由db_recovery_file_dest_size参数设置


--------------------------------------推荐阅读 --------------------------------------


--------------------------------------分割线 --------------------------------------