Chinaunix首页 | 论坛 | 博客
  • 博客访问: 233628
  • 博文数量: 23
  • 博客积分: 2262
  • 博客等级: 大尉
  • 技术积分: 872
  • 用 户 组: 普通用户
  • 注册时间: 2004-12-26 15:59
文章分类

全部博文(23)

文章存档

2009年(3)

2008年(20)

分类: Oracle

2009-02-25 14:03:20

今天遇到点错误,标记一下:
************************************************************************
ARC0: Failed to archive thread 1 sequence 1 (19809)
Wed Feb 25 13:53:32 2009
Errors in file /oradata/oracle/admin/ebaby/bdump/ebaby_arc0_4576.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************

  db_recovery_file_dest_size 默认为1G,我已经给改到2G了,但这对一个一天更量大的数据还是显的有点小的,可以在增大一点点,这个大小可以根据一天或是一周形成的redo来确定(不管什么时间,知道自已增加或是缩小这个是干什么的)
  
 遇到这个错误时,我才开始以手工的方式删除相应的LOG,可是还是不能工作。

然后又看错误提示,跟据上面的提示用rman去删除(Oracle就是做的智能,利害啊)

先在Oracle里确认:

sys@EBABY> SELECT substr(name, 1, 30) name, space_limit AS quota,
          space_used AS used,
  2 space_reclaimable AS reclaimable,
  3 number_of_files AS files
  4 FROM v$recovery_file_dest ;
  5
NAME
------------------------------------------------------------------------------------------------------------------------

     QUOTA USED RECLAIMABLE FILES
---------- ---------- ----------- ----------

/oradata/oracle/flash_recovery
2147483648 2098868224 0 43



有43个文件。USED空间为:2098868224 可见差不多用完了。

按Oracle提示的:
 用rman 去干掉他们:

 rman target /
[uniread] Loaded history (6 lines)

恢复管理器: Release 10.2.0.1.0 - Production on 星期三 2月 25 13:50:25 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.
~~~~~~~~~~~~~~~

RMAN> crosscheck archivelog all;

