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
