error opening the database

  • From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 28 Sep 2006 13:15:08 -0400



We are getting the following error when we changed from archivelog mode
to noarchivelog mode on test box. Steps followed were:


Shutdown immediate

Startup mount

Alter database NOARCHIVELOG;

Altere database open


SQL> alter database open;

alter database open


ERROR at line 1:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1:



How to fix this issue?





Other related posts: