合 OGG故障OGG-12029、OGG-08241、OGG-08221、OGG-01758、OGG-02870、RMAN-08137
Tags: 故障处理OGGRMAN-08137OGG-12029OGG-08241OGG-08221OGG-01758
现象 OGG-12029、OGG-08241、OGG-08221、OGG-01758、OGG-02870、RMAN-08137
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | 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 ).
解决
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 31 32 33 34 | 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)
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:
1 2 3 | 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.