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

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.

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

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

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.