0 Replies Latest reply: Jun 12, 2012 1:52 AM by malhi RSS

    Setting parameter 'downstream_real_time_mine'

    malhi
      parameter downstream_real_time_mine, was set as " => y " , due to some reason which i could not understand, it is now " => N " . When i want set it again, it is giving following error. How can set Y again.
      parameter => 'downstream_real_time_mine', 
      value => 'y'); 
      END;
      Error at line 1
      ORA-26761: Standby Redo Logs not available for real time mining
      ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 162
      ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 291
      ORA-06512: at line 2
      select * from v$standby_log;
      
      6     UNASSIGNED     1     0     52428800     512     0     NO     UNASSIGNED                              
      7     UNASSIGNED     1     0     52428800     512     0     NO     UNASSIGNED                              
      8     UNASSIGNED     1     0     52428800     512     0     NO     UNASSIGNED                              
      9     UNASSIGNED     1     0     52428800     512     0     NO     UNASSIGNED                              
      10     UNASSIGNED     1     0     52428800     512     0     NO     UNASSIGNED                              
      11     UNASSIGNED     2     0     52428800     512     0     NO     UNASSIGNED                              
      12     UNASSIGNED     2     0     52428800     512     0     NO     UNASSIGNED                              
      13     UNASSIGNED     2     0     52428800     512     0     NO     UNASSIGNED                              
      14     UNASSIGNED     2     0     52428800     512     0     YES     UNASSIGNED                              
      15     UNASSIGNED     2     0     52428800     512     0     YES     UNASSIGNED                              
      On Source......
      Select * from v$log;
      
      1     1     18747     52428800     1     NO     CURRENT     2312843322     06/12/2012 11:30:24 AM
      2     1     18746     52428800     1     YES     ACTIVE     2312801897     06/12/2012 11:08:14 AM
      3     2     8814     52428800     1     YES     ACTIVE     2312696533     06/12/2012 10:05:29 AM
      4     2     8815     52428800     1     NO     CURRENT     2312843330     06/12/2012 11:29:58 AM