ORA-26761: Standby Redo Logs not available for real time mining
edited Aug 15, 2016 3:05PM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered ✓
Source database: Oracle 10g R2 (10.2.0.5.12) on SPARC
Target database : Oracle 10gR2 (10.2.0.5.12) on SPARC
I receive below error although standby redo logs are available as shown below:
SQL> BEGIN
dbms_capture_adm.set_parameter( capture_name => 'DOWNSTREAM_CAPTURE',
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 67
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 68
ORA-06512: at line 2
--- Redo logs and standby statuses
SQL> select * from v$standby_log;
GROUP# DBID THREAD# SEQUENCE# BYTES USED ARC STATUS FIRST_CHANGE# FIRST_TIM LAST_CHANGE# LAST_TIME
0