Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how OGG forcibly delete replicat". In daily operation, I believe many people have doubts about how OGG forcibly delete replicat. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubt of "OGG how to forcibly delete replicat"! Next, please follow the editor to study!

GGSCI (WINDOWS-0QO8SQ0) 6 > dblogin userid system, password *

Successfully logged into database.GGSCI (WINDOWS-0QO8SQ0) 7 > delete rep2

ERROR: Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942: ta

Ble or view does not exist (status = 942). Deleting from checkpoint table ggate.

Checkpoint, group 'REP2', key 2986303197 (0xb1ff5edd), SQL).

GGSCI (WINDOWS-0QO8SQ0) 8 > delete rep2 force

ERROR: Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942: ta

Ble or view does not exist (status = 942). Deleting from checkpoint table ggate.

Checkpoint, group 'REP2', key 2986303197 (0xb1ff5edd), SQL).

GGSCI (WINDOWS-0QO8SQ0) 9 > delete replicat rep2!

WARNING: Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942:

Table or view does not exist (status = 942). Deleting from checkpoint table ggat

E.checkpoint, group 'REP2', key 2986303197 (0xb1ff5edd), SQL).

GGSCI (WINDOWS-0QO8SQ0) 10 > info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING

JAGENT STOPPED

REPLICAT RUNNING REP1 00:00:00 00:00:01 direct deletion, the error Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942.

The corresponding user ggate of the original OGG has been deleted.

Forced deletion had to be adopted.

Delete replicat rep2!

Force deletion through exclamation point

At this point, the study on "how to forcibly delete replicat by OGG" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.