Streams and realtime apply
- From: Tony Adolph <tony.adolph.dba@xxxxxxxxx>
- To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 29 Sep 2014 17:35:51 +0400
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
Other related posts:
