Re: Streams and realtime apply
- From: Tony Adolph <tony.adolph.dba@xxxxxxxxx>
- To: Nassyam Basha <nassyambasha@xxxxxxxxx>
- Date: Tue, 30 Sep 2014 10:50:55 +0400
Hi Nassyam,
Thanks for your feedback.
I have tried multiple configurations / attempts to setup downstream
realtime capture. A restriction I have is that the Primary database
cannot have a db link "to" the downsteam database. For the setup /
instantiation I have a db link from the downsteam database to the Primary
database.
When I try:
DBMS_CAPTURE_ADM.SET_PARAMETER(
capture_name => 'STRM_CAPTURE',
parameter => 'downstream_real_time_mine',
value => 'Y');
I get the error
ERROR at line 1:
ORA-26761: Standby Redo Logs not available for real time mining
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 177
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 291
ORA-06512: at line 6
Any pointers appreciated
Rgds
Tony
On 29 September 2014 20:04, Nassyam Basha <nassyambasha@xxxxxxxxx> wrote:
> Sorry for misreading your question.
> I would like to know some *basic *information,
> in order to avail realtime downstream capture, have you performed all the
> necessary steps dblink creation, creating capture using DBMS_CAPTURE_ADM
> and downstream_real_time_mine capture parameter enabled?
>
> Thanks.
>
> On Mon, Sep 29, 2014 at 7:28 PM, Tony Adolph <tony.adolph.dba@xxxxxxxxx>
> wrote:
>
>> Hi Nassyam,
>>
>> Thanks for the feedback.
>>
>> The Remote Site is not in managed recovery mode. Its up and running,
>> only a subset of tables will be replicated to it using Streams.
>>
>> Rgds
>> Tony
>>
>> On 29 September 2014 17:49, Nassyam Basha <nassyambasha@xxxxxxxxx> wrote:
>>
>>> Hello Tony,
>>>
>>> For me configuration looks good and seems to be quiet strange..
>>>
>>> When you start MRP is there any informational messages? The MRP status
>>> shows whether it started with real time apply or not.
>>> If you haven't started MRP as "alter database recover managed standby
>>> database using current logfile disconnect from session", then i would
>>> suggest to start and see and share your observations?
>>>
>>> And can you get output for below query too?
>>> SQL> select recovery_mode from v$archive_dest_status where recovery_mode
>>> !='IDLE';
>>>
>>> What about the size of the ORL on Primary?
>>> How many redo log groups on Primary?
>>> Also add block#, blocks in the same query you have used "select
>>> PROCESS, STATUS, THREAD#, SEQUENCE# from v$managed_standby;"
>>>
>>> Thank you.
>>>
>>>
>>> On Mon, Sep 29, 2014 at 7:05 PM, Tony Adolph <tony.adolph.dba@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi All,
>>>>
>>>> I'm trying to setup realtime downstream capture have missed something
>>>> in the setup as I cannot get the standby redo logs "working". They show
>>>> INACTIVE at all times.
>>>>
>>>> My Env:
>>>>
>>>> Single instance (not RAC) Enterprise Edition 11.2.0.4 on all sites.
>>>>
>>>> Primary Site: ROPSTPOC
>>>> Remote Location: RL1STPOC
>>>>
>>>> ROPSTPOC and RL1STPOC can tnsping each other and archived redo logs are
>>>> getting shipped to RL1STPOC successfully.
>>>>
>>>> ROPSTPOC (Primary Site) settings:
>>>>
>>>> DG_CONFIG=(ROPSTPOC,RL1STPOC)'
>>>> log_archive_dest_1='location=use_db_recovery_file_dest'
>>>>
>>>> log_archive_dest_2='SERVICE=RL1STPOC ASYNC NOREGISTER
>>>> VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=RL1STPOC
>>>> TEMPLATE=/u03/fast_recovery_area/RL1STPOC_arch_%t_%s_%r.log';
>>>>
>>>> RL1STPOC settings:
>>>>
>>>> log_archive_dest_1='location=use_db_recovery_file_dest
>>>> VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)'
>>>> log_archive_dest_2='location=/u05/fast_recovery_area
>>>> VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE)'
>>>> log_archive_config='DG_CONFIG=(RL1STPOC,ROPSTPOC)
>>>>
>>>> On Remote Location: RL1STPOC
>>>>
>>>> alter database ADD STANDBY LOGFILE
>>>> '/u02/oradata/RL1STPOC/stby_redo01.log' size 500m;
>>>> alter database ADD STANDBY LOGFILE
>>>> '/u02/oradata/RL1STPOC/stby_redo02.log' size 500m;
>>>> alter database ADD STANDBY LOGFILE
>>>> '/u02/oradata/RL1STPOC/stby_redo03.log' size 500m;
>>>> alter database ADD STANDBY LOGFILE
>>>> '/u02/oradata/RL1STPOC/stby_redo04.log' size 500m;
>>>>
>>>> On ROPSTPOC (Primary Site) settings
>>>>
>>>> SYS@ROPSTPOC> alter system archive log current;
>>>>
>>>> On Remote Location: RL1STPOC: alert log:
>>>>
>>>> Mon Sep 29 17:21:45 2014
>>>> RFS[2]: Opened log for thread 1 sequence 782 dbid 1309217406 branch
>>>> 856117438
>>>>
>>>> SYS@RL1STPOC> select PROCESS, STATUS, THREAD#, SEQUENCE# from
>>>> v$managed_standby;
>>>>
>>>> PROCESS STATUS THREAD# SEQUENCE#
>>>> --------- ------------ ------------ ------------
>>>> ARCH CLOSING 1 93
>>>> ARCH CLOSING 1 91
>>>> ARCH CONNECTED 0 0
>>>> ARCH CLOSING 1 92
>>>> RFS IDLE 0 0
>>>> RFS IDLE 0 0
>>>> RFS IDLE 1 782
>>>> RFS IDLE 0 0
>>>>
>>>> But the standby logs never get used:
>>>>
>>>> GROUP# THREAD# MEMBER
>>>> SEQ ARC STATUS FIRST_CHANGE# FIRST_TIME MBYTES
>>>> ------ ------- ----------------------------------------------------
>>>> ------- --- ------------ ------------- ------------------ --------
>>>> 4 0 /u02/oradata/RL1STPOC/stby_redo01.log
>>>> 0 YES UNASSIGNED 500.00
>>>> 5 0 /u02/oradata/RL1STPOC/stby_redo02.log
>>>> 0 YES UNASSIGNED 500.00
>>>> 6 0 /u02/oradata/RL1STPOC/stby_redo03.log
>>>> 0 YES UNASSIGNED 500.00
>>>> 7 0 /u02/oradata/RL1STPOC/stby_redo04.log
>>>> 0 YES UNASSIGNED 500.00
>>>>
>>>> Other parts of my Streams setup work, but only when I manually switch a
>>>> log on the Primary site.
>>>>
>>>> What have I missed?
>>>> Rgds
>>>> Tony
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Nassyam Basha.
>>> Oracle DBA
>>> *The Pythian Group * <http://www.pythian.com/>
>>> 11g OCP Certified, Blogger
>>> Co-Author: Oracle Data Guard 11gR2
>>> <http://www.amazon.in/Oracle-Guard-11gR2-Administration-Beginners/dp/1849687900>
>>> Member of Oraworld-team <http://www.oraworld-team.com>
>>>
>>> Visit My Blog <http://www.oracle-ckpt.com>
>>> Let's Connect - Linkedin Profile
>>> <http://in.linkedin.com/in/nassyambasha/>
>>> My Twitter <https://twitter.com/nassyambasha>
>>> My Facebook <https://www.facebook.com/nassyambasha>
>>>
>>>
>>
>
>
> --
> Nassyam Basha.
> Oracle DBA
> *The Pythian Group * <http://www.pythian.com/>
> 11g OCP Certified, Blogger
> Co-Author: Oracle Data Guard 11gR2
> <http://www.amazon.in/Oracle-Guard-11gR2-Administration-Beginners/dp/1849687900>
> Member of Oraworld-team <http://www.oraworld-team.com>
>
> Visit My Blog <http://www.oracle-ckpt.com>
> Let's Connect - Linkedin Profile <http://in.linkedin.com/in/nassyambasha/>
> My Twitter <https://twitter.com/nassyambasha>
> My Facebook <https://www.facebook.com/nassyambasha>
>
>
Other related posts:
