How to synchronize data between two TSM databases

Answer

Sometimes when a database corruption occurs in a production environment, it is best to copy the database to another TSM service in a test environment to fix it with an audit database with fix=yes on.

The problem is that at the same time the database in production environment is still in use and so it is necessary to restore the database after audit (that of test environment) on the production system but this will cause the lost of some activities performed like new backups and so on.

The following method can be used to synchronize the two databases (one on which audit database has been run and one on which new changes have been occurred)

1. Perform export server on the TSM server in the production environment to maintain the changes performed while audit database was running.

2. Restore the "corrected" database (that after audit) onto the TSM server in the production environment.

3. Perform an import server in order to synchronize the corrected database with the production one.