error opening the database

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Thu, 28 Sep 2006 13:15:08 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51801DBB0E7@ex2003.metratech.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 28 2006 - 12:15:08 CDT