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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: