Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2004
    Posts
    11

    Unanswered: Recovery of an Oracle 9.1 (URGENT)

    Hi there,

    We have a problem where the C: drive of the server crashed and has resulted in the NT4 server not booting anymore. The Oracle 9.1 has been installed on the D: drive, which is still ok.

    We have installed a new NT4 on a new C: drive and now the question is: How do we get the Oracle server up and running again...

    Alternatively - can we move the database files to another server and from these files create a new Oracle instance from the data we have on the D: drive??

    Thanks in advance

    Kim

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    Kim

    You will need to perform a database recovery, which you can do with the datafiles. If it is a new database instance, You will need the "create controlfile" command to recreate the controlfile, to tell oracle where to find the datafiles.
    Regards
    Dbabren

  3. #3
    Join Date
    Jan 2004
    Posts
    99
    Well it depends where all the datafiles/redo/control files are located and where you installed the oracle server.

    Hopefully you have installed the oracle software on the C:\ drive and all your datafiles are on D:\ maybe a mirrored copy of your redo and control file exist on C:\???.

    If the above is the case you need to re-install the oracle 9i software [ obviously without installing a database].

    other questions to ask is where are your redo logs/control files? if all on D:\ nothing to worry ....otherwise if mirrored on C:\ not a major issue as they are mirrored and you can recreate [redo], copy across [control file].!!

    Another issues is the loss of your tnsnames.ora/listener.ora, not a major issue again as you can recreate. The only issue is your init.ora, hopefully your using a spfile in which case you can mount the database and create pfile from spfile.

    good luck!!

  4. #4
    Join Date
    Jan 2004
    Posts
    11
    zaki_mtk: All the Oracle files has been installed on the D: drive including the program files and datafiles. The control files etc has not been mirrored on the C: drive.

    Can I run the Oracle instance without re-installing it since its all on the D: drive or does the Oracle software need some registry etc??

    dbabren: Could you be more specific?? What tool do I need??

    Thanks the replies!!

    Kim

  5. #5
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    Kim

    "create controlfile ..." command is an Oracle command you run in sqlplus - I come from an UNIX background although I expect windows installations to be exactly the same.

    IF you need to recover the datafile to a new database, then you would run this command to attach your datafiles to it - this would create additional files required like redo etc...

    File like tsnnames etc.. are another issue.

    I think we need to know what your current position is, to move this forward, as my assumptions may be incorrect and only server to cause confusion.

    ie Have you got Oracle back up and running?
    Have you got a database incstance working? Is it a new instance? ...
    Regards
    Dbabren

  6. #6
    Join Date
    Jan 2004
    Posts
    11
    Thanks for your reply

    I havent got Oracle up and running yet since I want to have a kind of plan beforehand. I didnt know if I should make a clean install of the Oracle application or if I should try and get the Oracle server up and running with the files currently installed on the D: drive

    So I do not have an instance running since Im in doubt on making a new instance and then "mount" the data files or perhaps, since I have all the files, start the instance from the files on the D: drive (and how do I do that without the service)??

    Kim

  7. #7
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    OK, Have you got all the datafiles, including the redo, temp datafile and one of the controlfiles?

    If you have then I would back these up somewhere - and then reinstall Oracle, rather than try to piece the existing installation together. You will need to reconfigure files like tsnnames etc .. - I do not claim to know how the Oracle installation works in wins, so someone alse may wish to comment!

    Then in the new Oracle installation, recreate your database (same name), shutdown Oracle, then copy in the files from step 1. Restart Oracle and the db should be there. - thats how backup and restore generally work in the UNIX world.
    Regards
    Dbabren

  8. #8
    Join Date
    Jan 2004
    Posts
    11
    Ok - thanks - i will try that... I guess I have to recreate the tablespaces and reuse the datafiles ??

    Kim

  9. #9
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    I think all the tablespace info is held in the controlfiles - so you should not have to create the them.
    Regards
    Dbabren

  10. #10
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    I meant to say that data will be held in your system area (system datafile) - controlfile just holds the location of the physical files.

    You shouldn't have to create the tablespace manually.
    Regards
    Dbabren

  11. #11
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Hi All,

    If you want to make oracle server running on the same machine as it was(on c:\).
    Then these are the assumptions that I could make out from all the above updates.

    1. Init<sid>.ora,Control file,Redolog files, all the data files etc that are required for DB operation(ie we can say u r having an offline backup of the DB) are intact then do the following things.

    i. Install Oracle 9i server software in C:.Make sure u don't create the default database.
    ii.Copy all the DB files under C:.

    iii. See in the services there should no service as Oracle Service<sid>
    but there should be listener service.
    iv Search PWD<sid>.ora file and send it to recycle bin.
    v. Use oradim utility to create an instance of the DB.
    vi. Under services u should get Oracle Service<sid>
    vii. Connect to sqlplus with sys as sysdba.
    viii. Issue the startup command.
    See if u can find any errors then let me know.

    If u don't have init<sid>.ora then use spfile<sid>.ora
    Actually spfile always gets precedence over init<sid>.ora.
    So if u want to startup the DB with init<sid>.ora then do mention it in ur Startup command.

    Good luck,
    Kaushik

  12. #12
    Join Date
    Jan 2004
    Posts
    11
    Thanks everybody...

    I used dbabren's approach for getting the Oracle 8 instance up and running and kausik_m123's approach for the Oracle 9.

    For some reason I couldn't use kausik_m123's approach for the Oracle 8 instance. I think there is something wrong with the Oradim80 tool - I didn't get an errormessage, but no new service was made. So I made a new empty db with the database assistant and copied all old db-files to the new db - and it worked :-)

    Cheers

    Kim

Posting Permissions

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