Database recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Database recovery

  1. #1
    Join Date
    Nov 2000
    Posts
    57
    We just had to reinstall NT4 due to recent crash. After that our both Oracle Instance Service and Listener disappeared, however all datafiles, contol file are exist. What do I need to do bring Oracle Database back.

    Oracle 8.1.6 (NT4)

    Thanks!

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    1) Make sure your back files are in a safe place
    2) reinstall Oracle the same way you installed it the first time. (with the same SID and instance name)
    3) make sure Oracle starts up OK with a 'blank' database
    4) shutdown the database
    5) copy your backup files (datafiles, control files, init.ora, redo log files, etc) to their original locations
    6) If this is a cold backup, then you should be able to just
    start the database. It is a hot backup, then you will need to perform recovery first.


Posting Permissions

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



Click Here to Expand Forum to Full Width