
OGG (http://127.0.0.1:9000 deploy213) 7> dblogin useridalias ora12c domain OGGMA
Successfully logged into database.

OGG (http://127.0.0.1:9000 deploy213 as ora12c@LHRSDB) 8> UNREGISTER EXTRACT ext1 DATABASE
2022-07-22T06:28:26Z  INFO    OGG-12029  The item type extract with name 'EXT1' does not exist.

OGG (http://127.0.0.1:9000 deploy213 as ora12c@LHRSDB) 10> REGISTER EXTRACT ext1 DATABASE
2022-07-22T06:29:42Z  INFO    OGG-12029  The item type extract with name 'EXT1' does not exist.

OGG (http://127.0.0.1:9000 deploy213 as ora12c@LHRSDB) 11> ADD EXTRACT ext1 INTEGRATED TRANLOG BEGIN NOW

2022-07-22T06:30:11Z  ERROR   OGG-08241  Error: This Extract group EXT1 is already registered with the database.

OGG (http://127.0.0.1:9000 deploy213) 7> dblogin useridalias ora12c domain OGGMA

Successfully logged into database.

OGG (http://127.0.0.1:9000 deploy213 as ora12c@LHRSDB) 8> UNREGISTER EXTRACT ext1 DATABASE

2022-07-22T06:28:26Z INFO OGG-12029 The item type extract with name 'EXT1' does not exist.

OGG (http://127.0.0.1:9000 deploy213 as ora12c@LHRSDB) 10> REGISTER EXTRACT ext1 DATABASE

2022-07-22T06:29:42Z INFO OGG-12029 The item type extract with name 'EXT1' does not exist.

OGG (http://127.0.0.1:9000 deploy213 as ora12c@LHRSDB) 11> ADD EXTRACT ext1 INTEGRATED TRANLOG BEGIN NOW

2022-07-22T06:30:11Z ERROR OGG-08241 Error: This Extract group EXT1 is already registered with the database.

MA界面报错：

OGG-08221 | Cannot register or unregister Extract group EXT1 because of the following SQL error: OCI Error ORA (status = 26665-ORA-26665: GoldenGate process OGG$CAP_EXT1 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 176 ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 65 ORA-06512: at line 1 ).

解决


SQL> exec DBMS_XSTREAM_GG_ADM.STOP_OUTBOUND('OGG$EXT1',true);
SQL> exec DBMS_XSTREAM_ADM.DROP_OUTBOUND('OGG$EXT1');
SQL> exec DBMS_STREAMS_ADM.REMOVE_QUEUE(queue_name => 'OGG.OGG$EXT1', cascade => true, drop_unused_queue_table => true);

If the above works correctly, execute these selects to check.

SQL> select * from DBA_XSTREAM_OUTBOUND;
SQL> select SERVER_NAME from SYS.XSTREAM$_SERVER;

-- 解决RMAN-08137、OGG-02870
ERROR   OGG-02870  Missing Log File WAITING FOR REDO: FILE /u01/app/oracle/flash_recovery_area/LHRSDB/archivelog/2022_07_01/o1_mf_1_21_kcwpp3cs_.arc, THREAD 1, SEQUENCE 21, SCN 0x000000000021466a. Read Position SCN: Not available.

-- 手动删除归档日志报错，解决办法：可以直接删除OGG用户
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

select * from dba_queues where OWNER='OGG';
select capture_name from dba_capture;

exec DBMS_CAPTURE_ADM.DROP_CAPTURE ('OGG$CAP_EXT12C');
exec DBMS_CAPTURE_ADM.DROP_CAPTURE ('OGG$CAP_EXTO');

-- DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'OGG$Q_EXTO', force => TRUE);
-- select TNAME
-- from tab where TABTYPE='TABLE' 
-- AND TNAME LIKE 'AQ$_OGG$Q_TAB_%';
-- 
-- select 'EXEC DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => '''||NAME||''', force => TRUE);' 
-- from   dba_queues where OWNER='OGG';

-- OGG-01758
select apply_name from dba_apply;
exec dbms_apply_adm.drop_apply('OGG$CAP_EXT12C');

SQL> exec DBMS_XSTREAM_GG_ADM.STOP_OUTBOUND('OGG$EXT1',true);

SQL> exec DBMS_XSTREAM_ADM.DROP_OUTBOUND('OGG$EXT1');

SQL> exec DBMS_STREAMS_ADM.REMOVE_QUEUE(queue_name => 'OGG.OGG$EXT1', cascade => true, drop_unused_queue_table => true);

If the above works correctly, execute these selects to check.

SQL> select * from DBA_XSTREAM_OUTBOUND;

SQL> select SERVER_NAME from SYS.XSTREAM$_SERVER;

-- 解决RMAN-08137、OGG-02870

ERROR OGG-02870 Missing Log File WAITING FOR REDO: FILE /u01/app/oracle/flash_recovery_area/LHRSDB/archivelog/2022_07_01/o1_mf_1_21_kcwpp3cs_.arc, THREAD 1, SEQUENCE 21, SCN 0x000000000021466a. Read Position SCN: Not available.

-- 手动删除归档日志报错，解决办法：可以直接删除OGG用户

RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

select * from dba_queues where OWNER='OGG';

select capture_name from dba_capture;

exec DBMS_CAPTURE_ADM.DROP_CAPTURE ('OGG$CAP_EXT12C');

exec DBMS_CAPTURE_ADM.DROP_CAPTURE ('OGG$CAP_EXTO');

-- DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'OGG$Q_EXTO', force => TRUE);

-- select TNAME

-- from tab where TABTYPE='TABLE'

-- AND TNAME LIKE 'AQ$_OGG$Q_TAB_%';

-- select 'EXEC DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => '''||NAME||''', force => TRUE);'

-- from dba_queues where OWNER='OGG';

-- OGG-01758

select apply_name from dba_apply;

exec dbms_apply_adm.drop_apply('OGG$CAP_EXT12C');

NOTE

You can use the above method to clean up any unregister extract database issues. However DO NOT use this as a substitute for GGSCI UNREGISTER. Always attempt the normal ggsci unregister first.

参考

UNREGISTER EXTRACT DATABASE Fails with SQL error: OCI Error retrieving bind info for query (status = 100) (Doc ID 2088522.1)

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！

OGG-02024 An attempt To Gather Information About The Logmining Server Configuration From The Oracle Database Failed (Doc ID 2304082.1)

OGG-01755/OGG-08241 trying to register integrated extract after it has been un-registered (Doc ID 2294690.1)

SYMPTOMS

Trying to register an integrated extract process that was previously unregistered fails with the following error:

GGSCI (alth077) 4> REGISTER EXTRACT MYIEXT1 DATABASE

2017-08-07 13:17:39 WARNING OGG-01758 This EXTRACT MYIEXT1 is already registered with the database.

GGSCI (alth077) 4> REGISTER EXTRACT MYIEXT1 DATABASE

2017-08-07 13:17:39 WARNING OGG-01758 This EXTRACT MYIEXT1 is already registered with the database.

an un-register extract fails with the errors:

2017-08-03 14:41:34 ERROR OGG-01755 Cannot register or unregister EXTRACT MYIEXT1 because of the following SQL error: OCI Error retrieving bind info for query (status = 100). See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide.

In GoldenGate 12c the register fails with an error:

CAUSE

Apply process associated to the extract was not removed when the extract was unregistered:

The follooinwg queries can be used to identify if the unregister did not remove the apply:

select capture_name from dba_capture;

no row selected

select server_name, capture_name from dba_xstream_outbound WHERE server_name = SUBSTR(UPPER('OGG$MYIEXT1'), 1, 30);

SERVER_NAME CAPTURE_NAME
------------------------------ ------------------------------
OGG$MYIEXT1

select apply_name from dba_apply;

select apply_name from dba_apply where apply_name = 'OGG$MYIEXT1';

APPLY_NAME
------------------------------
OGG$MYIEXT1

select capture_name from dba_capture;

no row selected

select server_name, capture_name from dba_xstream_outbound WHERE server_name = SUBSTR(UPPER('OGG$MYIEXT1'), 1, 30);

SERVER_NAME CAPTURE_NAME

------------------------------ ------------------------------

OGG$MYIEXT1

select apply_name from dba_apply;

select apply_name from dba_apply where apply_name = 'OGG$MYIEXT1';

APPLY_NAME

------------------------------

OGG$MYIEXT1

The apply will also show in the APPLY PROCESS INFORMATION section of the GoldenGate Health check report.

SOLUTION

Drop the apply process associated to the extract manually using:

exec dbms_apply_adm.drop_apply('OGG$MYIEXT1');

1	exec dbms_apply_adm.drop_apply('OGG$MYIEXT1');

总结

1、若不再需要OGG的进程或不再需要逻辑DG配置，则可以直接删除OGG用户：

drop user ogg cascade;

1	drop user ogg cascade;

以上问题可自然解决！！！

打赏赞(2)

标签：故障处理 OGG OGG-01758 OGG-08221 OGG-08241 OGG-12029 RMAN-08137

小麦苗

学习或考证，均可联系麦老师，请加微信db_bao或QQ646634621

发表回复取消回复

要发表评论，您必须先登录。

2024年 4月
一	二	三	四	五	六	日
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

嘿，我是小麦，需要帮助随时找我哦。

18509239930
个人微信
DB宝
个人邮箱
点击加入QQ群
个人微店
回到顶部

合 OGG故障OGG-12029、OGG-08241、OGG-08221、OGG-01758、OGG-02870、RMAN-08137

现象 OGG-12029、OGG-08241、OGG-08221、OGG-01758、OGG-02870、RMAN-08137

解决

NOTE

参考

OGG-01755/OGG-08241 trying to register integrated extract after it has been un-registered (Doc ID 2294690.1)

SYMPTOMS

CAUSE

SOLUTION

总结

相关文章

您可能还喜欢...

发表回复取消回复

网站公告

网站寄语

本站其它工具

搜索本网站

标签云☁

网站日历

网站归档

网站分类

合 OGG故障OGG-12029、OGG-08241、OGG-08221、OGG-01758、OGG-02870、RMAN-08137

现象 OGG-12029、OGG-08241、OGG-08221、OGG-01758、OGG-02870、RMAN-08137

解决

NOTE

参考

OGG-01755/OGG-08241 trying to register integrated extract after it has been un-registered (Doc ID 2294690.1)

SYMPTOMS

CAUSE

SOLUTION

总结

相关文章

您可能还喜欢...

rac安装报错“Checking swap space: 0 MB available, 150 MB required. Failed”

GreenPlum中的primary和mirror之间一直处于Not In Sync状态

DETAIL: The database was initialized with LC_COLLATE "en_US.utf8"

发表回复 取消回复

网站公告

网站寄语

本站其它工具

搜索本网站

标签云☁

网站日历

网站归档

网站分类

发表回复取消回复