ADSM-L

TDPOSYNC returns Backup Sets even if they are present in the RMAN catalog

2003-09-19 16:06:32
Subject: TDPOSYNC returns Backup Sets even if they are present in the RMAN catalog
From: Mike Angels <sysprogm AT VIRGILIO DOT IT>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 19 Sep 2003 21:52:42 +0200
Hi all,

I'm trying to use TDPOSYNC utility to delete all TSM entries no more present in 
the RMAN catalog.
As described in the manuals, TDPOSYNC should present, for the deletion, only 
the Backup Sets no more catalogued in RMAN catalog.
Instead the utility presents all Backup Sets, even if they are still in the 
RMAN catalog.

For example with the following command

tdposync syncdb
Catalog 1 User Name: rman
Catalog 1 Password: rman
Catalog 1 Connect String: europr
>From Date (mm/dd/yy): 09/01/03
To Date (mm/dd/yy): 09/01/03

give me the following Backup Sets:


               Backup Date            Size        Backup Name
        -----------------------------------------------------------------------
     1. |  09/01/03    16:05:58       15.00MB     /adsmorc//TTSM/503597152/33
     2. |  09/01/03    16:05:52       41.00MB     /adsmorc//TTSM/503597151/33
     3. |  09/01/03    16:05:44    2,048.00KB     /adsmorc//TTSM/503597143/33
     4. |  09/01/03    16:05:44    3,072.00KB     /adsmorc//TTSM/503597143/33
     5. |  09/01/03    16:00:51       41.00MB     /adsmorc//TTSM/503596850/33
     6. |  09/01/03    16:00:51       20.00MB     /adsmorc//TTSM/503596848/33
        |

Those Backup Sets should be, as report by the manual, files that exist on 
Tivoli Storage Manager but not on RMAN

but the RMAN command

list backup;

say that those Backup Sets are still in the RMAN catalog with AVAILABLE status 
as shown below for one of them:


List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
20034   329        503596857  0  503596848  331        01-SEP-03

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    20037   1   1   AVAILABLE   01-SEP-03              TTSM/503596848/331/1

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    2    /DATI_TTSM/oracle/data/rbs01.dbf      0  Full 36090      01-SEP-03
    3    /DATI_TTSM/oracle/data/users01.dbf    0  Full 36090      01-SEP-03
    4    /DATI_TTSM/oracle/data/temp01.dbf     0  Full 36090      01-SEP-03

Is someone else using the TDPOSYNC utility?
Has someone else any idea about this behavior?

Thanks,

Mike

<Prev in Thread] Current Thread [Next in Thread>
  • TDPOSYNC returns Backup Sets even if they are present in the RMAN catalog, Mike Angels <=