0 pts.
 oracle cold backup 8.1.7.4 restore to oracle8.1.7.4 Can it be done.
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

Software/Hardware used:
ASKED: August 30, 2005  4:03 PM
UPDATED: February 3, 2009  4:02 PM

Answer Wiki:
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
Last Wiki Answer Submitted:  August 31, 2005  8:05 am  by  Tomtcos   0 pts.
All Answer Wiki Contributors:  Tomtcos   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _