Even if it's difficult to be in such a position, if you can't open your database because it needs recovery and you don't have archivelogs to recover or a cold backup to restore, this situation does not mean you'll say 'bye bye' to your database.
There is an undocumented parameter "_allow_resetlogs_corruption" that you can use in this situation. Setting this parameter TRUE in init.ora file may help you save (maybe not all) data. Procedure includes backing up the database, opening it with the updated pfile, discover the problematic data and try to recover all you can...
Here is a detailed article about the use of _allow_resetlogs_corruption parameter. Thanks to Terry Sutton, the author, for this very useful article which covers this lifesaver topic systematically.
Do not forget that you should not use an undocumented parameter without the support of Oracle.

6 Responses so far.

  1. It is really very helpful for me and I have gathered some important information from this blog.

    Big Data and Software Engineering Projects in Chennai | Wireless Sensor Networks Projects in Chennai.

  2. Unknown says:

    Your new valuable key points imply much a person like me and extremely more to my office workers. With thanks; from every one of us.
    AWS Online Training

  3. Anonymous says:

    A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
    Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training

  4. Really very helpful article , Thank you for sharing we have learned so much information from your blog

    Big Data and Hadoop Online Training
    Big Data Hadoop Training
    Hyderabad

  5. nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Spark and Scala Online Training
    Spark Scala Training
    Hyderabad

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -