RE: error opening the database

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <Harvinder.Singh@xxxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 28 Sep 2006 13:42:53 -0400

Can you see the file?
What output do you get from:
ls -l /space/app/oracle/oradata/test/redo01.log

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
Subject: error opening the database



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: