I was able to see the file, but since this was a test system I was able to use resetlogs and open the database. I still need to investigate the root cause of the issue. ________________________________ From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx] Sent: Thursday, September 28, 2006 1:43 PM To: Harvinder Singh; ORACLE-L Subject: RE: error opening the database Can you see the file? What output do you get from: ls -l /space/app/oracle/oradata/test/redo01.log ?? -Mark -- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning "A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects." --Robert A. Heinlein ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harvinder Singh Sent: Thursday, September 28, 2006 1:15 PM To: ORACLE-L Subject: error opening the database 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