This discussion is archived
0 Replies Latest reply: Feb 28, 2013 5:26 PM by 147867 RSS

Real-time downstreams capture issue

147867 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points