The solution of Fast_recovery_area without remaining space

First, open the database error

[Oracle@node1 ora11g]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.3.0 Production on Mon Dec 19 15:42:04 2011

Copyright (c) 1982, Oracle. All rights reserved.

Connected to a idle instance.

Sql> Startup Nomount

ORACLE instance started.

Total System Global area 2137886720 bytes

Fixed Size 2230072 bytes

Variable Size 1493174472 bytes

Database buffers 637534208 bytes

Redo buffers 4947968 bytes

Sql> ALTER DATABASE Mount;

Database altered.

sql> ALTER DATABASE open;

ALTER DATABASE Open

*

ERROR at line 1:

Ora-03113:end-of-file on communication channel

Process id:19489

Session id:96 Serial Number:1

Second, the error message

1.alert Log Content

Mon Dec 19 15:23:29 2011

ALTER DATABASE Open

Beginning crash recovery of 1 threads

Parallel recovery started with 7 processes

Started Redo scan

Completed Redo Scan

Read 0 KB redo, 0 data blocks need recovery

Started Redo application at

Thread 1:logseq 3, Block 93169, SCN 12899730

Recovery of Online Redo log:thread 1 Group 3 Seq 3 Reading mem 0

mem# 0:/opt/oracle/oradata/ora11g/redo03.log

Completed Redo Application of 0.00MB

Completed Crash Recovery at

Thread 1:logseq 3, Block 93169, SCN 12919731

0 data blocks read, 0 data blocks written, 0 redo K-bytes Read

Mon Dec 19 15:23:29 2011

Lgwr:starting ARCH Processes

Mon Dec 19 15:23:29 2011

ARC0 started with pid=27, OS id=19539

Arc0:archival started

Lgwr:starting ARCH Processes COMPLETE

Arc0:starting ARCH Processes

Mon Dec 19 15:23:30 2011

ARC1 started with pid=28, OS id=19548

Mon Dec 19 15:23:30 2011

ARC2 started with pid=29, OS id=19550

Mon Dec 19 15:23:30 2011

ARC3 started with pid=30, OS id=19552

Arc1:archival started

Arc2:archival started

Arc2:becoming the ' no FAL ' ARCH

Arc2:becoming the ' no SRL ' ARCH

Arc1:becoming the Heartbeat ARCH

Errors in FILE/OPT/ORACLE/DIAG/RDBMS/ORA11G/ORA11G/TRACE/ORA11G_ARC2_19550.TRC:

ORA-19815: Warning: db_recovery_file_dest_size byte (total 4322230272 bytes) has been used 100%, and 0 bytes are still available.

************************************************************************