闪回恢复区满，库不能打开

今天测试库启不来，仅记录一下

SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-16014: 日志 1 的序列号 116 未归档, 没有可用的目的地
ORA-00312: 联机日志 1 线程 1:
'G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO01.LOG'

查看告警日志文件：

Fri Feb 17 09:57:53 2012
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 116 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Feb 17 09:57:53 2012
Errors in file g:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_arc1_3428.trc:
ORA-16014: log 1 sequence# 116 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO01.LOG'

Fri Feb 17 09:58:40 2012
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 116 (4)
Fri Feb 17 09:58:54 2012
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 116 (4)
Fri Feb 17 09:59:54 2012
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 116 (4)
Fri Feb 17 10:00:54 2012
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 116 (4)
Fri Feb 17 10:01:54 2012
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 116 (4)
Fri Feb 17 10:02:55 2012
Errors in file g:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_arc0_3432.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 99.98% used, and has 339456 remaining bytes available.

Fri Feb 17 10:02:55 2012
************************************************************************
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.
************************************************************************
ARC0: Failed to archive thread 1 sequence 116 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Feb 17 10:02:55 2012
Errors in file g:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_arc0_3432.trc:
ORA-16038: log 1 sequence# 116 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\REDO01.LOG'

然后查看对应的trc文件。
一看就知道是闪回恢复区满了，告警日志和trc文件中都给出了对应的解决方法。

采用临时的方法，增大db_recovery_file_dest_size参数值，就能打开数据库。

SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 2G
SQL> alter system set db_recovery_file_dest_size=3G scope=both;

系统已更改。

SQL> alter database open;

数据库已更改。

20120801  -------------------添加---

如果归档日志默认存储在闪回恢复区中，可以删除无用的归档日志解决该问题。

RMAN> delete archivelog until time 'sysdate-7';--删除7天前的无用的归档日志

这个问题很简单，仅记录一下，出现问题了，要记得查看相应的告警日志文件与trc文件。