Database mounted.
查看/u01/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl日志，
ARCH: Error 19809 Creating archive log file to '/u01/oracle/fast_recovery_area/ORCL/archivelog/2014_02_25/o1_mf_1_118_%u_.arc'
Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_3412.trc:
ORA-16038: log 1 sequence# 118 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-19815: WARNING: db_recovery_file_dest_size of 4322230272 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from 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.
************************************************************************
cd /u01/oracle/fast_recovery_area/ORCL/archivelog删除除今天外的几个日志。
SQL>
startup mount;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2228784 bytes
Variable Size 1023413712 bytes
Database Buffers 570425344 bytes
Redo Buffers 7344128 bytes
Database mounted.
SQL>
show parameter db_rec
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 4122M
db_recycle_cache_size big integer 0
SQL>
alter system set db_recovery_file_dest_size=5122m;
System altered.
[oracle@oracle11g ~]$
rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Feb 25 21:07:08 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1365931874)
RMAN>
crosscheck archivelog all;
RMAN
> delete expired archivelog all;
SQL>
alter database open;
Database altered.
SQL>
select status from v$instance;
STATUS
------------
OPEN
后记:因为这是WebSphere Portal用的数据库，今天要写一个方案，用到了里面的辛迪加复制，简单做了一个辛迪加复制，订户和复制都是本机，
估计这样导致了归档日志一直增加，到下午下班的时候数据库已经像吃了炫迈口香糖(根本停不下来)，直接关机走人了，然后后来再起的时候就报了这个错误。
感谢
http://blog.itpub.net/29477587/博主。
