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
--
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
Other related posts:
