Home » RDBMS Server » Server Administration » ORA-00313 and ORA-00312  () 1 Vote
ORA-00313 and ORA-00312 [message #147993] Tue, 22 November 2005 02:21 Go to next message
Steelio
Messages: 1
Registered: November 2005
Junior Member
Hello everybody,
I hope somebody can help me with my Oracle Problem. My Oracle knowledge and my English knowledge is not the best but I try to explain it how good I can.

We had a running Oracle 9ir2 Database on Linux Suse 9.0. But we moved the maschine to another building and also the IP Adress changed. Now I cannot start the Database because I always get the same Errormessage

SQL> startup
ORACLE instance started.

Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/opt/oracle/oradata/indiv/redo01.log'

If I try to connect to the Database with a normal User, I get the following message:

ORA-01033: ORACLE initialization or shutdown in progress

Thanks for everybody who tries to help me.


Re: ORA-00313 and ORA-00312 [message #148004 is a reply to message #147993] Tue, 22 November 2005 03:41 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Hi,

You need to figure out what happened to that log file (/opt/oracle/oradata/indiv/redo01.log). Was it deleted or moved to a different directory? Also, you may want to check your ALERT.LOG file for additional info.

Best regards.

Frank
Re: ORA-00313 and ORA-00312 [message #148612 is a reply to message #147993] Fri, 25 November 2005 05:50 Go to previous messageGo to next message
sadashiv_tv
Messages: 3
Registered: November 2005
Location: Bangalore
Junior Member

Yes check for the online redo log. If it's missing or been deleted or un=usable you may have to go for a recovery.

follow these steps :

Shutdown the DB normal
edit the Parameter file and add
allow_resetlogs_corruption=TRUE (Beware this option may lead to loosing the entire DB)
STARTUP MOUNT ;
RECOVER DATABASE UNTIL CANCEL; ( This will apply log one by 1 till u say cancel. )
after recovery
ALTER DATBASE OPEN RESETLOGS;

now do a shutdown normal and startup again.

hope this will solve ur prob.



Re: ORA-00313 and ORA-00312 [message #152036 is a reply to message #148612] Tue, 20 December 2005 10:40 Go to previous messageGo to next message
donlcs
Messages: 62
Registered: October 2005
Location: VA, USA
Member
Never mind. Problem resolved with my own solution.

[Updated on: Tue, 20 December 2005 14:11]

Report message to a moderator

Re: ORA-00313 and ORA-00312 [message #152251 is a reply to message #152036] Wed, 21 December 2005 21:44 Go to previous messageGo to next message
donlcs
Messages: 62
Registered: October 2005
Location: VA, USA
Member

Since Frank asked about sharing my solution. Here goes. My approach is totally different, which may not be applicable to others. In my case, I'm using Oracle's default database for practice, hence, I do not have to worry about anything in this database and since fixing this problematic db including access is so much pain, why not create a brand new Oracle db? Just that simple.
icon5.gif  Re: ORA-00313 and ORA-00312 [message #268229 is a reply to message #148612] Tue, 18 September 2007 00:35 Go to previous messageGo to next message
riky
Messages: 1
Registered: September 2007
Location: PA
Junior Member
Hi!

Which Parameter file u r talking abt..?

can you pls explain?

thanks,
Re: ORA-00313 and ORA-00312 [message #268268 is a reply to message #268229] Tue, 18 September 2007 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think it is wise to reactivate a topic that have not been touch for almost 2 years.
I don't think you get any answer from someone that did not connect to the site since 10 January 2006.

Regards
Michel
Re: ORA-00313 and ORA-00312 [message #268404 is a reply to message #268268] Tue, 18 September 2007 07:57 Go to previous message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
And you will be hard pressed to find an answer when you speak in baby talk language, unless you want an answer from a 2 year old.
Previous Topic: Problem with User getting locked on database startup
Next Topic: unable to set session_cached_cursors
Goto Forum:
  


Current Time: Wed Dec 07 12:19:05 CST 2016

Total time taken to generate the page: 0.13376 seconds