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

Restoring database with only imports/exports

My database crashed after a power failure and there was no backup, only imports and exports. But when I try to start it, it generates corrupt datablocks. How do I resolve this with only imports and exports?

My database crashed after a power failure and there was no backup, only imports and exports. But when I try to start it, it generates corrupt datablocks. How do I resolve this with only imports and exports? My database is running on Sun Server StorEdge 3500.
If your only backup is an export dump, then your only option to restore is to blow away your entire database. Then re-create the database from scratch. At this point, your database will be mostly empty. Then perform a FULL import from your dump file.

After this is done, I highly recommend implementing a sound backup and recovery strategy which does not pose as many limitations as just a simple export dump does for recovery.

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