DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: recovery one table from backup

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    Hi all,

    Oracle 8.0.6.1/NT4.0-sp6a.

    How can I recover 1 table from backup datafile. I have cold backup from last Sat. I don't think I can recover that table only if I cloned my production database (using cold backup from last Sat.) in test server than exporting that table and importing back to my production database. Is that right? Is there other way to recover this table? Some advise, please.

    Thanks,

    Elin@trend

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    No ways ...
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Apr 2001
    Posts
    151
    If I export from my test server (recreated from Sat. cold backup) and import back to my production database, I lost about 2-3 days data, right? If export/import is feasable, I don't care how much data lost and they need to re-entry all of them again. I guess this is the only way I can recover this table (incomplete recovery)???
    Thanks
    Elin@trend

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If you are not worried about the lost data you can do a export from restored cold backup and import it back to the production db.

    Good Luck
    Sanjay

  5. #5
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Once I had the same problem:
    one of our developers droped table. (DB in noarchivelog mode)
    So I created clone DB and made an export of 1 table, then import.

    Originally posted by elintrend
    If I export from my test server (recreated from Sat. cold backup) and import back to my production database, I lost about 2-3 days data, right? If export/import is feasable, I don't care how much data lost and they need to re-entry all of them again. I guess this is the only way I can recover this table (incomplete recovery)???
    Thanks
    Best wishes!
    Dmitri

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