0 Replies Latest reply: Feb 28, 2013 7:26 PM by 147867 RSS

    Real-time downstreams capture issue

    147867
      I got error when enable real_time feature in downstreams capture:

      SQL> BEGIN
      DBMS_CAPTURE_ADM.SET_PARAMETER(
      capture_name => 'STR$CAP',
      parameter => 'downstream_real_time_mine',
      value => 'Y');
      END;
      / 2 3 4 5 6 7
      BEGIN
      *
      ERROR at line 1:
      ORA-26761: Standby Redo Logs not available for real time mining
      ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 69
      ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 181
      ORA-06512: at line 2

      The Streams work fine except for only capture change when source database archive redo logs.

      Redo Log transfer configuration as following.
      Source DB:
      ALTER SYSTEM SET LOG_ARCHIVE_CONFIG = 'DG_CONFIG=(PO42UAT,PO42RPT)' SCOPE=BOTH;
      ALTER SYSTEM SET LOG_ARCHIVE_DEST_4 = 'SERVICE=PO42RPT ASYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PO42RPT' SCOPE=BOTH;
      ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_4 = ENABLE SCOPE=BOTH;

      Destination DB:
      ALTER SYSTEM SET LOG_ARCHIVE_CONFIG = 'DG_CONFIG=(PO42UAT,PO42RPT)' SCOPE=BOTH;
      ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/u06/archive/PO42RPT VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)' SCOPE=BOTH;
      ALTER SYSTEM SET LOG_ARCHIVE_DEST_4 = 'LOCATION=/u06/archive/PO42UAT VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE)' SCOPE=BOTH;
      ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1 = ENABLE SCOPE=BOTH;
      ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_4 = ENABLE SCOPE=BOTH;


      Standby logfile created:
      ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/u02/oradata/PO42RPT/stby_redo04a.log','/u03/oradata/PO42RPT/stby_redo04b.log') SIZE 100M;
      ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ('/u02/oradata/PO42RPT/stby_redo05a.log','/u03/oradata/PO42RPT/stby_redo05b.log') SIZE 100M;
      ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ('/u02/oradata/PO42RPT/stby_redo06a.log','/u03/oradata/PO42RPT/stby_redo06b.log') SIZE 100M;
      ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 ('/u02/oradata/PO42RPT/stby_redo07a.log','/u03/oradata/PO42RPT/stby_redo07b.log') SIZE 100M;

      SQL> SELECT GROUP#, THREAD#, SEQUENCE#, ARCHIVED, STATUS FROM V$STANDBY_LOG;

      GROUP# THREAD# SEQUENCE# ARC STATUS
      ---------- ---------- ---------- --- ----------
      4 0 0 YES UNASSIGNED
      5 0 0 YES UNASSIGNED
      6 0 0 YES UNASSIGNED
      7 0 0 YES UNASSIGNED


      Source DB has three redo logfile groups, each member with 100M, same with standby redo logfile.

      Oracle version 11.2 on AIX.


      Any help appreciate.