Re: Streams and realtime apply
- From: Nassyam Basha <nassyambasha@xxxxxxxxx>
- To: Tony Adolph <tony.adolph.dba@xxxxxxxxx>
- Date: Mon, 29 Sep 2014 21:34:55 +0530
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:
