Table dropped, Help recq
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Table dropped, Help recq

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    hi,
    I have taken a hotbackup of one of the tablespaces(ts_sales), Accidentaly,one of the tables (sales_mis) have got dropped. Luckily, there were no transactions/updates into this table, after the backup.
    I have to recover only this table (sales_mis),
    can I have your advice.

    Badrinath

  2. #2
    Join Date
    Jan 2001
    Posts
    9
    Since the table exist in old backup you need to restore old database in order to extract table.
    I think the easy way is:
    1- table a backup of current database also take a export to be safe.
    2- restore the old backup.
    3- recover database
    4- take an export of the table.
    5- restore the current backup
    6- recover
    7- import the table into the current database
    shonaryar

  3. #3
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    You need to perform an incomplete recovery up to the time when your table was dropped. For this is not enough to have only one backup tablespace, you need to have the whole db backup, otherwise the only recovery you can make is a complete one which is going to lead you in the same point, with the table dropped. That's why I think the hot backup tablespace you have is useless. If you have a full db hot backup restore it and perform incomplete recovery.

  4. #4
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    Hi,
    I think the best way is to stick with shonaryar, alternatively you may do this also.

    1. Take a cold back of the current database
    2. Restore the complete database prior to dropping the table.
    3. Take a table level export of the necessary tables
    4. Replace the database with the database files, import the table using the existing export file.

    Regards
    Ganesh .R
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

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