Hi Sandra,
Your alert log confirms that RTA is on:
Mon Apr 29 19:33:50 2019
Managed Standby Recovery starting Real Time Apply
Check out this note - 1481927.1
Because RTA is on, the standby is always up to date. It does not rely on
archives to arrive before being applied.
So to compare the lag between primary and standby you actually need to look at
the checkpoint_time in v$datafile. The values for each datafile should closely
match on the primary and standby.
Cheers,
Leng
On 30 Apr 2019, at 10:19 am, Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:--
Hi Sandra,
Did you check drc*.log on the standby database? That file is sort of trace
file for Data Guard.
Regards
On 4/29/19 5:43 PM, Sandra Becker wrote:--
We have created a standby database with REAL TIME APPLY, or so we thought.
Everything says it's REAL TIME APPLY, but the logs are not being applied
right away. We have to do a log switch before the log gets applied. I've
recreated the standby redo logs as described in DocID 1956103.1, but it
didn't make any difference. I cannot shutdown the primary for another two
weeks if some change is needed there. The standby I can bounce as needed.
I have 3 online redo groups in both the primary and standby. Due to company
policy, I have had to obfuscate some of the values. Hopefully, they still
match where they should. I'm open to suggestions/recommendations. We would
like to understand what's going on and get the REAL TIME APPLY working as it
is in the other database on this node.
Thanks in advance.
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--
//www.freelists.org/webpage/oracle-l