Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-16005: database requires recovery

Re: ORA-16005: database requires recovery

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 13 Jul 2005 20:31:03 +0200
Message-ID: <oanad1det8qlu1frm1lj0lv6cfandlaccd@4ax.com>


On Wed, 13 Jul 2005 19:45:52 +0530, amogh <amogh.r_at_gmail.com> wrote:

>Hi All,
>
>I shutdown the database with the abort option (shutdown abort).
>Following this, I do the following:
>1)start the instance
>2)execute SQL to mount the database
>3)execute SQL to Open the database in READ-ONLY mode.
>
>At this point I get an error, which says:
>ORA-16005: database requires recovery
>
>I know that this is because I issued a shutdown abort before, and that
>a subsequent startup will require instance recovery procedures.
>
>I do not get the error if I open the database in READ/WRITE mode.
>
>Any particular reason why I get an ORA-16005 in READ-ONLY mode?
>
>Regards,
>Amogh

Likely because in read-only mode no crash recovery is performed. It is illogical to have a database opened in read-only mode doing crash recovery as database aren't normally shutdwon in abort mode. However, as no crash recovery is performed, the database is still inconsistent and needs recovery.
I have the strange feeling you didn't look up the ora-16005 in the documentation.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Jul 13 2005 - 13:31:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US