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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
 

--

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