Can not startup database after db_recovery_file_dest_size.

What I have..
Window 2008 64bit Server
Oracle 11gR2 11.2.0.3 non cluster single instance

Situation

I can not startup database after db_recovery_file_dest is full.

Solution

I need to create a pfile from spfile.


D:\>set ORACLE_SID=ORCLDB

D:\>set ORACLE_HOME=D:\app\Administrator\product\11.2.0\orcl
D:\>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 3 09:46:39 2012

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

Connected to an idle instance.


SQL> create pfile from spfile;

File created.

D:\app\Administrator\product\11.2.0\prod_1\orcl\INITorcldb.ORA

is created


Edit INITorcldb.ORA and increase  "db_recovery_file_dest_size"


save it.

then

Now copy backup your change of pfile to spfile
SQL> create spfile from pfile;

File created.


D:\app\Administrator\product\11.2.0\prod_1\database\SPFILEPBHCPROD.ora is
modified

You may >Startup   your databse now.



Foot Notes:
For backup strategy, you may use RMAN to backup an SPFILE,  or back them up yourself.
PFILE is simply a text based file, which means you can copy it to another directory without affecting the Oracle instance.  This is the easiest way to backup a PFILE.

So when you backup an SPFILE, you will want to convert it to a PFILE.  You can do this with the following syntax.

SQL> create pfile from spfile;