Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    5

    Unanswered: restore tablespace with rollforward

    Hi,

    I have done a tablespace restore recently with a rollforward complete.

    Reason for this restore was a non-explainable dataloss
    on this tablespace. The table was dropped but the tablespace still existed. No one (including me) knows how this happened.
    Anyway. After restoring the tablespace it is still empty.

    Some questions:

    1. Is there a chance to chech the backup if there is any
    data for this tablespace?

    2. Can I restore the tablespace without rolling forward
    (just with cancel for example)?
    What points are needed for this?

    I know that the tablespace was changed on 30th january
    because an incremental backup was made on that day.

    3. Is it possible to rollforward to a time before this date e.g. 26th january (full online backup is from 26th jan)?

    I have an assumption that in the backup of 26th jan
    is a transaction which maybe drops the table.

    I hope I get some hints for this.


    Rgds,

    Oktay Altinyuva

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    1. You can try and restore it to a test database.

    2. Yes. Use the WITHOUT ROLLING FORWARD option on the restore.

    3. You would need to have a backup before the 26th to do that, and then roll forward to right before the time when you think the drop happened.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Check the Minimum Recovery Time of the tablespace using list tablespaces show detail(s) command ...

    You will have to rollforward atleast to that point in time ...

    You cannot use WITHOUT ROLLFORWARD if the backup you restore is less than the minmum time ...

    This minimum recovery time ensures that the catalog information is consistent with the actual objects ... As an example you create a table at 10 am and later decide to restore using a database image 10 pm previous night ... If you do not rollforward atleast to 10 am, your system catalog may still contain the information about the new table but your tablespace will not have the table .

    HTH

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

  4. #4
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    5
    Hi again,

    thanks for the infos so far.

    The Minimum Recovery Time is unfortunately the 30th
    jan so that I have to rollforward to this time.

    All backups before are deleted with db2adutl but are
    still available on TSM. They are only inactive.
    Will they still be restorable from the database?
    (I can't try this at the moment)

    Additional information I need is how to put a DB
    back to a state without any pending state. All LOG files
    are deleted with db2adutl and are not accessible via
    TSM (no inactive Logfiles like DB Backups see above).

    When I restore this backup I don't want to rollforward.
    Someone wrote here wrote that this may be possible
    but very tricky and without any support of IBM.

    Thanks in advance.

    Rgds,

    Oktay

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It may depend on whether you have on-line or off-line backups. You will normally need the logs if you have an on-line backup, however, IBM support may be able to help.

    If you have a full off-line database backup from before the drop table, I would try to restore it to another database name and see if you can recover the data that way.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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