RE: error opening the database

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_at_il.proquest.com] 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_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