Streams and realtime apply

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_at_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_at_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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 29 2014 - 15:35:51 CEST