Home » RDBMS Server » Server Administration » ORA-000312 Error
ORA-000312 Error [message #232798] Mon, 23 April 2007 05:36 Go to next message
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
Re: ORA-000312 Error [message #232800 is a reply to message #232798] Mon, 23 April 2007 05:39 Go to previous messageGo to next message
martijn
Messages: 283
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.
Re: ORA-000312 Error [message #232855 is a reply to message #232798] Mon, 23 April 2007 11:51 Go to previous messageGo to next message
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
Re: ORA-000312 Error [message #232859 is a reply to message #232798] Mon, 23 April 2007 12:10 Go to previous messageGo to next message
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.
Re: ORA-000312 Error [message #232863 is a reply to message #232859] Mon, 23 April 2007 12:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
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
icon6.gif  Re: ORA-000312 Error [message #233134 is a reply to message #232863] Tue, 24 April 2007 23:06 Go to previous message
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.

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


Current Time: Tue Dec 06 02:27:48 CST 2016

Total time taken to generate the page: 0.11425 seconds