使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=137 devtype=DISK
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_05/o1_mf_1_7_4rnxq1wc_.arc 记录 ID=1 时间戳 =678028770
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_05/o1_mf_1_8_4ro2r62q_.arc 记录 ID=2 时间戳 =678033926
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_05/o1_mf_1_9_4row81gd_.arc 记录 ID=3 时间戳 =678060035
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_06/o1_mf_1_10_4rq6fglm_.arc 记录 ID=4 时间戳 =678103215
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_06/o1_mf_1_11_4rrf3dvl_.arc 记录 ID=5 时间戳 =678142830
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_07/o1_mf_1_12_4rs5q9sc_.arc 记录 ID=6 时间戳 =678168042
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_07/o1_mf_1_13_4rt2h0bd_.arc 记录 ID=7 时间戳 =678197473
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_07/o1_mf_1_14_4rvbhrpm_.arc 记录 ID=8 时间戳 =678238457
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_08/o1_mf_1_15_4rwro9mq_.arc 记录 ID=9 时间戳 =678285738
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_09/o1_mf_1_16_4ry3xxq1_.arc 记录 ID=10 时间戳 =678330046
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_09/o1_mf_1_17_4rzl40xq_.arc 记录 ID=11 时间戳 =678377345
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_09/o1_mf_1_18_4s0fr0tg_.arc 记录 ID=12 时间戳 =678405633
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_10/o1_mf_1_19_4s1fdk9k_.arc 记录 ID=13 时间戳 =678438034
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_10/o1_mf_1_20_4s2pxcgw_.arc 记录 ID=14 时间戳 =678480556
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_10/o1_mf_1_21_4s388kmz_.arc 记录 ID=15 时间戳 =678498322
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_11/o1_mf_1_22_4s4mk1ny_.arc 记录 ID=16 时间戳 =678542626
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_11/o1_mf_1_23_4s5phykd_.arc 记录 ID=17 时间戳 =678578431
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_12/o1_mf_1_24_4s6f4g5d_.arc 记录 ID=18 时间戳 =678601615
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_12/o1_mf_1_25_4s7s9mgy_.arc 记录 ID=19 时间戳 =678646836
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_12/o1_mf_1_26_4s8f474v_.arc 记录 ID=20 时间戳 =678667144
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_13/o1_mf_1_27_4s9jwfog_.arc 记录 ID=21 时间戳 =678703759
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_13/o1_mf_1_28_4sbwtkvy_.arc 记录 ID=22 时间戳 =678748755
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_14/o1_mf_1_29_4sc8zt8v_.arc 记录 ID=23 时间戳 =678761211
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_14/o1_mf_1_30_4sczzjz4_.arc 记录 ID=24 时间戳 =678784754
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_14/o1_mf_1_31_4sfdlj9m_.arc 记录 ID=25 时间戳 =678830417
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_15/o1_mf_1_32_4sgnz01x_.arc 记录 ID=26 时间戳 =678871777
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_15/o1_mf_1_33_4shqhx0x_.arc 记录 ID=27 时间戳 =678907134
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_16/o1_mf_1_34_4sk44frh_.arc 记录 ID=28 时间戳 =678952847
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_16/o1_mf_1_35_4sl79rxh_.arc 记录 ID=29 时间戳 =678988857
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_16/o1_mf_1_36_4slwdpxn_.arc 记录 ID=30 时间戳 =679010455
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_17/o1_mf_1_37_4smwdtdz_.arc 记录 ID=31 时间戳 =679043227
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_17/o1_mf_1_38_4so8h1yz_.arc 记录 ID=32 时间戳 =679088355
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_18/o1_mf_1_39_4soysqdt_.arc 记录 ID=33 时间戳 =679111224
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_18/o1_mf_1_40_4sq2bdyh_.arc 记录 ID=34 时间戳 =679147598
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_18/o1_mf_1_41_4sr53q5q_.arc 记录 ID=35 时间戳 =679183224
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_19/o1_mf_1_42_4ss1778k_.arc 记录 ID=36 时间戳 =679212008
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_19/o1_mf_1_43_4st4dql5_.arc 记录 ID=37 时间戳 =679248024
对归档日志的验证成功
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_19/o1_mf_1_44_4stsjowy_.arc 记录 ID=38 时间戳 =679269656
对归档日志的验证失败
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_20/o1_mf_1_45_4svwytt6_.arc 记录 ID=39 时间戳 =679305947
对归档日志的验证失败
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_20/o1_mf_1_46_4sx9vf2f_.arc 记录 ID=40 时间戳 =679351918
对归档日志的验证失败
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_21/o1_mf_1_47_4sxy0wtz_.arc 记录 ID=41 时间戳 =679372573
对归档日志的验证失败
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_21/o1_mf_1_48_4syvlf89_.arc 记录 ID=42 时间戳 =679402831
对归档日志的验证失败
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_21/o1_mf_1_49_4t07o2n4_.arc 记录 ID=43 时间戳 =679447971
已交叉检验的 43 对象



RMAN>  delete expired archivelog all;

释放的通道: ORA_DISK_1
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=137 devtype=DISK

