Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-16005 : database requires recovery

568492Mar 22 2007 — edited Mar 23 2007

Following error occurred while trying to open oracle datababse in read only mode

$ sqlplus /nolog

SQL> connect /as sysdba
connected
SQL>

SQL> startup nomount
ORACLE instance started

Total System Global Area 612368384 bytes
Fixed Size 1281504 bytes
Variable Size 163578400 bytes
Database Buffers 415236096 bytes
Redo Buffes 32272348 bytes
SQL>

SQL> alter database mount ;

Database altered

SQL> alter database open ready only ;
alter database open ready only
*
ERROR at line 1:
ORA-16005: database requires recovery

SQL>

Since database is in No Archive mode why it is giving ORA-16005 error while starting a databse in ready only mode ????

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2007

Added on Mar 22 2007

#general-database-discussions

6 comments

5,272 views