How to restore the Database checkpoint table if its dropped
Hi all,
I did a small test in goldengate replication.
I dropped the checkpoint table on database side that is used for replicat process.
I know the information in database checkpoint table is same as that of checkpoints in checkpoint file in ./dirchk directory,
So I dropped the database checkpoint table using drop table <checkpoint table>;
Then replicat was not able to start at all.
Then I recreated checkpoint table using ggsci> add checkpointable
But a new checkpointable with no data is created . Due to that(no data),I cannot start replicat process.
So finally I decided to restore database checkpointable using database methods (such as database backups).
0