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 Tomtcos0 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.