point in time recovery results in a SQL1275N - on a DB2 8.1 FP11
We've got a database with several different tablespaces (two for every working-division). Now i have to restore an online-backup of one division to a certain time - that is a restore of two tablespaces...
The restore was made with:
db2 RESTORE DATABASE MISPROD TABLESPACE (IS16_SC, TS16_SC) USE TSM OPEN 1 SESSIONS TAKEN AT 20070630200003 newlogpath e:\temp WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
DB20000I The RESTORE DATABASE command completed successfully.
When i try to rollforward the transactions (because TBS pending is in effect) to the specific time i get the following message:
E:\temp>db2 rollforward db misprod to 2007-07-14-20.12.43 tablespace (ts16_sc, is16_sc) online overflow log path (e:\temp) noretrieve
SQL1275N The stoptime passed to roll-forward must be greater than or equal to
"2007-07-27-05.43.21.000000", because database "MISPROD" on node(s) "0"
contains information later than the specified time.
Maybe someone can tell me what to change that i can rollforward just to July 14 instead of July 27 (just for the two tablespaces).
Thank you in advance
Re: point in time recovery results in a SQL1275N - on a DB2 8.1FP11
Opened an PMR and received the information that (in this particular request) there is no chance to solve this problem. Therefor i'm trying to backup offline, restore and rollforward the database completely, then db2move export - restore from offline backup and import the data with replace-option.