Hi, all,

I make a mistake. I upgrade my database from 8.1.6 to 8.1.7 without backup in advance. During the upgrade process I see many error messages. Now I can't start up the database.

I need to restore my database, and I still have my data files, control files, redo files, my initialization file, and so on. But now I have an oracle database in my another server, and I try to restore my db in that database. Can anybody tell me the process ? or where I can find the procedure or references ?

Another question. Is the file format of 8.1.6 are compatible 8.1.7 ? Because my new oracle database is 8.1.7, but my original data files are 8.1.6, I'm not sure if I can resotre them in my 8.1.7 database.

Thanks in advance.

Look at moving forward and try to correct the problem as opposed
to going backwards...

1. What type of errors did you get when doing the upgrade?
2. Did you install the 8.1.7 software in a new Oracle Home directory
or overlay the existing?
3. What happens if you try to manually start the database
ie: startup pfile=xxxxx\initxxx.ora
4. If you can start the database, do you have Invalid Objects ???


Gregg

While upgrading, it first remove my original 8.1.6 installation. The whole removing process works fine. But when it starts to install the 8.1.7, it pops up lot of message that it can't write ora*.dll file in the %ORACLE_HOME%\BIN directory, or OCX registration errors. And I can't run the database migration wizard.

It looks like system file errors, so I don't know how to solve the problem such as "can't find ora*.dll". And when I tried to install 8.1.7 again, the universal installer won't start. That's why I prefer to move all my data files to another computer and rebuild the database with them.

Will it work ?

Scottie.

It sounds like some piece of Oracle 8.1.6 was up and running at the
time of the installation. I would ensure ALL Oracle processes are
shutdown (database, instance, listener, etc ...) and try the install
from CD again

If you did not run the migration from 8.1.6 to 8.1.7 on the database,
then (AS LONG AS YOU HAVE ORACLE 8.1.6 installed on another
machine AND the same directory structure setup AND the same
instance setup) you might get lucky and be able to move the
datafiles to the other machine and try again ... BUT ALL Oracle
processes must be stopped before running the installation

HTH

Gregg