DBA Hub

📋Steps in this guide1/5

ERROR: No checkpoint table specified for ADD REPLICAT DBACLASS

ERROR: No checkpoint table specified for ADD REPLICAT, while adding replicat. ..

oracle replicationintermediate
by OracleDba
14 views
1

Overview

While adding the replicate, you may get the below error. GGSCI (db75-2) 2> add replicat LOYTSTR, exttrail /ggatebss/oradata/RC12C/R4 ERROR: No checkpoint table specified for ADD REPLICAT. Checkpoint table need to be created in the replication side. 1. Login to ggsci with dblogin
2

Section 2

GGSCI (db75-2) 4> dblogin USERID TEST_GGATE, PASSWORD TEST_GGATE Successfully logged into database. 2. Add checkpoint table GGSCI (db75-2 as TEST_GGATE@TESTPROD1) 5> add checkpointtable TEST_ggate.TESTcheckpoint Successfully created checkpoint table TEST_ggate.TESTcheckpoint.
3

Section 3

3. Restart the manager GGSCI (db75-2 as TEST_GGATE@TESTPROD1) 9> stop mgr Manager process is required by other GGS processes. Are you sure you want to stop it (y/n)?y Sending STOP request to MANAGER …
4

Section 4

Request processed. Manager stopped. GGSCI (db75-2 as TEST_GGATE@TESTPROD1) 10> start mgr Manager started. 4. Now add the replicat by login to ggsci
5

Section 5

GGSCI (db75-2) 4> dblogin USERID TEST_GGATE, PASSWORD TEST_GGATE Successfully logged into database. GGSCI (db75-2 as TEST_GGATE@TESTPROD1) 6> add replicat LOYTSTR, exttrail /ggatebss/oradata/RC12C/R4 REPLICAT added.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!