Home » RDBMS Server » Backup & Recovery » Recovering Corrupt Redolog (10g Enterprise R2(10.2.0.3.0))
Recovering Corrupt Redolog [message #407731] Thu, 11 June 2009 05:51 Go to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
My redolog got corrupted giving
following errors:
ora-00314 log 3 of thred 1,expected seq# 7 doesnt match 0
ora-00312 online log 3 thread 1;
'D:\oracle\product\10.2.0\oradata\dev\redo03.log'

please give the necessary steps for recovering
Re: Recovering Corrupt Redolog [message #407735 is a reply to message #407731] Thu, 11 June 2009 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Of course telling us where you get this error is totaly useless.

Regards
Michel
Re: Recovering Corrupt Redolog [message #407737 is a reply to message #407735] Thu, 11 June 2009 06:16 Go to previous messageGo to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
what u mean?
Re: Recovering Corrupt Redolog [message #407739 is a reply to message #407737] Thu, 11 June 2009 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I mean this error does not happen on top of your screen someday.

Regards
Michel
Re: Recovering Corrupt Redolog [message #407740 is a reply to message #407739] Thu, 11 June 2009 06:19 Go to previous messageGo to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
whatever
mine is in archive mode
so i need steps for recreating redolog
tell me if anyone knows
Re: Recovering Corrupt Redolog [message #407741 is a reply to message #407740] Thu, 11 June 2009 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
i need steps for recreating redolog

alter database clear logfile ...

Regards
Michel
Re: Recovering Corrupt Redolog [message #407948 is a reply to message #407740] Fri, 12 June 2009 08:50 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I don't believe that you can recreate a redo logfile - it holds details of the changes to the datafiles, so how exactly would you be able to recreate those?

Oracle supports (and I believe recommends) duplexing your redo logs to multiple locations so that you've got multiple copies of each one.
Previous Topic: Create a Backup and Restore "Tablespace"
Next Topic: Delete archive logs
Goto Forum:
  


Current Time: Thu Nov 28 15:55:08 CST 2024