Results 1 to 11 of 11
  1. #1
    Join Date
    Aug 2006
    Posts
    4

    Post Unanswered: Need to restore database....

    Hi,

    I am seriously stuck with my oracle database.

    My oracle database has completly crashed but I have the physical file available in oradata folder, can I restore my database using this file in any ways.

    Please reply ASAP.

    Thanks In Adavance...

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    You'll need to provide a LOT more information for anybody here to be able to help out:

    1. What version of Oracle are you using?

    2. What operating system?

    3. What backup method were you using (user managed or RMAN)?

    4. You say you have the physical file; what about the controlfile? what about the init.ora file? Was the database using a pfile or an spfile?

    5. What mode was the database in when it crashed (ARCHIVELOG or NOARCHIVELOG)?

    6. If the database was in ARCHIVELOG mode, are the archived redo log files available?

    7. What errors are present in the alert log? What was the proximate cause for the database crashing?

    Regards,

    hmscott

    PS. I am no expert on recovering Oracle. I have practiced it a few times, but most likely there will be others on the board with far more experience than me. But they will need much of this information to be of assistance to you.
    Have you hugged your backup today?

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    OS?
    Oracle version?
    What errors do you get when trying to start the db?
    What is in the alert log?
    Is you db in archive mode?
    Do you have any other backups?


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    LKBrwn,

    Well at least I know I'm not out in left field asking all these questions!

    Regards,

    hmscott
    Have you hugged your backup today?

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by hmscott
    LKBrwn,

    Well at least I know I'm not out in left field asking all these questions!

    Regards,

    hmscott
    Sorry, our posts must have crossed at the same time.

    But yes, the OP needs to provide some more info.

    @wasimjaved: You need to check this out first.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Dec 2002
    Posts
    1,245
    Uh, I guess it wasn't all that critical anyway?

    Regards,

    hmscott
    Have you hugged your backup today?

  7. #7
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by wasimjaved
    Hi,

    I am seriously stuck with my oracle database.

    My oracle database has completly crashed but I have the physical file available in oradata folder, can I restore my database using this file in any ways.

    Please reply ASAP.

    Thanks In Adavance...

    No exports (.DMP) files ? Full, schema level ? This is a start.

  8. #8
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs down


    It seems wasimjaved has abandoned the post..What do you expect from someone who has no DB backups?

    Last edited by LKBrwn_DBA; 09-27-06 at 16:34.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  9. #9
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Did you mean that OP also has abandoned his work?

  10. #10
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking


    Or maybe he was fired for not being able to restore the db.

    PS: It's been a slow day.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  11. #11
    Join Date
    Aug 2006
    Posts
    4

    Thanks

    Hi,

    Sorry guys I was off for two days.

    Thanks to everyone....

    I tried different help but still the database has not restored to its actuall condition. Well, though the database was production database but it was in quite early phase so not much work was done on it that is why I have decided to redo it because redoing might not take much time for me since their was not much work done on it.

    Again thanks to all for support ......

Posting Permissions

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