1 Reply Latest reply: Dec 6, 2012 2:08 PM by 978197 RSS

    Oracle 11gR2 - Asynchronous Distributed HotLog (SOURCE database RAC)

    978197
      SOURCE:
      database version: 11.2.0.3.0
      2 instances (parameter compatible: 11.2.0.3.0)

      TARGET:
      database version: 11.2.0.3.0
      service (parameter compatible: 11.2.0.0.0)


      Steps run with success:
      Step 1 - Source Database DBA: Set the database initialization parameters.
      Step 2 Source Database DBA: Alter the source database.
      Step 3 Source Database DBA: Create and grant privileges to the publisher.
      Step 4 Source Database DBA: Prepare the source tables.
      Step 5 Staging Database Publisher: Create change sets.
      Step 6 Staging Database Publisher: Create the change tables that will contain the changes to the source tables.
      Step 7 Staging Database Publisher: Enable the change set.

      -------------------------------------------------------------------------------------
      Status INITIAL in "db Source":

      --WAITING FOR TRANSACTION
      select CAPTURE_NAME, STATE from gv$streams_capture;
      --ENABLED
      select status,error_message from dba_capture;
      --ENABLED
      select status,error_message from dba_propagation;

      Status INITIAL in "db Target":
      --ENABLED
      select status,error_message from dba_apply;

      -------------------------------------------------------------------------------------
      Status after start capturing data

      ABORTED  ORA-26744: Streams capture process "xpto" does not support "owner"."table_name" because of the following reason:
      select status,error_message from dba_capture;


      The error description is only this (without reason).
      In the trace of the database have not description about the error.

      Any idea?

      Regards.
        • 1. Re: Oracle 11gR2 - Asynchronous Distributed HotLog (SOURCE database RAC)
          978197
          Solution to solve this problem:
          stop capture/propagation/apply
          drop current capture
          BEGIN
          DBMS_CAPTURE_ADM.DROP_CAPTURE(
          capture_name => 'capture',
          drop_unused_rule_sets => true);
          END;
          build - get new scn
          DECLARE
          scn NUMBER;
          BEGIN
          DBMS_CAPTURE_ADM.BUILD(first_scn => scn);
          DBMS_OUTPUT.PUT_LINE('First SCN Value = ' || scn);
          END;
          prepare tables instatiation
          BEGIN
          dbms_capture_adm.prepare_global_instantiation();
          END;
          create capture
          BEGIN
          DBMS_CAPTURE_ADM.create_capture(queue_name => 'queue_owner.queue_capture' ,
          capture_name => 'capture',
          rule_set_name => 'rule_set_owner.rule_set_name',
          source_database => 'source_db',
          start_scn => <new scn>,
          use_database_link => false,
          first_scn => <new scn>);
          END;
          start capture/propagation/apply