I'm using Oracle 9.0.1.0.1 on Win2K Professional. Yesterday I ran SQL*Loader to load 1.93 GB of data into various tables and suddenly a power failure occurred. At the next startup I was met with the following error: ORA-01033: Oracle initialization or shutdown in progress. For its solution I checked user dump files and found that due to the following errors, the above error is resulting:
  • ORA-00396: error 397 required fallback to single-pass recovery
  • ORA-00397: lost write detected for file 2, block 214364
Please help me rectify all of this.

    Requires Free Membership to View

You'll have to recover this file from a backup and perform recovery on your database. File #2 has become corrupt. It is a good thing you have your backup to fall back on! File #2 is typically your Undo (or Rollback) tablespace or your Temp tablespace.

This was first published in June 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.