Lots oracle files - need help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Lots oracle files - need help

Hybrid View

  1. #1
    Hi there,
    someone has deleted half of the oracle files off the server (but not the data files). As far as I can gather it is the actual Oracle program that has gone, as we still seem to have the dbf files and at least one control file...

    As im a developer rather than a dba (until now), im at a bit of a loss....

    Also it seems tha there are no backups ......(!). Is there any way I can reinstall Oracle and use the database files and control file to get everything back up and running....?


    -Bob

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well in order to get the database back and running you need a consistent cold backup, can you shutdown the database at all?

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    If the db is not too large take an export. Reinstall Oracle, let it create the db, configure the db and import.

  4. #4
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    If you are able, get a consistent backup of some kind, either export or datafiles immediately.

    If all your database files (.dbf, control files, online redo's (or archived redo's) are truly intact, you won't have to do any file restore. Just reinstall your exe's (be sure the ORACLE_SID is set to something other than your actual database SIDs). Apply any need patches. Check your alert.log to be sure what patch level you were running at.

    Even if you had a crash shutdown, Oracle should start up fine when the exe's are back. If your online redo's are intact, it will perform crash recovery as usual. If there are files missing or corrupted, deal with it after the install.

    Then go track down the perpetrator(s) with a pointy stick. (Just a little DBA humor there.)

    D.

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