今天遇到点错误,标记一下:
************************************************************************
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 对象已删除
这下可以工作了。 结论,要定期转移归档的日值
|
阅读(1662) | 评论(0) | 转发(0) |