Q
Problem solve Get help with specific problems with your technologies, process and projects.

ORA-00396 and ORA-00397 while loading data

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.
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.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close