OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-000312 Error

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

ORA-000312 Error [message #232798]

Mon, 23 April 2007 05:36

prasadsure
Messages: 3
Registered: March 2007
Location: Bangalore

Junior Member

Hi,

Every body please help on this.

Our oracle version is 9i.

We are facing follwing this error.

Ora-00312 . Redolog file corrupted.

Please how to recovery the Redolog files.

Please suggest me.

Regards
S.Prasad

Report message to a moderator

Re: ORA-000312 Error [message #232800 is a reply to message #232798]

Mon, 23 April 2007 05:39

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

Form my command-line :

Quote:

/oracle/dba> oerr ora 312
00312, 00000, "online log %s thread %s: '%s'"
// *Cause: This message reports the filename for details of another message.
// *Action: Other messages will accompany this message. See the
// associated messages for the appropriate action to take.

See what the accompanying messages tell you.

Report message to a moderator

Re: ORA-000312 Error [message #232855 is a reply to message #232798]

Mon, 23 April 2007 11:51

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
1. database running in archive log or no archive log mode.
2. redo log multiplex
3. correpted redo log file is ACTIVE ?

regards
Taj

Report message to a moderator

Re: ORA-000312 Error [message #232859 is a reply to message #232798]

Mon, 23 April 2007 12:10

setu
Messages: 4
Registered: April 2007
Location: NEW DELHI

Junior Member

hi!
from my point of view
It seems that your instance crashed, and your lost redo log is needed by instance recovery. In such case, the only solution is restore backup(no matter hot or cold) and do incomplete recovery.
If you really have no any backup, the only final solution is use undocumented parameter:
sid_allow_resetlogs_corruption= true.
and startup mount database,
Recover database until cancel
Alter database open resetlogs.

Report message to a moderator

Re: ORA-000312 Error [message #232863 is a reply to message #232859]

Mon, 23 April 2007 12:31

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You start here with your first message giving WITHOUT any clue an advice to use undocumented parameter that makes his database unusable and stops support from Oracle.

Wow! Good start.

Regards
Michel

Report message to a moderator

Re: ORA-000312 Error [message #233134 is a reply to message #232863]

Tue, 24 April 2007 23:06

prasadsure
Messages: 3
Registered: March 2007
Location: Bangalore

Junior Member

Hi,

I found the solution.

SQL connected to SYSDBA.

After the follwoing commands use u can retrive the Redolog file.

SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-16038: log 1 sequence# 786 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread

1: 'F:\ORACLE\ORADATA\ORACLE\REDO01'

SQL>recover database untill cancel;

sql> alter database open resetlogs;

sql> shutdown

sql>startup

Note : After this there is no error.Now Oracle is working.

Report message to a moderator

Previous Topic:	up on the internet
Next Topic:	Data Scrambling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:30:41 CDT 2024