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

Hi, 

 

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:

'/space/app/oracle/oradata/test/redo01.log'

 

How to fix this issue?

 

Thanks

--Harvinder

 

Other related posts: