1、问题

GGSCI (meshisdb as ogg01@hfcvtprd3) 114> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                            
EXTRACT     ABENDED     CVT_SFIS    128:25:12     03:05:17    



GGSCI (meshisdb as ogg01@hfcvtprd3) 115> register extract  CVT_SFIS database;

2025-05-07 12:37:44  ERROR   OGG-08221  Cannot register or unregister EXTRACT CVT_SFIS because of the following SQL error: OCI Error ORA (status = 26665-ORA-26665: GoldenGate process OGG$CAP_CVT_SFIS already exists
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 617
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 249
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 589
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_IVK", line 177
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 179
ORA-06512: at line 1
).

客户ogg抽取进程出现异常，处在abended状态

查看日志：

GGSCI (meshisdb as ogg01@hfcvtprd3) 44> view report CVT_SFIS

也看不出有效的信息，唯一一个ogg-00446看代码意思是找不到日志，但是查了下源端归档都在

2、处理

根据注册失败信息，进源端进行检查，错误提示进程注册的时候进程已经存在

SET LINESIZE 720;
COL SESSION_NAME FOR A16
COL GLOBAL_DB_NAME FOR A12
SELECT SESSION#,CLIENT#,SESSION_NAME,DB_ID,GLOBAL_DB_NAME FROM SYSTEM.LOGMNR_SESSION$;

select capture_name from dba_capture;

尝试进行删除工作

12:39:58 SYS@ hfcvtprd3 >exec DBMS_CAPTURE_ADM.STOP_CAPTURE('OGG$CAP_CVT_SFIS');

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01
12:39:59 SYS@ hfcvtprd3 >
12:40:25 SYS@ hfcvtprd3 >exec DBMS_CAPTURE_ADM.DROP_CAPTURE('OGG$CAP_CVT_SFIS');

BEGIN DBMS_CAPTURE_ADM.DROP_CAPTURE('OGG$CAP_CVT_SFIS'); END;

*
ERROR at line 1:
ORA-01338: Other process is attached to LogMiner session
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 855
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 817
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 346
ORA-06512: at line 1

可以stop，但是drop失败了，检查v$session视图

select sid,serial#,status,action,program,event,state from v$session  where action='OGG$CAP_CVT_SFIS - Logminer Merger';

发现可以进行DBMS_CAPTURE_ADM.STOP_CAPTURE操作，但是会话还是存在，怀疑是有问题，尝试kill session来杀

12:48:27 SYS@ hfcvtprd3 >alter system kill session '5310,16811' immediate;

顺利杀掉会话，再进行drop操作，发现提示进程已经不在了

12:49:24 SYS@ hfcvtprd3 >exec DBMS_CAPTURE_ADM.DROP_CAPTURE('OGG$CAP_CVT_SFIS');

至此，目的达成，进行注册进程操作，成功：

GGSCI (meshisdb as ogg01@hfcvtprd3) 119> register extract  CVT_SFIS database;

2025-05-07 12:50:00  INFO    OGG-02003  Extract CVT_SFIS successfully registered with database at SCN 24152255076027.

再根据ogg的日志提示，增加日志位置选项，最终成功启动

 ERROR   OGG-01044  The trail '/home/ogg/ogg_extra19c/dirdat/cvt_sfis/cs' is not assigned to extract 'CVT_SFIS'. Assign
 the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL /home/ogg/ogg_extra19c/dirdat/cvt_sfis/cs, EXTRACT CVT_SFIS".
 
 GGSCI (meshisdb as ogg01@hfcvtprd3) 134> start CVT_SFIS