- Oracle Data guard 12c with 1 primary and 1 standby, Max. Av. protection mode
- Primary open, standby mounted (all green in OEM)
- Perform a dummy CTAS in primary
Without opening it, how can I be sure the data has been received by standby? Is there a log, a table, anything, that I can consult in Primary?
select sequence#, applied from v$archived_log;
shows a lot of not applied logs but I'm not sure it is relevant. Also, it does not really identify the query.