Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    9

    Question Unanswered: Any way to rebuild the database from data files ?

    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.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    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

  3. #3
    Join Date
    Oct 2003
    Posts
    9
    Originally posted by gbrabham
    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.

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •