Recover Oracle datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Recover Oracle datafile

Hybrid View

  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Recover Oracle datafile

    Hi all,
    unfortunately my hard disk's server crashed, and I do not have any backup,
    I recovered oradata folder in crashed hard disk, which is contains DBF, Ora and log files as attachment picture.
    My Oracle database version is 10.2.
    would you please guid me how can I recover my databse step by step?
    Attached Images Attached Images

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,445
    Your oradata directory seems to be under the same path as your oracle home:

    F:\EE automation\oracle\product\10.2.0\db1

    Is this true or do you have the original oracle home on another disk (perhaps 'C:'?)

    The procedure would be to just copy your recovered files from disk 'F:' to their original location and try start the database.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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