Oracle Data Guard 主庫 歸檔檔案 刪除策略--續

原文：http://space.itpub.net/81227/viewspace-691444

 

 

今天有機會做了測試，成功了。

 

 

Log內容：

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jul 1 17:07:25 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1275712672)
using target database control file instead of recovery catalog

RMAN>
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16>
allocated channel: c1
channel c1: sid=146 devtype=DISK

allocated channel: c2
channel c2: sid=145 devtype=DISK

sql statement: alter system archive log current

Starting backup at 01-JUL-11
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=42 recid=56 stamp=755367063
input archive log thread=1 sequence=43 recid=78 stamp=755370213
channel c1: starting piece 1 at 01-JUL-11
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=1 sequence=44 recid=79 stamp=755370214
input archive log thread=1 sequence=45 recid=82 stamp=755370374
input archive log thread=1 sequence=46 recid=84 stamp=755370447
channel c2: starting piece 1 at 01-JUL-11
channel c1: finished piece 1 at 01-JUL-11
piece handle=s35_1.arc tag=TAG20110701T170729
 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: deleting archive log(s)
archive log filename=oradata/arch/arch_1_42.753
721605.dbf recid=56 stamp=755367063
archive log filename=oracle/oradata/arch/arch_1_43.753
721605.dbf recid=78 stamp=755370213
channel c2: finished piece 1 at 01-JUL-11
piece handle=s36_1.arc tag=TAG20110701T170729
 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c2: deleting archive log(s)
archive log filename=oradata/arch/arch_1_44.753
721605.dbf recid=79 stamp=755370214
archive log filename=oradata/arch/arch_1_45.753
721605.dbf recid=82 stamp=755370374
RMAN-08137: WARNING: archive log not deleted as it is still needed
archive log filename=oradata/arch/arch_1_46.753
721605.dbf thread=1 sequence=46
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=47 recid=86 stamp=755370448
channel c1: starting piece 1 at 01-JUL-11
channel c1: finished piece 1 at 01-JUL-11
piece handle=s37_1.arc tag=TAG20110701T170729
 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
RMAN-08137: WARNING: archive log not deleted as it is still needed
archive log filename=oradata/arch/arch_1_47.753
721605.dbf thread=1 sequence=47
Finished backup at 01-JUL-11

Starting Control File and SPFILE Autobackup at 01-JUL-11
piece handle=flash_recovery_area/ORCL/autobacku
p/2011_07_01/o1_mf_s_755370453_70v3lpq1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 01-JUL-11

released channel: c1

released channel: c2

RMAN>
RMAN>

Recovery Manager complete.