Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Post Unanswered: Tablespace Recovery

    Hi Gurus,

    I am using UDB7.2.My problem is yesterday i have taken a offline backup.Today i renamed one tablespace.First it was worked fine.After 2 hours the database has been crashed meanwhile somany transactions were done.What can i do.How can I recover the data without losing.

    Please its urgent.

    Thanks for Advance.Ur answer fully appreciated.

    Urgent.......

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Tablespace Recovery

    AFAIK,

    1) If you want to restore at the db level, you can go ahead and restore ... Your renmae will be available in the logs and hence will be done during rollforward

    2) If you want to restore only that renamed tablespace, use the new name in the restore and rollforward commands ...



    Cheers
    Sathyaram




    Originally posted by kprksr
    Hi Gurus,

    I am using UDB7.2.My problem is yesterday i have taken a offline backup.Today i renamed one tablespace.First it was worked fine.After 2 hours the database has been crashed meanwhile somany transactions were done.What can i do.How can I recover the data without losing.

    Please its urgent.

    Thanks for Advance.Ur answer fully appreciated.

    Urgent.......
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2003
    Posts
    2

    Post Re: Tablespace Recovery

    Thank U.

    Have i any url for help?

    Thank u

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Tablespace Recovery

    DB2 Data Recovery and High Availability Guide
    ftp://ftp.software.ibm.com/ps/produc...r/db2hae71.pdf

    When restoring a table space that has been renamed since it
    was backed up, the new table space name must be used when
    invoking the restore utility. If the old name is used, the table
    space will not be found.

    If you have renamed a table space following the most recent backup
    operation, ensure that you use the new name when rolling the table space
    forward. The previous table space name will not be recognized.

    Cheers
    Sathyaram

    Originally posted by kprksr
    Thank U.

    Have i any url for help?

    Thank u
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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