Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Wed Jul 13 2005 - 13:31:03 CDT
![]() |
![]() |