已存档的日志副本列表
关键字     Thrd Seq     S 短时间              名称
------- ---- ------- - ------------------- ----
1       1    7       X 2009/02/05 03:13:08 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_05/o1_mf_1_7_4rnxq1wc_.arc
2       1    8       X 2009/02/05 13:19:29 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_05/o1_mf_1_8_4ro2r62q_.arc
3       1    9       X 2009/02/05 14:45:26 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_05/o1_mf_1_9_4row81gd_.arc
4       1    10      X 2009/02/05 22:00:33 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_06/o1_mf_1_10_4rq6fglm_.arc
5       1    11      X 2009/02/06 10:00:14 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_06/o1_mf_1_11_4rrf3dvl_.arc
6       1    12      X 2009/02/06 21:00:28 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_07/o1_mf_1_12_4rs5q9sc_.arc
7       1    13      X 2009/02/07 04:00:41 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_07/o1_mf_1_13_4rt2h0bd_.arc
8       1    14      X 2009/02/07 12:11:12 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_07/o1_mf_1_14_4rvbhrpm_.arc
9       1    15      X 2009/02/07 23:34:16 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_08/o1_mf_1_15_4rwro9mq_.arc
10      1    16      X 2009/02/08 12:42:17 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_09/o1_mf_1_16_4ry3xxq1_.arc
11      1    17      X 2009/02/09 01:00:45 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_09/o1_mf_1_17_4rzl40xq_.arc
12      1    18      X 2009/02/09 14:09:04 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_09/o1_mf_1_18_4s0fr0tg_.arc
13      1    19      X 2009/02/09 22:00:32 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_10/o1_mf_1_19_4s1fdk9k_.arc
14      1    20      X 2009/02/10 07:00:33 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_10/o1_mf_1_20_4s2pxcgw_.arc
15      1    21      X 2009/02/10 18:49:15 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_10/o1_mf_1_21_4s388kmz_.arc
16      1    22      X 2009/02/10 23:45:21 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_11/o1_mf_1_22_4s4mk1ny_.arc
17      1    23      X 2009/02/11 12:03:45 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_11/o1_mf_1_23_4s5phykd_.arc
18      1    24      X 2009/02/11 22:00:30 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_12/o1_mf_1_24_4s6f4g5d_.arc
19      1    25      X 2009/02/12 04:26:54 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_12/o1_mf_1_25_4s7s9mgy_.arc
20      1    26      X 2009/02/12 17:00:35 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_12/o1_mf_1_26_4s8f474v_.arc
21      1    27      X 2009/02/12 22:39:03 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_13/o1_mf_1_27_4s9jwfog_.arc
22      1    28      X 2009/02/13 08:49:17 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_13/o1_mf_1_28_4sbwtkvy_.arc
23      1    29      X 2009/02/13 21:19:13 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_14/o1_mf_1_29_4sc8zt8v_.arc
24      1    30      X 2009/02/14 00:46:50 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_14/o1_mf_1_30_4sczzjz4_.arc
25      1    31      X 2009/02/14 07:19:12 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_14/o1_mf_1_31_4sfdlj9m_.arc
26      1    32      X 2009/02/14 20:00:16 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_15/o1_mf_1_32_4sgnz01x_.arc
27      1    33      X 2009/02/15 07:29:36 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_15/o1_mf_1_33_4shqhx0x_.arc
28      1    34      X 2009/02/15 17:18:53 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_16/o1_mf_1_34_4sk44frh_.arc
29      1    35      X 2009/02/16 06:00:45 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_16/o1_mf_1_35_4sl79rxh_.arc
30      1    36      X 2009/02/16 16:00:56 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_16/o1_mf_1_36_4slwdpxn_.arc
31      1    37      X 2009/02/16 22:00:54 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_17/o1_mf_1_37_4smwdtdz_.arc
32      1    38      X 2009/02/17 07:07:06 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_17/o1_mf_1_38_4so8h1yz_.arc
33      1    39      X 2009/02/17 19:39:13 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_18/o1_mf_1_39_4soysqdt_.arc
34      1    40      X 2009/02/18 02:00:23 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_18/o1_mf_1_40_4sq2bdyh_.arc
35      1    41      X 2009/02/18 12:06:36 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_18/o1_mf_1_41_4sr53q5q_.arc
36      1    42      X 2009/02/18 22:00:23 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_19/o1_mf_1_42_4ss1778k_.arc
37      1    43      X 2009/02/19 06:00:07 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_19/o1_mf_1_43_4st4dql5_.arc
38      1    44      X 2009/02/19 16:00:23 /oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_19/o1_mf_1_44_4stsjowy_.arc

