• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

ORA-00353: log corruption near block 75760 change 5605346 time 01/07/2012 11:41:31

 
Ranch Hand
Posts: 851
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,

My operating system is windows7 and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production



How can I fix it?

Thanks in anticipation

Best regards
 
Sheriff
Posts: 3837
66
Netbeans IDE Oracle Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This is quite a complicated topic and you might have better luck on a specialized forum. See eg. https://forums.oracle.com/forums/thread.jspa?threadID=921669.

If you highly value your database, you should try to obtain professional help (eg. Oracle support - you can obtain it even if you didn't have a support contract beforehand, though the rates are rather steep; assuming your licences are all right). Trying to recover your database by your own means might make your situation worse still and render your data unrecoverable (assuming they can still be recovered).

If you can afford to lose your data (eg. it is a test database and you can obtain a new copy from production), recreating it might be the easiest way to do it.
 
Farakh khan
Ranch Hand
Posts: 851
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Martin. I transferred this question to OTN forum

Best Regards
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic