IBM Tivoli Storage Manager for Databases, Data Protection for Oracle, Version 7.1

tdposync utility

The tdposync utility checks for items on the Tivoli® Storage Manager server that are not in the RMAN catalog or Oracle control file. With this utility, you can repair these discrepancies by removing unwanted objects from the Tivoli Storage Manager, and reclaim space on the server.

Attention: Deleted files and inactive files cannot be restored. When you are using this utility to delete files, ensure that you do not log in to the wrong node name. You might query a different database than intended, and delete files in error. Ensure that the node name in the PICK window is the one you need. See Optional parameters and PICK window for further details.

When you run an RMAN deletion script, entries are deleted in the RMAN recovery catalog or Oracle control file before confirmation from the Tivoli Storage Manager server. In cases where objects are not found on the Tivoli Storage Manager server, RMAN tries to delete backup sets from the Tivoli Storage Manager server and fails. However, the entries in the RMAN catalog or control file for these objects are still removed. When they are deleted, RMAN can no longer identify these backups through the catalog or control file even though the file exists on the Tivoli Storage Manager server. This utility therefore synchronizes the contents of the servers.

When the RMAN catalog or control file contains backups that are marked as expired, RMAN still considers these objects as existing. If you run the tdposync utility against these objects, it recognizes these objects in the RMAN catalog or control file and on the Tivoli Storage Manager server and considers them to be in sync. Therefore, you must delete these objects from the RMAN catalog or control file for them to be deleted from the Tivoli Storage Manager server. Use the Oracle crosscheck command to verify whether the backups exist. Then, use the Oracle delete expired command to remove their record from the RMAN catalog or control file.

When you start tdposync, the following processing takes place:

Prompts you for the RMAN catalog owner ID or the Oracle database user name, password, and connect string.
Gathers information for the Oracle servers.
Queries the Oracle backup catalog and the Tivoli Storage Manager server.
Displays a list of files that exist on the Tivoli Storage Manager server but not in the RMAN catalog or Oracle control file.
Prompts you to take one of the following actions:
- Delete any files found causing the discrepancy.
- Delete all files.
- Exit the program without deleting files from the Tivoli Storage Manager server.

Feedback