在OGG的replicat进程配置完成后,发现配置错误,或者想删除某个进程的时候,报‘ERROR: Could not delete DB checkpoint for REPLICAT RLISDBCC (Database login required to delete database checkpoint).’
GGSCI (centerdb) 22> delete rlisdbcc
ERROR: Could not delete DB checkpoint for REPLICAT RLISDBCC (Database login required to delete database checkpoint).
解决过程如下:
GGSCI (centerdb) 23> dblogin userid ogg,password 7540000E
Successfully logged into database.
GGSCI (centerdb) 24> delete rlisdbcc
Deleted REPLICAT RLISDBCC.
需要在OGG中登录目标数据库后,在执行删除命令就可以成功。
因为你的checkpointtable OGG.checkpointtab 这个是在OGG中登录数据库后创建的,所以也只能登录数据库后才能删除。