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

Restoring to previous date with full export

I have a full export of a database that I would like to restore to a previous date on the same server, using the full export file.

I have a full export of a database that I would like to restore to a previous date on the same server, using the full export file. My understanding is that there are steps to be taken before performing the full import that are not clear to me. Would you be able to outline the necessary steps to restore a database from a full export? Thank you!
Using export and import for your backup and recovery strategy limits you to one option. You will have to blow away the existing objects and then import them anew. This may mean that you have to re-create the database. You cannot use the dump file to roll forward to any particular date, even if you have the archived redo logs.
This was last published in January 2007

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close