GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to restore the Database checkpoint table if its dropped

edited Oct 9, 2013 5:28AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
 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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center