table recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: table recovery

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    table recovery

    hi, I want to recover a lost table from my rman complete database backup. Is there any link showing this scenario.

    thanks,

  2. #2
    Join Date
    May 2007
    Posts
    5
    What version of Oracle you using?

    Sorry for my English

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,975
    If you are using 10g/11g, the table might be in the recycle bin. Otherwise you either have to restore the whole database to a point in time before the table was lost, or restore to another location to a time before the table was lost, and export the table. How you recover depends on how that table fits in with your application. i.e. If there are foreign keys you have to make sure that the data is there and the foreign keys are enabled again.
    this space intentionally left blank

  4. #4
    Join Date
    Mar 2008
    Posts
    140

    table recovery

    hi, it is oracle 9i database.


    thanks,

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    then you probably need to do tablespace point in time recovery and then export the table into you prod instance

  6. #6
    Join Date
    May 2007
    Posts
    5
    tablespace point in time recovery in 9i?

  7. #7
    Join Date
    May 2007
    Posts
    5
    You can using FLASHBACK QUERY option in Oracle 9i ( DML OPERATION). If table was dropped, then have to perform Incomplete recovery. Check documentation for more details.

    Regards

  8. #8
    Join Date
    May 2007
    Posts
    5
    Sorry davey23uk, my mistake. Oracle 9i support tablespace point in time recovery!

  9. #9
    Join Date
    Mar 2008
    Posts
    2
    Steps :

    1. Find out what time the table was dropped using logminer.

    2. Restore database to the other location (clone) before the time of table dropped.

    from RMAN
    - do the clone steps

    and finally

    run {
    set until time "TO_DATE('17-APR-2006:12:26:50','DD-MON-YYYY:hh24:mi:ss')";
    restore database;
    recover database;
    }
    alter database open resetlogs;

    finally export the table and import it into the production database.

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