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

Recovering an 8.1.7.2 database on a machine with 8.1.7.4

I want to recover an 8.1.7.2 database on another machine with Oracle version 8.1.7.4. Will the database recovery be successful? Can I open the database without migrating to 8.1.7.4?

I want to recover an 8.1.7.2 database on another machine with Oracle version 8.1.7.4. Will the database recovery be successful or not? Can I open the database without migrating to 8.1.7.4? My platform is Sun.
You'll have to fudge things a little to get this to work, provided you are working with a cold backup. First, restore your database datafiles to the 8.1.7.4 server. To make it easy, use the same directory structure. If the same directory structure is not possible, then you'll have to point your parameter file to the new control file locations and then issue ALTER DATABASE RENAME FILE commands for the rest of your datafiles. Next, start up your database and perform the upgrade steps required to upgrade your database. At this point, you can open the database for business.

Things get more sticky if you are using a hot backup. If using a hot backup, you should still be able to apply recovery and open the database, but at that time, you should upgrade the database immediately.

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