auto space advisor导致ogg进程异常(OGG-00458)

来源:这里教程网 时间:2026-03-03 19:51:41 作者:

用户反馈ogg数据未实时同步至目标库,检查应用进程日志,部分报错信息如下:

根据日志看到在做抽取ddl时出现报错,mos匹配后,定位到时由于auto space advisor在shrink打标的空间时导致的。(参考文档:Extract Abend - OGG-00458 Cannot Find Metadata Property (Doc ID 2179454.1) ) 禁用:auto space advisorSteps to disable the "auto space advisor"1. Check the status of the "auto space advisor".SQL> SELECT client_name, status FROM dba_autotask_client;set lines 180 pages 1000col client_name for a40col attributes for a60select client_name, status,attributes,service_name from dba_autotask_client/2. Execute the below to disable the "auto space advisor".BEGINDBMS_AUTO_TASK_ADMIN.disable(client_name => 'auto space advisor',operation => NULL,window_name => NULL);END;/3. Check if the "auto space advisor" is disabled.set lines 180 pages 1000col client_name for a40col attributes for a60select client_name, status,attributes,service_name from dba_autotask_client/Restart the Extract process after disabling the "auto space advisor".Note: Please check with your Oracle Core DBA before disabling this "auto space advisor".4. To enable the "auto space advisor" execute the below,BEGINDBMS_AUTO_TASK_ADMIN.enable(client_name => 'auto space advisor',operation => NULL,window_name => NULL);END;/5. Check if the "auto space advisor" is disabled.set lines 180 pages 1000col client_name for a40col attributes for a60select client_name, status,attributes,service_name from dba_autotask_client/

相关推荐