oracle cold backup 8.1.7.4 restore to oracle8.1.7.4 Can it be done.

pts.
Tags:
Oracle 8
Oracle backup
Please advise if I can take a cold backup from oracle 8.1.7.2 and restore onto oracle 8.1.7.4 binaries thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

By “cold backup” I assume that you’ve shut down the database and used OS commands to copy the datafiles, logfiles, controlfiles, and parameter file(s).

Now, if you restore these files to a machine that is running 8.1.7.4, you will in effect have an incomplete upgrade, as 8.1.7.4 has data dictionary changes as well as program changes over 8.1.7.2.

While in theory it _may_ be possible to run the various data dictionary update scripts (check the patchset documentation included with 8.1.7.4 for what runs after installing the software), I highly recommend restoring the database to a machine running the same version of Oracle, and then applying the patches to get to the latest rev of database software.

tom

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following