ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle Data Guard 主库 归档文件 删除策略--续

Oracle Data Guard 主库 归档文件 删除策略--续

原创 Linux操作系统 作者:cow977 时间:2011-07-05 12:48:49 0 删除 编辑
原文: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.

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

请登录后发表评论 登录
全部评论

注册时间:2011-03-02

  • 博文量
    699
  • 访问量
    755235