in the alert log has very good information :
ARC1: Failed to archive log 3 thread 1 sequence 973 (19809)
Mon Jan 24 10:10:58 2005
Errors in file c:\oracle\admin\pig\bdump\pig_arc1_1548.trc:
ORA-16038: log 3 sequence# 973 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\PIG\REDO03.LOG'Mon Jan 24 10:10:58 2005
ARC0: Evaluating archive log 2 thread 1 sequence 972
Mon Jan 24 10:10:59 2005
Errors in file c:\oracle\admin\pig\bdump\pig_arc0_1844.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 209715200 bytes is 100.00% used, and has 0 remaining bytes available.*************************************************************
You have the following choices to free up space from
flash recovery area:
1. Consider changing your RMAN retention policy.
If you are using dataguard, then consider changing your
RMAN archivelog deletion policy.
2. Backup files to tertiary device such as tape using the
RMAN command BACKUP RECOVERY AREA.
3. Add disk space and increase the db_recovery_file_dest_size
parameter to reflect the new space.
4. Delete unncessary files using the RMAN DELETE command.
If an OS command was used to delete files, then use
RMAN CROSSCHECK and DELETE EXPIRED commands.
*************************************************************
ARC1: Failed to archive log 3 thread 1 sequence 973 (19809)
Mon Jan 24 10:10:58 2005
Errors in file c:\oracle\admin\pig\bdump\pig_arc1_1548.trc:
ORA-16038: log 3 sequence# 973 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\PIG\REDO03.LOG'Mon Jan 24 10:10:58 2005
ARC0: Evaluating archive log 2 thread 1 sequence 972
Mon Jan 24 10:10:59 2005
Errors in file c:\oracle\admin\pig\bdump\pig_arc0_1844.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 209715200 bytes is 100.00% used, and has 0 remaining bytes available.*************************************************************
You have the following choices to free up space from
flash recovery area:
1. Consider changing your RMAN retention policy.
If you are using dataguard, then consider changing your
RMAN archivelog deletion policy.
2. Backup files to tertiary device such as tape using the
RMAN command BACKUP RECOVERY AREA.
3. Add disk space and increase the db_recovery_file_dest_size
parameter to reflect the new space.
4. Delete unncessary files using the RMAN DELETE command.
If an OS command was used to delete files, then use
RMAN CROSSCHECK and DELETE EXPIRED commands.
*************************************************************
select reason,object_type,suggested_action from dba_outstanding_alerts;
解决方法:1.将归档设置到其他目录,修改alter system set log_archive_dest = 其他路径2.转移或者删除闪回恢复区里的归档日志。3.增大闪回恢复区。ALTER SYSTEM SET db_recovery_file_dest_size=3g
我把空间加大到3G,然后在alter database open;就可以了。我觉得flash recovery area太耗空间了。我在我自己电脑上装oracle 10g只是作为学习用。从1月份到4月份学习了一段时间。前几天想继续学习的时候,就发现出现这个问题了。然后看看flash_recovery_area目录已经有1.95G了。我怎样删除它们?直接在目录下删除???
另外,如果要撤销闪回恢复区,把初始化参数 DB_RECOVERY_FILE_DEST 的值清空即可