Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2003
    Posts
    33

    Unanswered: recover tablespace

    Accidentally i have deleted some data . Now when i wanted to recover the table space with option torba but the last image copy on the tablespace requested by the job is not available. (tape got scratched for some reason).
    Is there a way i can recover the tablespace.
    Is there a way to undo what i have today(i mean delete).
    Any help is appreciated. ....
    hurry please,
    Last edited by chas_dba; 07-22-04 at 12:04.
    bs

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by chas_dba
    Accidentally i have deleted some data . Now when i wanted to recover the table space with option torba but the last image copy on the tablespace requested by the job is not available. (tape got scratched for some reason).
    Is there a way i can recover the tablespace.
    Is there a way to undo what i have today(i mean delete).
    Any help is appreciated. ....
    hurry please,
    Do you have an older backup that's ok + all the logs since? You could restore from that, although it may take a while to roll forward through them.
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Sep 2003
    Posts
    33
    No, thats the only image copy on this table. But i have all the log tapes
    will that be okay...can u be more specific
    bs

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Can you find the scratched tape and try to recatalog it (assuming the tape has not been reused)?

    If not, I don't know of anyway to recover without an image copy.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by chas_dba
    No, thats the only image copy on this table. But i have all the log tapes
    will that be okay...can u be more specific
    You really don't have a lot of options here without a backup. If you have an old backup and logs you can restore from that and RF to just before your delete, otherwise you may be out of luck. There's no way to roll back committed transactions.
    --
    Jonathan Petruk
    DB2 Database Consultant

  6. #6
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    if it is OS/390 , you any 3rd party tool , like BMC change manager or Platinum( now CA tools log analyser ) , if yes , you restore it by using above tools


    Hope it may help


    Thank You

    Lekharaju Ennam

  7. #7
    Join Date
    Sep 2003
    Posts
    33
    we are not having any tools for the matter of fact. But, definetly this is a good time to look for one. guys, do you know where can i get some info about tools availble. we are os/390 r2v10 and db2 v7.1.
    Regarding the data, application shall take care of it...
    thanks a lot to u all for the responding.
    bs

  8. #8
    Join Date
    Apr 2004
    Posts
    64

    Re

    If I remember correctly, BMC has a facility using which you can give the "FROM" and "TO" time(No RBA etc needed) and it will generate UNDO DDL/DML/DCL etc . Then you can run that to undo. It uses the LOG to generate the SQL. It is mostly valid for very recent changes like what you did accidental delete.

    But since you don't have BMC, I don't know any other way.

Posting Permissions

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