why is Roll-forward required after Restore (was "I need help!!! urgent!")

DB_N00b · #1 (**permalink**) 07-25-11, 09:06

Hello,

I dont have access to two tablespaces anymore and now i want to restore them because they are in restore pending mode with this command:

RESTORE DATABASE SONL2 TABLESPACE (tablespace1, tablespace2) ONLINE USE TSM OPEN 2 SESSIONS TAKEN AT 20110608153009 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;

but then this error comes up:

SQL2537N Roll-forward is required following the Restore.

What can I do?

przytula_guy · #2 (**permalink**) 07-25-11, 09:52

if you restore a tablespace it has to be become inline with the information in syscatspace
rollforward is needed to apply changes, executed after the backup was executed
see rollforward commend :
ROLLFORWARD DATABASE
was the access denied to the ts before the restore or why was the restore initiated ?

DB_N00b · #3 (**permalink**) 07-25-11, 09:54

hey,

yeah, i have 2 "restore pending" tablespaces ... and thats why i want to restore them ... but i just dont know how to fix this.

sathyaram_s · #4 (**permalink**) 07-25-11, 09:56

It can be a "dummy" rollforward - ie, rollforward to the point in time of the backup itself instead of applying changes.

The madotory minimum point in time for rollforward on a tablespace can be found using list tablespaces show detail command .

HTH

Sathyaram

DB_N00b · #5 (**permalink**) 07-25-11, 09:58

what do you mean with?

do you have an example of a command? the tablespaces names are tablespace1, tablespace2

sathyaram_s · #6 (**permalink**) 07-25-11, 10:02

Code:

db2 connect to sample
db2 list tablespaces show detail

You will have to look for "Minimum Recovery Time" for the two tablespaces in scope.
After you restore the tablespaces, it is mandatory to rollforward the tablespaces to atleast the time in the above output. Otherwise, your rollforward complete will fail.
This time is to ensure the object information in the tablespaces matches the info in the catalog tables. (eg. a new table creation will change the minimum recovery time)

Restore Database ... Tablespace

HTH

DB_N00b · #7 (**permalink**) 07-25-11, 10:03

This are the two restore pending tablespaces

Quote:

Tablespace ID = 27
Name = Tablespace1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0100
Detailed explanation:
Restore pending

Tablespace ID = 30
Name = Tablespace2
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0100
Detailed explanation:
Restore pending

DB_N00b · #8 (**permalink**) 07-25-11, 10:04

What do i have to do now? Rollforward them?

db2 " rollforward database db_test tablespace tablespace1 tablespace2 online" ???

przytula_guy · #9 (**permalink**) 07-25-11, 10:05

Sathyaram I agree with you, but you can not specify a timestamp that would create an inconsistent db by specifying a timestamp smaller than another modification committed/available in the database.

przytula_guy · #10 (**permalink**) 07-25-11, 10:07

if you want to recover all :
rollforward .. tablespace ( tablespace1, tablespace2 ) to end of logs and complete...

DB_N00b · #11 (**permalink**) 07-25-11, 10:12

mm i entered this command and it doesnt work ... :-(

Quote:

db2 " rollforward database db_test tablespace (tablespace1,tablespace2) to end of logs and complete"

SQL0104N An unexpected token "to" was found following ")". Expected tokens
may include: "END-OF-STATEMENT". SQLSTATE=42601

przytula_guy · #12 (**permalink**) 07-25-11, 10:15

sorry, but there is always the infocenter for correct syntax
ROLLFORWARD DATABASE
it should be
db2 " rollforward database db_test to end of logs and complete tablespace (tablespace1,tablespace2) online"