Recover tablespace using full online backup

ggnanaraj · #1 (**permalink**) 02-21-06, 00:04

DB2 v7.2

2 Containers of 2 table spaces were removed by SA. I need to recover the tables paces. Can I do this recovery using a full online backup of the database?

The 2 tablespaces are offline now. When give command to switch online, gives the following message:

Quote:

$ db2 "alter tablespace tswktable switch online"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0293N Error accessing a table space container. SQLSTATE=57048
$

BTW, DROP_RECOVERY is not set for these table spaces. So also, one table space contains 'user temporary data' as shown below:

Quote:

$ db2 "select tbspace, drop_recovery, tbspacetype, datatype from syscat.tablespaces where tbspace = 'USERTEMPSPC1' WITH Ur"

TBSPACE DROP_RECOVERY TBSPACETYPE DATATYPE
------------------ ------------- ----------- --------
USERTEMPSPC1 N S U

1 record(s) selected.

$ db2 "select tbspace, drop_recovery, tbspacetype, datatype from syscat.tablespaces where tbspace = 'TSWKTABLE' with ur"

TBSPACE DROP_RECOVERY TBSPACETYPE DATATYPE
------------------ ------------- ----------- --------
TSWKTABLE N S A

1 record(s) selected.

$

TIA.

sathyaram_s · #2 (**permalink**) 02-21-06, 03:10

Yes, it is possible to restore tablespaces whose containers are dropped from an online backup ...

You will have to follow the restore by a rollforward to the minmum recovery point, whose timestamp can be found in list tablesapaces show detail

HTH

Sathyaram

BTW, before switching online, did you do a system level restore of the deleted tablespace containers ?

the DROP_RECOVER, IIRC, is for the tables only ...

HTH

Sathyaram

Internet Services

Web Development

Digital Marketing

Consumer Tech