Some times it’s impossible to unregister Integrated Extract, however it need to exclude to avoid RMAN failures.
Follow below to hack GoldenGate registration:
SQL> select CAPTURE_NAME from dba_capture; CAPTURE_NAME ------------------------------ OGG$CAP_IE_CAPT
GGSCI (myhost as ggate@foodb) 13> unregister extract IE_CAPT database
ERROR OGG-08222 EXTRACT IE_CAPT must be registered with the database to perform this operation.
Try it:
SQL> select 'exec DBMS_CAPTURE_ADM.DROP_CAPTURE ('''||capture_name||''');' from dba_capture; 'EXECDBMS_CAPTURE_ADM.DROP_CAPTURE('''||CAPTURE_NAME||''');' ---------------------------------------------------------------------- exec DBMS_CAPTURE_ADM.DROP_CAPTURE ('OGG$CAP_IE_CAPT'); SQL> exec DBMS_CAPTURE_ADM.DROP_CAPTURE ('OGG$CAP_IE_CAPT'); PL/SQL procedure successfully completed.
Maiquel.
Pingback: Behind the scene – Integrated Capture – |GREP ORA
Pingback: OGG-08221 Cannot register or unregister EXTRACT – |GREP ORA