OraFAQ Forum: Server Administration » ORA-00313 and ORA-00312

Home » RDBMS Server » Server Administration » ORA-00313 and ORA-00312 (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00313 and ORA-00312 [message #147993]

Tue, 22 November 2005 02:21

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.

Report message to a moderator

Re: ORA-00313 and ORA-00312 [message #148004 is a reply to message #147993]

Tue, 22 November 2005 03:41

Frank Naude
Messages: 4581
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

Report message to a moderator

Re: ORA-00313 and ORA-00312 [message #148612 is a reply to message #147993]

Fri, 25 November 2005 05:50

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.

Report message to a moderator

Re: ORA-00313 and ORA-00312 [message #152036 is a reply to message #148612]

Tue, 20 December 2005 10:40

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

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.

Report message to a moderator

Re: ORA-00313 and ORA-00312 [message #268229 is a reply to message #148612]

Tue, 18 September 2007 00:35

riky
Messages: 1
Registered: September 2007
Location: PA

Junior Member

Hi!

Which Parameter file u r talking abt..?

can you pls explain?

thanks,

Report message to a moderator

Re: ORA-00313 and ORA-00312 [message #268268 is a reply to message #268229]

Tue, 18 September 2007 01:47

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-00313 and ORA-00312 [message #268404 is a reply to message #268268]

Tue, 18 September 2007 07:57

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	Problem with User getting locked on database startup
Next Topic:	unable to set session_cached_cursors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 04:45:52 CST 2024