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

Restoring Oracle database from 8.1.7.0.0 to 8.1.5.0.0

We have applications running on Oracle 8.1.5.0.0 at various locations. At one location, Oracle was upgraded to 8.1.7.0.0. Now we want to restore the database from 8.1.7.0.0 to 8.1.5.0.0.

We have applications running on Oracle 8.1.5.0.0 at various locations. However, at one location, Oracle was upgraded to 8.1.7.0.0 to run another application also. Now we want to restore the database from 8.1.7.0.0 to 8.1.5.0.0 for running the main applications. Please provide the steps for restoring. (Oracle is running on Sun Solaris 5.7.)
You need to restore the database from a backup when it was still release 8.1.5, either from a valid offline or online backup. If you are restoring from an online backup you will have to perform an incomplete recovery to a point in time or SCN. Before you open the database or attempt to perform recovery, you will likely also have to restore your Oracle 8.1.5 binaries, and the global inventory, from an operating system backup. I'm assuming that the upgrade from 8.1.5 to 8.1.7 occurred in place, i.e., to the current ORACLE_HOME. If the 8.1.5 ORACLE_HOME still exists and 8.1.7 was installed into a totally new ORACLE_HOME, you should just be able to point your database to the 8.1.5 ORACLE_HOME without restoring the binaries and recover/open your database.

For additional backup and recovery scenarios and information, review the Oracle8i Release 2 (8.1.6) Backup and Recovery Guide.

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