是否确定要删除以上对象 (输入 YES 或 NO)? yes
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_05/o1_mf_1_7_4rnxq1wc_.arc 记录 ID=1 时间戳 =678028770
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_05/o1_mf_1_8_4ro2r62q_.arc 记录 ID=2 时间戳 =678033926
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_05/o1_mf_1_9_4row81gd_.arc 记录 ID=3 时间戳 =678060035
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_06/o1_mf_1_10_4rq6fglm_.arc 记录 ID=4 时间戳 =678103215
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_06/o1_mf_1_11_4rrf3dvl_.arc 记录 ID=5 时间戳 =678142830
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_07/o1_mf_1_12_4rs5q9sc_.arc 记录 ID=6 时间戳 =678168042
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_07/o1_mf_1_13_4rt2h0bd_.arc 记录 ID=7 时间戳 =678197473
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_07/o1_mf_1_14_4rvbhrpm_.arc 记录 ID=8 时间戳 =678238457
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_08/o1_mf_1_15_4rwro9mq_.arc 记录 ID=9 时间戳 =678285738
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_09/o1_mf_1_16_4ry3xxq1_.arc 记录 ID=10 时间戳 =678330046
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_09/o1_mf_1_17_4rzl40xq_.arc 记录 ID=11 时间戳 =678377345
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_09/o1_mf_1_18_4s0fr0tg_.arc 记录 ID=12 时间戳 =678405633
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_10/o1_mf_1_19_4s1fdk9k_.arc 记录 ID=13 时间戳 =678438034
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_10/o1_mf_1_20_4s2pxcgw_.arc 记录 ID=14 时间戳 =678480556
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_10/o1_mf_1_21_4s388kmz_.arc 记录 ID=15 时间戳 =678498322
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_11/o1_mf_1_22_4s4mk1ny_.arc 记录 ID=16 时间戳 =678542626
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_11/o1_mf_1_23_4s5phykd_.arc 记录 ID=17 时间戳 =678578431
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_12/o1_mf_1_24_4s6f4g5d_.arc 记录 ID=18 时间戳 =678601615
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_12/o1_mf_1_25_4s7s9mgy_.arc 记录 ID=19 时间戳 =678646836
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_12/o1_mf_1_26_4s8f474v_.arc 记录 ID=20 时间戳 =678667144
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_13/o1_mf_1_27_4s9jwfog_.arc 记录 ID=21 时间戳 =678703759
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_13/o1_mf_1_28_4sbwtkvy_.arc 记录 ID=22 时间戳 =678748755
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_14/o1_mf_1_29_4sc8zt8v_.arc 记录 ID=23 时间戳 =678761211
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_14/o1_mf_1_30_4sczzjz4_.arc 记录 ID=24 时间戳 =678784754
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_14/o1_mf_1_31_4sfdlj9m_.arc 记录 ID=25 时间戳 =678830417
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_15/o1_mf_1_32_4sgnz01x_.arc 记录 ID=26 时间戳 =678871777
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_15/o1_mf_1_33_4shqhx0x_.arc 记录 ID=27 时间戳 =678907134
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_16/o1_mf_1_34_4sk44frh_.arc 记录 ID=28 时间戳 =678952847
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_16/o1_mf_1_35_4sl79rxh_.arc 记录 ID=29 时间戳 =678988857
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_16/o1_mf_1_36_4slwdpxn_.arc 记录 ID=30 时间戳 =679010455
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_17/o1_mf_1_37_4smwdtdz_.arc 记录 ID=31 时间戳 =679043227
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_17/o1_mf_1_38_4so8h1yz_.arc 记录 ID=32 时间戳 =679088355
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_18/o1_mf_1_39_4soysqdt_.arc 记录 ID=33 时间戳 =679111224
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_18/o1_mf_1_40_4sq2bdyh_.arc 记录 ID=34 时间戳 =679147598
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_18/o1_mf_1_41_4sr53q5q_.arc 记录 ID=35 时间戳 =679183224
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_19/o1_mf_1_42_4ss1778k_.arc 记录 ID=36 时间戳 =679212008
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_19/o1_mf_1_43_4st4dql5_.arc 记录 ID=37 时间戳 =679248024
已删除的存档日志
存档日志文件名 =/oradata/oracle/flash_recovery_area/EBABY/archivelog/2009_02_19/o1_mf_1_44_4stsjowy_.arc 记录 ID=38 时间戳 =679269656
38 EXPIRED 对象已删除


这下可以工作了。

结论,要定期转移归档的日值

阅读(1583) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~