查看alter日志信息，有以下内容：
ARC0: Failed to archive thread 1 sequence 595 (19809)
Tue Feb 19 22:33:00 2013
Errors in file e:\oracle\product\10.2.0\admin\develop_db\bdump\develop_db_arc1_1256.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.
Tue Feb 19 22:33:00 2013
************************************************************************
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.
************************************************************************
ARC1: Failed to archive thread 1 sequence 595 (19809)SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 99.58 0 197
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
已选择6行。
已经满了。
SQL> show parameter db_recovery_file_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string E:\oracle\product\10.2.0/flash
_recovery_area
db_recovery_file_dest_size big integer 8G
临时解决一下，让哥们马上能用：
SQL> alter system set db_recovery_file_dest_size=10G scope=both;
系统已更改。
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 80.87 0 200
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
已选择6行。C:\Documents and Settings\Administrator>set ORACLE_SID=develop_db
C:\Documents and Settings\Administrator>rman target /
Recovery Manager: Release 10.1.0.2.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: develop_db (DBID=1137394772)
RMAN> crosscheck archivelog all;
...
...
对归档日志的验证成功
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_01_29\O1_MF_1_548_8JHOH5KH_.ARC 记录 ID=547 时间戳 =806018409
对归档日志的验证成功
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_01_30\O1_MF_1_549_8JJF1JCN_.ARC 记录 ID=548 时间戳 =806042546
对归档日志的验证成功
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_01_30\O1_MF_1_550_8JL9QKF3_.ARC 记录 ID=549 时间戳 =806104690
对归档日志的验证失败
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_01_31\O1_MF_1_551_8JLQYMXP_.ARC 记录 ID=550 时间戳 =806119252
对归档日志的验证失败
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_01_31\O1_MF_1_552_8JNMP6TR_.ARC 记录 ID=551 时间戳 =806180423
对归档日志的验证失败
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_02_01\O1_MF_1_553_8JOJT1F3_.ARC 记录 ID=552 时间戳 =806210242
对归档日志的验证失败
...
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_02_17\O1_MF_1_593_8L0WJDB5_.ARC 记录 ID=592 时间戳 =807631245
对归档日志的验证失败
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_02_18\O1_MF_1_594_8L2F4977_.ARC 记录 ID=593 时间戳 =807681034
对归档日志的验证失败
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_02_19\O1_MF_1_595_8L742ZQC_.ARC 记录 ID=595 时间戳 =807835619
对归档日志的验证失败
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_02_19\O1_MF_1_596_8L74302C_.ARC 记录 ID=594 时间戳 =807835618
对归档日志的验证失败
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_02_19\O1_MF_1_597_8L7433CN_.ARC 记录 ID=596 时间戳 =807835620
对归档日志的验证失败
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_02_19\O1_MF_1_598_8L743GBO_.ARC 记录 ID=597 时间戳 =807835630
已交叉检验的 201 对象
删除归档日志
RMAN>delete expired archivelog all;
...
...
Do you really want to delete the above objects (enter YES or NO)? YES
deleted archive log
...
...
已删除的存档日志
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_01_29\O1_MF_1_547_8JG1GKQT_.ARC 记录 ID=546 时间戳 =805965138
已删除的存档日志
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_01_29\O1_MF_1_548_8JHOH5KH_.ARC 记录 ID=547 时间戳 =806018409
已删除的存档日志
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_01_30\O1_MF_1_549_8JJF1JCN_.ARC 记录 ID=548 时间戳 =806042546
已删除的存档日志
存档日志文件名 =E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\develop_db\ARCHIVELOG
\2013_01_30\O1_MF_1_550_8JL9QKF3_.ARC 记录 ID=549 时间戳 =806104690
153 EXPIRED 对象已删除
RMAN>
这个时候再去检查空间：
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 19.4 0 48
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
已选择6行。仅以此记。