Oracle辅导：Oracle数据库归档日志占满磁盘空间怎么办

会计考友

1、数据库不能启动
1 k' x: K8 p1 _1 C$ I2 {0 s　　SQL> startup
* b6 Y5 q1 B: @" `0 H  l- X　　ORACLE 例程已经启动。
　　Total System Global Area 289406976 bytes
4 b* ?3 n+ v' M+ y　　Fixed Size                  1248576 bytes
2 Z: u9 J9 P1 E$ s2 m, Z5 J　　Variable Size              83886784 bytes
8 c; @9 P2 l8 y4 d　　Database Buffers          197132288 bytes
　　Redo Buffers                7139328 bytes
# l0 L! k# }, H" d9 o& W8 L　　数据库装载完毕。
　　ORA-16038: 日志 2 序列号 44 无法归档
　　ORA-19809: 超出了恢复文件数的限制
　　ORA-00312: 联机日志 2 线程 1:
　　'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
　　2、查看$ORACLE_HOME\admin\SID\bdump\alert_SID.log日志
　　Thu Feb 19 09:45:33 2009
& ?* O7 R0 S) G8 R' l7 t　　Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_660.trc:
! b' p: x7 Z, w) W! Q* ]　　ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 99.95% used, and has 1129472 remaining bytes available.
　　Thu Feb 19 09:45:33 2009
　　Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4708.trc:
9 ]- ^+ m# D' w　　ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 2147483648 字节) 已使用 99.95%, 尚有 1129472 字节可用。
% }$ O5 o% A" G# J　　Thu Feb 19 09:45:33 2009
: t  k1 P% s4 P7 x/ ^; g　　************************************************************************
　　You have following choices to free up space from flash recovery area:
: k, ?$ M$ p2 u9 W5 o　　1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
4 W- ^+ ~1 E+ j+ J　　Thu Feb 19 09:45:33 2009
　　************************************************************************
+ C2 w; q3 r* \( g　　then consider changing RMAN ARCHIVELOG DELETION POLICY.
' V+ I5 c- o$ j+ ^0 j; N　　2. Back up files to tertiary device such as tape using RMAN
　　You have following choices to free up space from flash recovery area:
　　BACKUP RECOVERY AREA command.
; \$ p6 w% {/ }1 y6 h7 |* \　　3. Add disk space and increase db_recovery_file_dest_size parameter to
　　1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
　　reflect the new space.
! a& w! e% x! i4 {% e　　then consider changing RMAN ARCHIVELOG DELETION POLICY.
: z: X1 E  I- m. e/ t) L# c　　4. Delete unnecessary files using RMAN DELETE command. If an operating
　　system command was used to delete files, then use RMAN CROSSCHECK and
　　2. Back up files to tertiary device such as tape using RMAN
　　DELETE EXPIRED commands.
+ p, B: t1 R& K1 k' x7 y/ t: d: p　　************************************************************************
1 L$ E9 h& T! N8 \　　BACKUP RECOVERY AREA command.
# {+ V! Z0 m7 s, U5 Z　　Thu Feb 19 09:45:34 2009
- l( J2 F0 {- n: \# U　　Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_660.trc:
　　ORA-19809: limit exceeded for recovery files
4 a/ L) e% T  ~1 k6 s% Q7 q5 O　　ORA-19804: cannot reclaim 44217856 bytes disk space from 2147483648 limit
5 G' {- S0 h; ~2 T　　从膳缦沔信息知道是flash recovery area闪回恢复空间中默认2G的空间被归档日志占满了，没有空间进行存放归档日志。[NextPage]
　　3、退出sqlplus,进入rman
　　SQL> exit
# z: E7 N1 o, ~8 r3 g, A　　从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
/ |6 N1 i2 A( N% i6 m* \　　With the Partitioning, OLAP and Data Mining options 断开
　　C:\Documents and Settings\mengzhaoliang>rman target/
　　恢复打点器: Release 10.2.0.1.0 - Production class=Apple-style-span>