Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184

    Unanswered: Recover tablespace using full online backup

    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:
    $ 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:

    $ 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.
    Last edited by ggnanaraj; 02-21-06 at 01:12.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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