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

Restore data from backup of datafile without archives

I removed a small datafile and I don't have all archives, but I have an old backup of this datafile. How can I restore this data?

I have Oracle 8i and Unix AIX 4.3.3. I removed a small datafile and I don't have all archives, but I have an old backup of this datafile. This datafile had only four tables. If I can restore the data from this old datafile, it's OK, because the table's data didn't change. How can I restore this data? Thanks.
Since you do not have all of the archived redo logs, your only option is incomplete recovery. You can only roll forward to the point right before your first missing archived redo log file. This means any transactions in the database after and including this missing archived redo log file will be lost. Since you are only looking for these four tables, then I would suggest restoring this database to a different AIX 4.3.3 server. Once you have restored to this other server and opened the database, you can use the export utility to dump just these four tables and then import them into your other database.
This was last published in July 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.