Q

Restoring Oracle backups

My Windows NT and also my Oracle 7.5 database got corrupted. I have the backups of the database. I had installed Oracle 8i after installing the NT. Can the Oracle 7.5 backups be restored to Oracle 8i? I lost all of my archive logs and redo files. If the restore is possible, can you explain the process?
You cannot do a direct restore from one version of Oracle to a newer version. If you have a cold backup, then you can perform the following:

1. Restore your database datafiles, control files, and online redo logs to your server.

2. Point your environment to your Oracle 8i software.

3. Use the migration utility to migrate your Oracle 7 database to Oracle 8i.

This document lists the detailed steps on performing an Oracle 7 -> Oracle 8i migration:

Once the migration is complete, you should be able to open your database as an Oracle 8i database.

This was first published in April 2005
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close