We are going to learn about the solution which is used solve error we use While adding the replicate, you may get the below error.

GGSCI (sec75-2) 2> add replicate LOYTSTR, exttrail /ggatebss/oradata/RBM12C/R4

ERROR: No checkpoint table specified for ADD REPLICAT.

Solution:

 

Checkpoint table needs to be created on the replication side.

1. Login to ggsci with dblogin

GGSCI (sec75-2) 4> dblogin USERID TEST_GGATE, PASSWORD TEST_GGATE

Successfully logged into the database.

2. Add checkpoint table

GGSCI (sec75-2 as TEST_GGATE@TESTPROD1) 5> add checkpointtable TEST_ggate.TESTcheckpoint

Successfully created checkpoint table TEST_ggate.TESTcheckpoint.

3. Restart the manager

GGSCI (sec75-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 …

Request processed.

Manager stopped.

GGSCI (sec75-2 as TEST_GGATE@TESTPROD1) 10> start mgr

Manager started.

4. Now add the replicate by login to ggsci

GGSCI (sec75-2) 4> dblogin USERID TEST_GGATE, PASSWORD TEST_GGATE

Successfully logged into the database.

GGSCI (sec75-2 as TEST_GGATE@TESTPROD

About The Author

Leave a Reply