Re: ORA-16005: database requires recovery

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