Recovering Corrupt Redolog [message #407731] |
Thu, 11 June 2009 05:51 |
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 #407948 is a reply to message #407740] |
Fri, 12 June 2009 08:50 |
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.
|
|
|