Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unhappy Unanswered: NT Based Oracle Database Recorver

    Hi
    I am trying to recover data/database from Oracle Backup files(.DBF) and Oracle is NT based. Can you help me about the steps involve in this process.

    Any help will be highly appreciated
    mr_roomi

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    It is the same as recovery on Solaris. Start database and let Oracle try to recover itself. If it fails (because there is more work that SMON knows how to do automatically) then you will get errors about what needs to be recovered. Shutdown the database, restore the files it reported having problems with, then startup mount and issue recover database command.

    I recommend taking a cold backup of the "bad" database before you try making it good again. Some people make things worse and need to start recovery over.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Are you running in Archivelog mode ... Do you have the last HOT or last COLD backup ???

    Gregg

  4. #4
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unhappy Backup

    I have a cold backup.

    Basically I am Oracle developer not a DBA. There is no DBA in the firm anymore so I have to do that recovery by myself. I don't know even any step about Database recovery on NT. I'll really appreciate if you could help me to get backup.

    To get back, I have to have a oracle database installed?
    what about the environment files? where have to place?
    etc

    Thank you very much for prompt reply.
    mr_roomi

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    First ... Are the database files currently on the machine and the database just won't come up ??? Did the server die an ugly death and we had to reload ??? ... What's the situation ...
    Also, if you still have it, there is an alertxxx.log file in the oracle\admin\xxx\udump (probably) directory ... This is the log that Oracle would write concerning problems... Cut and paste the last couple of pages here ...

    Gregg

  6. #6
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    Do you know the status of the database? Is it able to mount the control files or not? You check using the below steps. This is important, because sometimes the only "problem" is the database was restarted during a backup and all you need to do is end the backup, not recover anything. Another problem that can occur is you lose just one of your many control files and Oracle refuses to start until you remove the reference to the missing file from your init.ora file (or recreate the file, whichever you prefer.) Again, no recovery would be required.

    1. open a command prompt (DOS) window.
    2. issue command set oracle_sid=yourdatabasename
    3. issue command sqlplus /nolog
    4. At the SQL> prompt (which the above command gives you) issue the command CONNECT / AS SYSDBA . If the above command fails, then replace / with SYS/TheSysPassword and try again.
    5. Issue the commands select * from v$recovery, select * from v$backup, and select open_mode from v$database.

    Also, I highly recommend you look at the alert_SID.log file per the earlier posting by gbrabham.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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