Re: Streams and realtime apply
- From: Nassyam Basha <nassyambasha@xxxxxxxxx>
- To: tony.adolph.dba@xxxxxxxxx
- Date: Mon, 29 Sep 2014 19:19:40 +0530
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>
Other related posts:
